Affiliate side tracking system -recording keyword data
- or -
Post a project like this4032
£200(approx. $249)
- Posted:
- Proposals: 1
- Remote
- #226467
- Awarded
Description
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.
User ID
Session ID
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.
Keyword
Ad Group
Ad ID
Ad Position
Campaign
Publisher
Channel
Site
We need you to record this information against the session id.
You also need to record the following:
User id
Time (you need to use timestamp)
Date (you need to use timestamp)
Session id
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.
Merchant ID
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.
Thanks
Peter
Peter O.
100% (24)Projects Completed
25
Freelancers worked with
21
Projects awarded
56%
Last project
3 Dec 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies