redirect tracking system


In general, we need a simple tracking redirect system. that will get clicks comes from the google network, save a specific parameter data into the db, encode the data parameter and redirect it to the advertiser

in depth:

Redirect system

1. Structure: Click URLs will come from google network in the following format

[url removed, login to view]

dp= data will be separated with under line _

First from the left – adgroup number

creative name

website domain


a. Save DP data to DB: the redirect system should save the DP data into a simple DB that will contain the following fields

Encode code | Adgroup # | creative name | website

b. Encode the dp= data: The redirect system should get the dp= data, encode it with using only alphanumeric chars

c. Redirect to advertiser – this is very important – must be fast, not be delayed by any reason, even if it cannot write to DB or god knows what.

3. Report + export to csv

a. In our domain, we will have user+password access to a report with the following data. – see sketch attached

b. Data should be saved for a month and deleted automatically. So we will have only 1 month data in the system

c. Data should be aggregated to encode code level

d. Select time period, from  to

e. Export to excel – csv, same columns as in the report

Important comment – data parameter can be either dp= or sub= and maybe more in the future

Here are some clarifications and 1 change to the above description:

First - we want to remove the table - we will need only a date selection and export to excel button, without any table building.

Secondly - section 2 in my description - FLOW part
Currently we are working with 2 advertisers. each of them have a specific URL structure

Domain part - static, will always be either or
Campaign code - dynamic part and can be different with each click
DP= or sub=, dynamic - will usually will be different with each click

I would it to work like this:
a. we will send clicks like this -
b. your php file should re-structure the outgoing link by the parameters we filled in, and will of course encode the outgoing data parameter (DP= or sub=)

excel stays as before, but i forgot to add CLICKS column in the description although its in the attached mokeup - aggregate data of Encode code | Adgroup # | creative name | website | clicks


Skills: HTML, MySQL, PHP

See more: write to cnn, what is network flow, what is dp, what is a network flow, what is a dp, only dp, no dp, network flow data, network flow, network data structure, name flow, flow network, flow in network, dp only, dp number, dp first, depth first, comment system in php, a dp, tracking system redirect, tracking system redirect format, google sketch it, tracking, tracking number, time-tracking

About the Employer:
( 4 reviews ) Raanana, Israel

Project ID: #1109866

Awarded to:


experienced php developer, please check PM for details

$350 USD in 5 days
(160 Reviews)

6 freelancers are bidding on average $408 for this job


hi kuntzman, We can start working on this. I have done redirection system almost like this. Thanks

$300 USD in 7 days
(3 Reviews)

.net/php experienced

$500 USD in 5 days
(1 Review)

we have a team of 25 members with expertise in their profession. We have made a similar kind of projects. For further information please view your PMB. Ready to work with you Regards.

$500 USD in 5 days
(0 Reviews)

I am very much interested to do this. I have knowledge & experience with web site [url removed, login to view] very comfort to do your project.

$250 USD in 3 days
(0 Reviews)

please check pmb for more details,Thanks

$550 USD in 15 days
(0 Reviews)