Hi,
I need a tracking/redirect script that works like this:
1) I send the surfer to http://domain.com/lander.php?c=CAMPAIGNHERE&k=KEYWORDHERE where KEYWORDHERE is an actual keyword I’m passing to the url and CAMPAIGNHERE is the name of the campaign.
2) The script then converts the value of $k to a 6 digit numeric code and the campaign it can leave alone…the campaign will never be more than three letters.
3) The script stores the real value of $k and its corresponding numeric code along with the campaign in a database and logs one visitor for that keyword and campaign.
4) The surfer gets directed to http://domain.com/lander2.php?s=abcd123456
where 12345 is the numeric code and abc is the unaltered campaign name. That’s it for the redirection.
5) I need to be able to see, in a password-protected backend, each value of k, its campaign, and how many visitors it got. So it would look like this:
Campaign Code Keyword Visitors
abcd 523483 buy widgets 41
abcd 238913 widget coupons 28
I should be able to search by campaign if I want to. So I could get all the stats for campaign ‘abcd,’ all the keyword for campaign ‘defg,’ etc. and only see those keywords.
Some things to keep in mind:
- $k will sometimes have spaces, *, -, and . in it. So the script will need to still work if there is a space or an asterisk or a dash or a period in it and still correctly perform the redirect. There will never been an & in $k, though.
- The backend must be password-protected. No need for usernames though. I’m the only one using it. I should be able to change the password in a config file somewhere.
- There will be around 10,000 visitors per day hitting this script. So keep the code as lean and efficient as possible.
- This is probably obvious, but the script needs to check to see if that keyword code already exists. If the keyword code already exists, don’t add a new one, just count a visitor for that keyword. If the keyword code does not already exist, then you have to create a new one.
- It is possible for campaign abcd and defg to have the same keyword. In other words, “buy widgets” could exist in both campaign abcd and defg. So the script will need to take that into account…the stats would have to be separate still. Don’t add visitors to abcd’s “buy widgets” if campaign defg is sending them. They should be considered two separate keywords.
- This is optional, but you will probably want to store the values in the database as abcd539214, defg458394, bleh941102. That would ensure that abcd100000 and defg1000000 are different. But however you want to do it is your call.
- Campaign will never be more than 3 letters and keyword code will never be more than six digits.
Any questions, free free to ask. Will you pay with escrow, and I’m available through email or AIM to talk to you.
[btw, those shouldn't be &'s above, they should just be the 'and' sign, scriptlance doesn't let you post the sign in here]
