Keyword Research With Ubersuggest and ImportXML

Thanks to Richard Baxter - oh, whoops, Wrong Richard Baxter… (ahem)… Thanks to Richard Baxter… uhhhh… wrong again… here we go…. Thanks to Richard Baxter, I was recently turned on to Ubersuggest. Ubersuggest is a powerful keyword research tool that allows you to extract all the the “Google Suggest” searches that show up automatically, as you begin to type your query.  Just want to share one particular use I found for this tool, a little trick with ImportXML and maybe it will help some folks out.

[hr]

I was doing keyword research for an informational topic. I needed to find keywords for all the things people try to quit (bad habits, like smoking etc). Not your typical product or service type keyword research, where you have something concrete and broad to start with (like ‘cars’) in which you can just drill down and get more specific as you go, adding adjectives and so forth.

This is a case of “you don’t know, what you don’t know” keyword research. I don’t know what all the things are people are trying to quit. Enter Ubersuggest. Check out the screenshot:

Ubersuggest Results for “How to Quit”

Jackpot. After entering “how to quit”, it returned literally over 200 results. And you can even click on each individual result to drill down more. And the cool thing is, since this is coming straight from Google Suggestions, you know there is decent search volume.  Let’s verify that though:

Search Volume for Top Seven Google Suggest Keywords

The only catch?  How do I get the 200+ keywords from Ubersuggest into a spreadsheet?  Enter ImportXML. I love you ImportXML. Let’s never be apart…

[hr]

Putting Ubersuggest and ImportXML Together

For those still gettin’ together your ImportXML chops (like yours truly) here’s what cha do.

1. Grab Your Ubersuggest URL

 

2. Here’s the ImportXML Command

=importxml(A3,"//div[@id='result']//li")

 

3. Getting It Into Google Docs

 

Saweeeeet!!!  Hundreds of decent volume keywords I may have never known about.

4. Clean ‘er Up

So NEXT, what I did was get that raw list sorted and categorized. I also of course ran them all through the keyword tool to get search volume. Check ‘er out – nice and shiny:

Bad Habit Keywords Sliced, Diced and Sorted

[hr]

Conclusion

Besides feeling depressed after seeing how many people in this world are addicted to something, what I ended up with was a nice list of eleven core categories of things people try to quit (according to what’s searched for most) and dozens of great long tail variations for each.  This is honestly where my excel skills fall short though (for now). I had a quick Twitter Chat with the infamous Mike King aka iPullRank and Aaron Friedman about some ideas for being able to to a “FuzzyVLookup” to quickly sort through large amounts of keywords, when you don’t know exactly what those keywords are yet.  Something to explore for later for sure!

Hope this was helpful to some, please let me know what you think, let’s get the comments going on this blog!!

About Dan Shure

I'm Dan (Google Plus Profile). I've been helping businesses improve their websites since 2007. Improving your bottom line is my number one goal. My obsessive nature and love for SEO as a true craft doesn't hurt either.

10 Comments

  • October 7, 2011 Reply

    richardbaxter

    • October 7, 2011 Reply

      Dan Shure

      Thanks for checking out the article Rich! Love that post on SEOmoz.

      -Dan

  • November 4, 2011 Reply

    Teodora

    Great, thanks for sharing! I have noticed though that some of the suggestions do not report any traffic in the google keyword tool.

    • November 4, 2011 Reply

      Dan Shure

      Yes, you are certainly correct, I also don’t always see search volume for every suggested keyword. But I do find it very useful for helping me to rapidly come up with related keywords I may never have thought of. Thanks for commenting!

      -Dan

  • March 21, 2012 Reply

    Dean Cruddace

    Cheers for the post Dan,

    The only thing I could really add is the way the URL is set up to fetch from Ubbersuggest. Rather than conducting a search each and every time I have set mine up to reference a cell and just enter my keywords in that cell like;

    =importxml(“http://ubersuggest.org/?query=”&A3&”&format=html&language=English%2FUK&source=web”,”//div[@id='result']//li”)

    Other than that I am highly addicted to ImportXML and Xpath just because it offers up some decent insights very quickly.

  • February 13, 2013 Reply

    Noahs Dad

    Great post Dan!

    I was looking for some ubbersugest tips online and your site was one of the first ones that came up! #Winning

Leave a Comment

Error: Please check your entries!