I stumbled across this cool tool over at wordze during my web travels today. I’m not sure how new it is but since it only goes back to January 8th I assume it’s relatively new. Either way it’s new to me.
The tool lets you download Google Trends top 100 searches for every hour, of every day from January 8th to current. It seems to be almost real time too. Within an hour or so..
Here is a sample of the top searches from this morning.
Keyword Rank Date & Time
- chicken and waffles #87 2008-02-24 07:10:03
- chicken and waffles #88 2008-02-24 06:10:02
- chicken and waffles #49 2008-02-24 00:10:01
- chicken and waffles #80 2008-02-24 01:10:01
- chicken and waffles #58 2008-02-24 03:10:02
- poltergeist #13 2008-02-24 00:10:01
- poltergeist #39 2008-02-24 04:10:01
- poltergeist curse #53 2008-02-24 00:10:01
- poltergeist curse #89 2008-02-24 01:10:01
There are apparently some hungry, haunted people out there. 
There is one problem I have found with it though. They send it to you in an Excel file.
That isn’t a necessarily a problem other than the fact that the database contains 111,000+ search terms, and anyone who uses excel knows that it can only handle 65,000 rows. That issue is overcome easily enough using one of my favorite tools, Microsoft Access.
I just change the file extension from .xls to .txt, import the data and viola, a search-able list of the top 100 searches for every hour, of every day for the last two months! It’s a really neat tool that you can use to find that hot new product to that everyone is searching for.
(No Ratings Yet)
Loading ...
