Mashing data from Google trends, Google Keyword Tool and Search results
Mashing Data Together – How one company managed
to put cost per click,
Google estimated traffic, search
trends and number of results in Google into
one simple excel sheet. Brilliant!
| Case Study – SEM Rush tool put together by Michael Goldfinch.
By Dan Deyette – I’ll show you the tool, what it does and my unbiased view on the utility. |
 |
||
| I remember when getting data out of Google and into Microsoft Excel or any other software required serious coding skills or a linux box and a 6 pack of Coke. It was a real challenge and most of us who had any kind of computer skills and wanted to harvest data from Yahoo/Google would simply copy & paste and then play with the data.
Times are changing, quickly. More sites are "Mashing Data" to make their own tools, software and competitive intelligence is getting MUCH easier. So easy in fact, that SEM Rush has leveraged API’s and integrations to borrow some data from different parts of google and "Mash" them all onto one page of results for easy reading! Let’s give some examples… Say I want to know who the top websites getting traffic on the internet today are. These would be great places to advertise, try to get links from or even just study as a business model, wouldn’t you agree?
I know, this report got a little "blurry" but check it out. Woudn’t it be nice to have the "seasonality" of Google Trends data on the same excel sheet with your search volume and other stats? Let’s break it down:
In case you hadn’t noticed, the wonderful thing about Google Trends is that it shows you whether your recent drop in traffic or gain is because of worldwide conditions or your rankings. It shows you how much "volume" any phrase is getting in relation to the last few years, and geographic regions. What Trends DOESNT do by itself is give you a number. An exact number, like "there were 3,000 people yesterday". It simply says, it’s way lower last month and much higher this week.. Helpful but not as helpful as an actual number. With an actual number, you can sit back and calculate things like potential ROI or conversion rates or market share potential. Having an idea of the cost per click in relation to seasonal high’s and lows and results in Google makes a lot of trending and analysis alot easier. If this tool stopped here, I’d never have posted this writeup. But trust me – It doesnt! Go play with it, the free version has TONS of features worth noting. The usages are endless. Check out SEM Rush today. You’ll be glad you did.
Their tool does quite a bit more, and adds more value to your reports if you send weekly or monthly client reports or need to spice up an up coming presentation. Sincerely |
|||
