Posts Tagged ‘Keywords’

The $100 Million Dollar Google Slap

Wednesday, March 12th, 2008

A really interesting story about a guy that built his $100 Mil per year company entirely on PPC Arbitrage.

A record $160-million VC investment. A rich Web strategy. A quirky founder. For a few weeks last spring, Guelph, Ont.’s Geosign had it all. Then mighty Google stirred. And it was over.

You can read the whole story here.

Download Googles Top Search Terms

Sunday, February 24th, 2008

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.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...