Keyword research is a vital component of SEO. Part of that research usually entails finding the most frequent modifiers for a keyword. There are plenty of ways to do this but here’s a new way to do so using Google Refine.
Google Refine is a power tool for working with messy data, cleaning it up, transforming it from one format into another, extending it with web services, and linking it to databases like Freebase.
I’ve been poking at Freebase for years thanks to Chris Eppstein and think that it was one of Google’s smarter acquisitions of late. But I just returned to Google Refine as I embarked on some keyword research.
Lets say you have a site that sells boots. Clearly the term ‘boots’ is one of the root (or main) keywords for the site. Finding keyword modifiers can help you match query intent to products and site content. Modifiers can be applied to SEO and PPC campaigns.
There are a number of keyword tools but I’ll use Google in this example.
There are 794 keyword suggestions and many of them overlap with one another. I could wade through them in Excel and apply some sort of filter or toss them into a Pivot Table but Google Refine actually makes this much easier.
Install Google Refine
You’ll need to download and install Google Refine and then point your browser to http://127.0.0.1:3333/ to get started.
Create a Google Refine Project
Browse for and select that downloaded keyword file, type in a Project name and click Create Project.
At this point it’s a lot like having a pre-formatted Google Doc. But that’s where the similarities end.
Apply a Word Facet
Google Refine comes loaded with a massive amount of intelligence. What I’m going to show you is probably the least sophisticated part of Google Refine. Select the Keyword drop down arrow and navigate to Word Facet. (Facet > Customized facets > Word facet)
You’ll quickly get a new pane on the left hand side showing the result of applying this word facet.
Sorting a Word Facet
Google Refine is telling me that it’s narrowed those 794 rows into 497 choices and ordered them by name. But instead I want to learn about the most frequent modifiers. No problem. Just sort by count.
Just like that I get the most frequent modifiers for the term boots. You still need to apply some smarts to understand why ‘for’ might be listed or how ‘high’ might be used as a modifier. But it’s a super quick way to get an at-a-glance perspective.
Word Drill Down
If you’re having trouble figuring out a specific word you can just click on the word to get a sample of those keyword terms.
Who knew wide calves were such a problem?
Google Refine and Keyword Research
Google Refine doesn’t replace other SEO tools. Instead it’s just another tool on your tool belt. That said, I have only showed you a fraction of what Google Refine is capable of. In particular, there are some very interesting clustering algorithms that could be applied to keyword research.
I’m just getting started and will keep playing with (aka learning) Google Refine to see just how it might streamline keyword research.