In Progress

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

Skills: HTML, MySQL, PHP

See more: write cnn, only dp, no dp, network flow data, network flow, network data structure, name flow, flow network, dp only, dp number, first time, dp first, depth first, a dp, tracking system redirect, tracking system redirect format, tracking, tracking number, sub system, sketch report, sketch 3, get clicks, data encode, d tracking, click 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 development.So 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)