Today I’d like to share a Python script to automatically generate keyword clusters for all keywords yours or your competitors’ Website ranks for. This provides deep insights and otherwise hidden patterns in your keywords data at a glance.
If you’d just like to get started you can download the Google Colab here.
Why Cluster At All?
Clustering keywords can provide powerful insights to yours and your competitors data. It can be useful for:
- Filtering out junk keywords in bulk from your keyword lists
- Finding the most profitable keyword clusters of your competitors site
- Find ideas for content hubs by clustering similar questions together
Supported Files
- Google Search Console Coverage Reports
- Ahrefs.com V1 / V2 Site Explorer Keyword Exports
- Ahrefs Keyword Explorer
- SEMrush.com organic positions report
- A simple .txt or csv file (Headered or Headerless)
Script Features
- 100% Automated Keyword Clustering
- Calculates the Median CPC Per Cluster
- Calculates the Median Difficulty Per Cluster
- Calculates the Sum of Estimated Traffic Per Cluster
- Calculates the Sum of Estimated Search Volume Per Cluster
Script Output
Here’s a small sample of the script output using next.co.uk – You can see it has neatly clustered loungewear and curtains together and calculated the total volume of the cluster. Awesome!
Instructions
- Head over to the Google Collab Sheet
- Click Runtime > Run All
When prompted, upload your keyword file in .CSV format.
That’s it! The script will run and download a clustered CSV file to your downloads folder!
