Update to PPC Click Tracking Script for Yahoo and MSN…

Published December 14, 2007

Sorry for the long time between posts. Just things have been very busy lately. Here’s an update to the click tracking code for tracking your conversions to include yahoo and msn pay per click. I just pulled this direct out of my system. This also includes a way to exclude bots by IP. Using the list from iplists.com I in a file called ip_list.txt in the same directory as you tracking file. So that your tracking doesn’t record bot visits. Below have included the updated sql schema for click tracking, it’s a little messy and could be better but just haven’t had time to improve it. If someone has a better click tracking schema around I’d be interested in seeing it.

So our urls to use to track

Yahoo Search Marketing:
http://www.yourdomain.com/index.php?s=ysm&n=1
To make this work properly you need to enable tracking URL’s in your account. This will pass all the appropriate variable automatically.

Google Adwords:
http://www.yourdomain.com/index.php?s=ggl&qs={keyword}&k={keyword}&n=1
This could be improved to scrape the query out of the referer and use that for the Query String in the table, it’s on the list.

2 Comments

It’s setup to work with Directtrack. As I mentioned I ripped this directly out of my system so there’s some stuff in it that doesn’t function with this script. What it’s there for is I have a script that I dump the advanced stats from directtrack and then it imports them into the table. THen I have another table to match up the clicks with the conversions so I can see what words are converting.