Search Results Clustering

Use cases

Detecting keyword cannibalisation via SERP overlap Prioritising content consolidation by score Finding keywords that can share a page Understanding how Google groups related queries

Processes ValueSERP batch CSV exports to cluster keywords by shared organic URLs.

Three algorithm options: connected components (DFS grouping), cliques (all members pairwise connected), or core-based (seed queries with configurable connectivity threshold).

Scores clusters 0-100 using shared URLs + connectivity bonus + size bonus - overlap penalty.

Streamlit App

Platform

Browser-based (no installation required)

Input

ValueSERP batch export CSVs

Output

CSV with clusters and consolidation scores

Launch App View Source

Features

Three clustering strategies: connected, cliques, core (or all)
Consolidation scoring 0-100 with recommendations
Configurable COMMON_URLS threshold (default 4)
Core clustering connectivity threshold (default 0.7)
Overlap detection across clusters
Progress tracking with tqdm

How to use

1 Export SERP data from ValueSERP as batch CSVs
2 Place files in valueserp_exports folder
3 Configure COMMON_URLS and CLUSTERING_STRATEGY
4 Run script to generate serp_cluster_results.csv
5 Review clusters sorted by consolidation score

Want me to run this for you?

I offer this as a managed service. You get the insights without touching the tool.

Bulk Keyword Tagger

Keyword Research

Tag keywords using substring matching against up to 7 classification columns.

eBay Related Searches

Keyword Research

Two-level eBay related search scraping with ECharts tree visualisations.

Keyword Difficulty Checker

Keyword Research

Assess keyword difficulty using allintitle, phrase match, and SERP clustering.

Let's work together

Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.