Experience Level: Expert
Ideally we need someone who has setup publisher/affiliate side tracking systems before. This is very urgent so please don't quote unless you can start within 24-48 hours. Please also give an expected completion date as well.
We own a number of affiliate sites which are built on a custom template. On each site we have up to 10 different affiliate partners on each site. We need to record campaign information from the clicks entering the site. Such as recording the keywords which referred them or perhaps the type of banner. This will help us optimise our advertising campaigns.
We need you to first setup a basic cookie which gives each site user a unique user id and session id.
If they return to the site they keep the same user id.This should be stored in a database.
We then want you to create a script, that will capture unique information from visitors landing on our website.
We will populate the querystring and we want you to extract the following information from the query string when the user reaches the site.
We need you to record this information against the session id.
You also need to record the following:
Time (you need to use timestamp)
Date (you need to use timestamp)
Hash of session id
This should be recorded in a database table using the hash of session id to update the row in the database?
If the user clicks out of the site the following information is required to be added to the database.
Page Name e.g index.php
Link Position (each link on the site needs to be labelled with a position) e.g. 1, 2, 3 or 4
Clickthrough Time (set a new timestamp)
Clickthrough Date (set a new timestamp)
Hash (MD5/similar encryption of session id)
We want you to use this "hash" in our affiliate tracking links. Our affiliate links have a parameter for unique references we need you to come up with a solution so our "hash" value substitutes in place for each user when they click through to our affiliate partners. The affiliate link only redirects on an interstitial page.
The variable names don’t really matter they should be short and related. E.g for ad position you could user "adpos=1"
We also require the ability to get daily CSV reports on the data emailed to our systems. We will then take this CSV and use within our reports system.
Now because we want to implement this solution across multiple sites can you suggest a suitable solution which is fast and won't require ongoing maintenance? We can setup databases and users and are comfortable ftping and editing code. Any solution has to be for a PHP/mysql system.
We are very open to discussing different solutions which may be more suitable, so please suggest an alternative if applicable.
Peter O.100% (24)
3 Dec 2014
Login to your account and send a proposal now to get this project.Log in
Clarification Board Ask a Question
There are no clarification messages.