Could anybody help here as we are looking for an application to run on hosted server eg php and mysql To monitor and track AdWords / MSN campaigns and we wish ro see which keywords which were use by the vistior entered in real time for the searched Or does any body have a scripts that we could use to collect such data As I reading the http log files and need export them each time
I use statcounter and whatcounter. Statcounter is very clear and easy, and gives you what keywords and search terms were used in an easy to read manner, but I need the whatcounter to see what sites with google ads were clicked on. To answer your other question - I can't think of any way to see where the impressions were if nobody clicked on them.
But my firiend the goodle stats is not in real time and take ages to update so I need it locally to get the fast responce Can we pull off any other bits of information apart from {keyword}
Also, Statcounter will only show you the last 100 searches in the free version. If you are selling affiliate products on your site you might want to check out xtremeconversions. It will allow you to see which keywords that were actually typed in generated sales of affiliate products. You could also write a small PHP script that just extracts the referrer and write it into a table or even a file. That would be real time.