We already shared a Python Keyword Grouping Script some weeks ago and get some great feedback for it. If you struggle with Python Programming but still want to use this approach I have good news for you! In this post I will describe how to use our free online grouping tool to get the same results.
Step 1: Getting some keyword data
I used the google keyword planner to get a list of around 5000 keywords. I downloaded the data and imported it to a google sheet like this:
When you have thousands of keywords you will benefit a lot if you are able to group similar keywords together. It is even more useful when you aggregate, in my example “Avg. monthly searches” for each keyword cluster. By doing this 100 uninteresting (low search volume) standalone queries become a very interesting topic when you combine their search volume.
To get this please copy column A and B to your clipboard.
Step 2: Paste the data in the online grouping tool
After pasting the keyword data you have to provide some settings like you do when importing CSV files into Excel:
- Delimiter: Choose the delimiter that is used in your input data. If you copy and paste form Excel or google sheets use “Tab” as separator.
- Use column header names: I pasted the column header data to the tool – this is why I check this option. If you do it like that the generated grouping file will contain the same column names like your input data
This is enough for running the tool.
If you want to tweak the clustering result there are two more parameters you can use. There is not one correct way for these settings – it always depends on your personal use case and the provided amount of keywords data
- Minimum cluster size: If you want a very detailed result leave the default value like it is. This means 2 keywords can build a valid keyword cluster. If this is two granular for you just go up in the number.
- Similarity Threshold: This parameter tells the cluster algorithm how similar keywords have to be to get grouped into the same bucket. “More general grouping” will give you less buckets but with a lot of keywords per group. “More granular grouping” will give you lots of smaller buckets. When you are a SEO Professional you can use those different settings for getting big content hub topics (general grouping) and also the specific subpages for those topic hubs (granular grouping).
Step 3: Download your Grouping Result
Open the result CSV file in Excel or Google Sheets and you will get this view:
Don’t be confused by a cluster with name “-1”. This keywords where not assigned to any valid cluster. This can happen based on the similarity thresholds and the minimum cluster size defined when running the clustering tool.