Top Paying Keywords - CloudSearch
This is a quick hack that took a morning to knock up - I hunted out some adsense/adwords keyword value data after building the SEO News page for Tim Rendle
Here's a sample of the type of data I started with - the top ten adwords by price and the bottom ten adwords by price.
| Top 10 Keywords by Price | |
|---|---|
| austin dwi | 66.89 |
| austin dwi attorney | 58.30 |
| auto insurance quote | 57.18 |
| san diego dui attorney | 54.56 |
| college loan consolidation | 53.52 |
| medifast weight loss | 48.18 |
| houston criminal attorney | 47.44 |
| car insurance quote | 46.89 |
| federal loan consolidation | 46.62 |
| auto quote | 45.01 |
| san diego dui | 42.83 |
| Bottom 10 Keywords by Price | |
|---|---|
| international cell phone rental | 10.49 |
| spyware removal | 10.49 |
| vehicle laptop | 10.32 |
| monte casino | 10.25 |
| verizon wireless com | 10.18 |
| rental cell phone | 10.12 |
| spyware blocker | 10.09 |
| spyware remover | 10.09 |
| sprint cell phone service | 10.07 |
| dsc p10 digital camera | 10.05 |
This is a spin-off from the BookClouds project, which is a small mashup using Google News, ZoomClouds and Amazon ECE
I dropped the keyword list into Excel and removed the duplicates. A quick and dirty two-column CSV->XML PERL program later I had an XML file in the format used by ZoomClouds - which I already have tools for.
To finish I modified an XML->JavaScript program I use for maintaining the internal links on the tagcloud use by my weblog
This cloud view uses the value of word to define the font size and colour - keywords with higher value are larger in size, and when you mouse over the words a little tooltip comes up and tells you what things are supposed to be worth
Disclaimer: This is a prototype - the data is not up to date and will go out of date very quickly - use at your own risk.
