• http://ontlo.com/blog Garrett French

    Over at SEJ Ms. Smarty just published an article on exporting search results using SEOQuake:
    http://www.searchenginejournal.com/export-google-search-results-to-excel/11253/

    I’ve not used SEOQuake for this, but it appears to work well as a potential alternative to exporting SERPs with SEO for Firefox, which I outline above.

    G

  • http://www.planetc1.com/ chiropractic

    Very sweet! Read through this 3 times already today and got 2 really good tips I was not yet applying. Thanks for getting into details.

  • http://ontlo.com/blog Garrett French

    @chiropractic – great! Glad to hear that the detailed analysis helped spark ideas for you :)

  • Jen

    I have read it 4 times and I still don’t really get what this Raw 100′s is all about.

  • http://ontlo.com/blog Garrett French

    @Jen – “Raw 100s” are the exported urls of the pages that appear in Google’s top 100 results for a keyword.

    I called them raw because they’re not super useful as a long list of 100 urls… This raw data is much more useful when analyzed along with the 100 urls from other keywords you’re targeting with your site.

    Getting the urls in exportable format (so you can put them in a spreadsheet) requires using the method I describe above, or the one that Ann Smarty talks about here:
    http://www.searchenginejournal.com/export-google-search-results-to-excel/11253/

    The most important thing is that you’re analyzing the SERPs for your target, most valuable keywords. In the example I analyzed the SERPs for camping equipment related data. Note that they’re all “high level” or “big head” keywords, as opposed to longer tail terms. Further, they’re all highly-competitive commerce-related keywords. When conducting your analysis it’s very very important to group your keywords carefully around your business goals.

    Let me know if that clears things up for you, or if I should go into more detail on anything :)

    G

  • pcsourcepoint

    Thanks for the tutorial, as I am trying it out for keyword research on “Auckland Hotels” for my blog. However, half the Google Serp’s for the first page are Sponsored Links and “Local” business results. Then the list of standard results.

    What results then would qualify for the first raw 100 urls? The keywords are highly competitive, and the ad value are relatively high (according to Google keyword tool). Therefore possibly any of these links would substantially offer similar information, hence a visitor could possibly gain the same value of information, by clicking any of the links on the first page. Therefore in this case would the top 3 url’s be applicable? (e.g. a lone sponsored site (wotif.com) could be more valuable than any other url that appeared more than once (should that occur). I mean the presence of sponsored links might distort things a bit (I think), depending how they qualify with Google to be listed in the serps?

    Also for Yahoo’s back links results, I think many are self duplicated, but perhaps briefly. Once I left one comment and my blog’s URL on a site, but checking Yahoo back links that one comment seem to generate dozens of back links over several weeks via sub urls/domains linked to the original commented url. Then checking weeks later, they all, but the original one disappeared. Yet with Google – no such back link for that comment?

  • http://ontlo.com/blog Garrett French

    @pcsourcepoint!

    First off, you should try multiple keywords. One keyword isn’t going to give you enough data to work with. It’s the sites that rank consistently for a related body of keywords that are the true SERPs Dominators!

    To answer your question about including business/local results I think you can just stir them into the pot and see what turns up (I mean, include ALL of the top 100 results by exporting them in one lump). If you’re searching for [Aukland Hotels], [Aukland Motels], [Aukland Accommodations] etc you will get tons of local results. The consistently occurring local results, in addition to everything else that shows up, then become prospects for pulling backlinks, trying to guest post, leaving comments etc…

    You’re right in asserting that the sites – for a single keyword query – that appear in the top 3 will likely have higher value to your competitive analysis. However, I will reiterate the importance of searching for 5+ related terms rather than a single term, and looking at the top 3s, 10s, 20s and 100s to get a full picture of what’s happening in the space you’re targeting.

    Good luck and let me know if I can drill down into anything for you to clarify!

    Garrett

  • http://www.intellenglish.com ingilizce ian

    great article. very detailed, water-tight process. will definitely try some of these methods for my market.