Group Keywords Using Excel Keyword Density Grouper

YouTube Preview Image

Group Keywords Using a Keyword Density Macro

I converted this Excel VBA code I found into an Excel keyword density tool.  This Excel tool can analyze the density of a keyword list and output the most common frequencies for 1 word, 2 word and 3 word phrases.

Let me give you an example of when to use this.

Let's say you checked out a search query report or exported a huge list of keywords from Google Analytics (append &limit=50000 in GA, export as CSV, not CSV for Excel).  You want to find the best way to group these keywords into a common theme.  You take all those keywords, put them into column A of this Excel keyword grouper, remove duplicates, then hit the "Find Density" button.

Magically, the keyword frequency and count appears!  Thanks to this Excel macro, you can now group keywords into common themes much easier.

What you can do is take these keywords, import them into one adgroup in Adwords Editor and begin grouping the keywords by the highest frequencies.  This is WAY easier than staring at your huge keyword list and trying to find common themes manually.  It tells you what keyword frequencies are most common so you can focus on keyword grouping.

Download the Keyword Density Grouper for Excel.

If you see a "Security Warning" from Excel to enable content, just allow it.  Nothing sneaky or tricky going on here.  There are no weird viruses to be worried about, I assure you.  Hit the Enable Content button.

Note: if you're having problems opening the Excel file, open Excel first, then click the download link above.

Build PPC Campaigns Faster With

PPC Campaign Generator

Build PPC campaigns in 5 simple steps!
Simple enough for beginners, powerful enough for advanced users
Training videos and support
FREE stand-alone version of my Keyword Grouper software with purchase (Limited-time!)

Tags: , ,

13 Responses to “Group Keywords Using Excel Keyword Density Grouper”

  1. Chris Todd April 27, 2012 at 10:46 am #

    You have literally just saved by weeks of my time!!

    I've been trying to create a similar system but using CONCATENATE but that doesn't work. I hadn't even got round to planning how to search phrases.

    Thanks for this!

  2. Balazs June 11, 2013 at 8:18 am #

    Fine Script.

    May I ask you a favour? It's possible the script handle non english characters such as öüóőúéáűí. It would be useful.


    • Jarad Collier June 13, 2013 at 8:42 pm #

      I'm certain there is but I wouldn't know how to alter the code to handle such characters. It would be surely useful for non-english words for sure! I'm considering having someone update the code so it has more features but haven't yet. Another thing this script doesn't do is take numbers into account... it doesn't even see numbers! So that would be very useful if it did.

  3. Lauren January 17, 2014 at 4:07 am #

    Is there a reason why when I run this I get a compile error? I'd love to try this tool it looks great, but when I click find density i get a message saying "compile error: Named argument already specified"then it highlight module 1 xlAscending. I'm using Excel 2011 on a Mac

    • Jarad Collier January 17, 2014 at 4:35 am #

      Hi Lauren,

      Honestly, if I had to make a bet, I'd say it's because you're on a Mac but I can't say for sure. It works on my home and work computers fine which are Windows 7. Sorry it didn't work for you. You could try this macro from PPC Hero (which I think they rehashed the idea from me but anyways). I plan to make this tool soon so stay in touch!

      • Lauren January 22, 2014 at 7:50 pm #

        Thanks Jarad! I loved using the tool on a PC and will definitely stay tuned for the mac version! Thanks again for sharing this awesome tool it's been such a huge help

  4. KJ Prince January 22, 2014 at 10:01 pm #

    Super useful thanks for sharing. I'm going to work this into my keyword research process for SEO / PPC and information architecture. Will share when the article is complete. Thanks again.

  5. Alexander Trapeznikov February 16, 2014 at 7:26 pm #

    Hi! I solved a problem with non-English characters and with numbers. If it is actual yet I can show you how i did it for Russian characters (numbers are OK too).


  1. What’s the Best Way to Group Keywords - Keyword Grouper - - December 11, 2011

    [...] 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 [...]

  2. Adwords Editor Training #18 Campaign Build Example Part 2 - PPC Campaign Generator - July 30, 2012

    [...] Keyword Density Grouper [...]

  3. Free Negative Keyword Tool for Excel - PPC Campaign GeneratorPPC Campaign Generator - December 18, 2012

    [...] I added my my Excel keyword density tool to analyze the phrase density of the search query report.  This will output 1-word, 2-word and [...]

  4. Group Keywords into Small Groups or Large Groups? - Keyword Grouper - - April 25, 2013

    [...] Keyword Grouper (or my new keyword grouping algorithm) Adwords Editor, or my Excel keyword density tool … you can group keywords into groups as small as you want.  So the problem shifts your focus [...]

  5. Mining Reddit for Content Marketing Campaigns - March 12, 2014

    […] up your favorite keyword density tool and throw in all of the text in your titles column. We used this Excel spreadsheet to help us with this […]

Leave a Reply