Log Analysis - Verification of Billed Clicks

[Jas0n]

I include tracking URLs (?source=overture&kw=widget) for my Overture and Google PPC ads and would like to be able to just go into my logs each month and do a verification on the number of click-throughs from the services (at least make sure they numbers are close).

I'm not looking for one of those bid management type services or codes to put into my pages, or to directly track click-through sales yadda yadda.

I just need to be able to count the URL referrals for each PPC service and possibley run some aggregate counts for the KW's.

I use WebTrends for log reporting now but have had some difficulty using it to be able to segregate out the PPC referrals since there seem to be limits as to how many URL referalls it will list in reports (I think 30,000).

Any ideas. I've tried importing logs into Excel but too big, had difficulty importing into Access (I could easily segregate them in these by searching the referral strings for *source=overture* or *source=google* etc...).

TIA.

Jason

[jeremy goodrich]

You could do a javascript call or some such to a seperate logging script which records the page view(s) *only* if it has the?track=adwords&keyword=foo-bar etc.

And you could also take it a step further, having the javascript log to one file for the adwords clicks, and a seperate one for the overture stuff...

Hope that helps!

[rharri]

If you are hosted on a Linux machine, you could do
cat /logfile ¦ grep source=overture ¦ wc

For example, this would give you the number of lines with source=overture.

[Jas0n]

Both interesting ideas -- thanks!