The AdCenter plug in for Excel is now available in beta form on the AdCenter blog. I've not had much time to play with it yet and it is VERY US-Centric but from first impressions it looks amazing.

Setup is really simple, just download it and run the setup file. When you next run Excel you'll see a new tab for "Ad intelligence". click that tab and there's a whole bunch of tools for keyword research, performance data, demographic data, click cost and position estimates etc.


Some of the more funkier stuff includes...
"Keyword extraction" where you can enter some site urls in excel and the plug in will tell you the keywords used by that site.

"Search Buzz" shows you the top "spikey" keywords. Now if you've no idea what a spikey keyword is... where've ya bin? A spikey keyword is one where there is some external factor that causes a spike in traffic during a given period. Take "Travel Agents" as an example and the plug in will tell you that "Thomas Cook" has a Spikey index of 5378 and the spike occurs between the 6th and 7th of January (ok so maybe a little more work needs to be done on it but it's till just a beta).


The monthly traffic volumes option is great. Highlight a keyword and the plug in will give you traffic data for each month (past and future).


A lot of this stuff you can get already at adcenter labs but it's great to have it locally in Excel.

This entry was posted by Dave S Dibble, on Wednesday, January 09, 2008.