Need Some Help From PPC & Regex Gurus

Status
Not open for further replies.
Deliguy

Deliguy

New member
Sep 27, 2006
5,162
195
0
Oregon
Word up,
wasn't sure where to post this but i got a wicked good question for ya.
I put up a post on some awstats hack
Blue Hat SEO-Advanced SEO Tactics » Awstats Hacks

I got a really good question about it. Is it possible to use the same awstats hack to monitor your ppc traffic? Since I've never done PPC before I really have no idea how the PPC traffic referrers display in the combined logs.

I"m looking for a way to make a table that displays how much traffic comes from your different ppc campaigns. For instance if the referers show up as ads.google.com and clicks.peakclick.com (just throwing them out there) i'd check for clicks from the domain ads.google.com OR clicks.peakclick.com and put those in as the variables in the conditions grab and pass it to the ColumnValuesX
ExtraSectionCondition1="REFERER,^http:\/\/www\.google\.[^/]+\/search\?.*q=.*$"
ExtraSectionFirstColumnValues1="REFERER,[?&]q= *([^& ][^&]*[^& +])[ +]*(&.*)?$"
Click to expand...
thats googles referer example

I want it to show up as
Campaign.........Clicks...........Percentage.............Last Visit
Adwords..........100..............10%......................thedate
Peakclick..........99...............9%.......................thedate

I hope that made sense :)
I know theres some awesome PPC and arbi gurus here. Anyone got any ideas? If i figure this out i'll post it up in the comments, and then i'll make a wickedfire exclusive tool for the resource area where you can add your own campaigns through a form and it'll automatically generate the awstats code. If you don't know the regex portions thats alright i can figure it out. but if you guys in the know could donate some referrer examples from different ppc campaigns for this project that'd be awesome.

I'm not even sure this is possible.

Thanks
 


Here's an example:

69.243.7.80 - - [04/Jan/2007:00:48:03 -0600] "GET /?gclid=CLjg-cGVxokCFRUPVAodI0IuPQ HTTP/1.1" 200 2982 "http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-9026315184292199&dt=1167893267109&lmt=1167893267&alt_color=570C02&prev_fmts=234x60_as%2C234x60_as&format=234x60_as&output=html&url=http%3A%2F%2Fwww.referringUrl.com%2F&color_bg=570C02&color_text=7C7C7C&color_link=E43C89&color_url=B7DE41&color_border=570C02&ad_type=text&ref=http%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3Dkeyword%2Bphrase%2Bgoes%2Bhere%26hl%3Den%26lr%3D%26rls%3Dcom.microsoft%3Aen-US%26start%3D10%26sa%3DN&cc=100&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_tz=-300&u_his=14&u_java=true" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)"
Click to expand...

Googlesyndication.com is what you would look for when parsing the file. The referring URL and keyword data also comes through. PM me if you want a test log file with a ton of AdWords logs, I have one from an old crap site that you can look over.
 
Thanks man thats perfect. I can figure out adwords from that.

anyone got any other examples of different ppc programs? I'd like to get as many as possible.
 
Oh and that previous example was for content clicks. A referring URL straight from Googles AdWords (search) can look something like this:

68.105.227.163 - - [17/Jan/2007:12:04:53 -0600] "GET /directory?gclid=CJPghoaF6IkCFR1EWAod2imFKA HTTP/1.1" 301 365 "http://www.google.com/search?q=keyword+query&hl=en&lr=&rls=HPIC,HPIC:2005-23,HPIC:en&start=20&sa=N" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; SpamBlockerUtility 4.8.0; IEMB3; IEMB3)"
Click to expand...
I suggest adding a tracking variable to any AdWords campaigns to deliniate the difference between organic traffic and AdWords traffic.
 
Actually... it looks like the gclick variable is only on adwords campaigns.

Organic searches look like this:

24.158.120.31 - - [08/Jan/2007:15:39:27 -0600] "GET / HTTP/1.1" 200 2982 "http://www.google.com/search?hl=en&q=keyword+phrase" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727)"
Click to expand...
Although, it's still good to add the variable just to be certain.
 
Status
Not open for further replies.
Top Bottom