Affiliate side tracking system -recording keyword data

  • Posted:
  • Proposals: 2
  • Remote
  • #226467
  • Awarded
James B.
Pete D. have already sent a proposal.
  • 0


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.

Ad Group
Ad Position

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.


New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.