What’s the Best Way to Group Keywords

Posted:  December 9th, 2011 by:  keywordgrouper comments:  Comments Off

Many Search Engine Optimization (SEO) Specialists and Search Engine Marketing (SEM) Professionals often find themselves grouping or categorizing keywords into common themes.  This type of work usually takes a lot of time and requires a lot of manual sorting and sifting keywords around until they come up with the right groups.

What makes keyword grouping hard is that many times you will find keywords that can be grouped into several buckets which causes a mental conflict.  When this happens, you have to make a judgement call as to what part of the keyword is MOST important and put it into the most relevant group.

Take for example a keyword like “Allstate car insurance Minnesota“.  It has three conflicting components such as [BRAND] [NOUN] [GEO-LOCATION].  Let’s say you have a Branded group/Adgroup called Brand-Allstate, another called Car Insurance and another called Minnesota.  How do you determine the best group for this keyword?

It really comes down to a judgement call because the keyphrase could fit into all three groups.  From experience though, I’ve found that brand takes precedence over all other types.  This could be your brand or a competitor’s brand.  In my opinion, it’s best to separate the branded keywords from the more generic (non-brand) keywords.

The next most important part of this keyword is the Geo-location part because the searcher isn’t looking for just any car insurance; they are looking for car insurance in a specific area.  Anytime you evaluate keywords, just ask yourself “what is the most specific part of that keyword?”  In my opinion, it’s best to group keywords from most-specific to least-specific.

The least specific keyword in this keyphrase would be ‘insurance’.  Since CAR insurance is a specific type of insurance, we have another level of specificity we can use to group keywords by.  We could group all keywords that are non-brand and non-geo-targeted into a “Car Insurance” group.

What I’ve just described is a common scenario that any SEO or SEM goes through when grouping keywords.

Now, imagine if you could AUTOMATE this process with a keyword grouping tool.  That’s exactly what Keyword Grouper software aims to do.  Keyword Grouper is a Keyword Grouper tool that you download and install on your computer.  It is used to group keywords into common themes.

The Best Way to Group Keywords in 3 *Easy* Steps

  1. Build your keyword list – get keywords from Google Analytics search query data, the Google Adwords Keyword Tool, Site Search Suggestion data, off the top of your head, keyword generation tools, etc.  Once you have this list, it’s best to clean the list from non-alphanumeric characters and remove duplicates.
  2. Segment your keyword list – find common themes among your keyword list.  One way to do this would be to analyze the keyword density of your keyword list.  In other words, look for words that appear most frequently while ignoring stop words like “for, as, of, is, to, and, the, etc.”
  3. Group your keywords – a monotonous, laborious task depending on the type of tools you have at your disposal.  You can achieve this in Excel using filters and searching for words that “Contain”.  This would take a lot of time and requires a lot of copy/pasting to different tabs.  Another option in Excel would be to use an Excel Macro to help automate analyzing the keyword density.  I created such an Excel keyword grouping tool that can be downloaded at PPC Campaign Generator.  It doesn’t help you actually perform the grouping but it does help you identify high-frequency keywords within your keyword list.

If you want a free program that allows you to group keywords manually, I would suggest using Adwords Editor.  What you do is take your keyword list and stick them into one single adgroup.  I usually call this group something like *SORT so I know I am sorting it.  Then all do is type in the search box to filter your keyword list to what you are searching for.  The nice thing is, you can select all keywords, hit CTRL + X to cut, go to the adgroups tab, create a new adgroup, go to that adgroup, hit CTRL + V to paste your keywords within that adgroup.  When you’re finished, yo u can simply export to .CSV and save your keyword grouping structure.

In conclusion, that’s the best way in my opinion to group keywords.  If you have any other methods, tips, tricks or ideas, comment below to get the discussion flowing.