SEO

25+ sites giving keyword data for free & how to use it to drive SEO success

A topic I touched on while speaking at Pubcon last year was using other people’s data to help you in keyword research. In that presentation I illustrated how so many companies put their data “out there” with links to popular searches, and thought it would be helpful for many of you to have a list of some of these sites 25+. Sure it is one thing to see something get hot on Google trends but what if you are in a Hispanic market, a sports market, a travel market, how can you use OPD to help you?

#1 – OPD helps you to uncover trends
#2 – OPD helps you gain some competitive insights into your foes
#3 – OPD gets you insights into topics that you could write about to your blog to take advantage of surging traffic

What can naughty by nature teach us about other people’s property (data) as well OPD how can I explain it!

 

So lets start with an easy one like Amazon:
With this information you can easily see the top sellers in any category, if your web site is strollersdirect.com and you decide that you’d like to list out the top 5 most popular baby strollers – you could do that based on the data you have or you could use a site like Amazon’s top sellers for Baby Travel Systems which is updated hourly to make sure you are using the most popular strollers in your top 5 or top 10 list every day.

If you are still thinking, how does this impact MY SEO strategy, then here’s another angle:

Most websites SHOULD NOT list the top 30-40-50 or more products on the homepage, why? It kills your internal link juice flow, and often looks like crap – using amazon’s best sellers at any point you can update your top 5 or 10 to be in accordance with what is likely a much larger data set meaning it is likely to be more accurate.

Here’s another few in many shopping categories:
Shopping General – http://www.mysimon.com/9098-1_8-0.html
Shopping General – http://www.shopping.com/top_searches (page no longer active)

But some of us are in totally different categories not general e-commerce, all is not lost here are some others that should help:
Programming – http://corp.koders.com/zeitgeist/ & http://koders.com/info.aspx?page=LanguageReport&la=ruby
Halloween Costumes – http://halloween-costumes.spirithalloween.com/
Healthcare caregivers- http://www.healthcentral.com/caregiver/top-searches.html
Healthcare cholesterol – http://www.healthcentral.com/cholesterol/top-searches.html
Healthcare breast cancer – http://www.healthcentral.com/breast-cancer/top-searches.html
Healthcare Top searches 2007 – http://www.webmd.com/a-to-z-guides/features/top-10-searches-2007
Healthcare (look right) – http://www.healthcare.com/popular-searches/
SEOmoz Meta popular search – http://www.seomoz.org/popular-searches
eBay Pulse – http://pulse.ebay.com/
Local results – http://la.backpage.com/online/classifieds/PopularSearches (just swap LA with Connecticut, new York, etc)
Fashion / shoes – http://www.roadrunnersports.com/rrs/popularSearches/PopularSearches.html
Fashion / shoes – http://www.zappos.com/Search (look under the search bar)
Beauty – http://search.ulta.com/
Sports – http://search.espn.go.com/
Sports (monthly) – http://sports.espn.go.com/espn/news/story?id=3872535
A great way to get story ideas
Travel – http://search.travelchannel.com/

So to Recap, use this data to:

#1 – uncover search trends on other sites to augment your data or use to influence top 5,10,20 lists
#2 – gain some competitive insights into your foes, what are people seeking the most, which products, brands, etc let this help you develop strategies to outrank them for terms that people are looking for on their sites
#3 – get a spark on new topics to write about, blog about, and in general get links for by understanding what trends and words are getting hot in different niches

How else can this data be used? Let me know what you think.