Keyword Cannibalisation Finder
Use cases
Groups GSC data by query-page combinations using pandas transform("count") to detect competing pages per query.
Calculates mean position and CTR per entry.
Filters by position range, minimum impressions, minimum clicks, and minimum competing pages thresholds.
Parses percentage CTR strings automatically.
Sorts by competing page count and impressions.
Platform
Browser-based (no installation required)
Input
GSC export CSV
CTR column optional (calculated if missing)
Flexible column naming with auto-detection
Output
Grouped view: cannibalisation summary by query with totals. Detailed view: all query-page combinations with metrics. Summary cards in dashboard.
Features
- Position range filter (1-100, default 1-20)
- Minimum impressions threshold (0-100,000)
- Minimum clicks threshold (0-10,000)
- Minimum competing pages filter (2-10, default 2)
- Automatic CTR percentage parsing
- Grouped view and detailed view exports
How to use
- 1 Export data from Google Search Console
- 2 Upload CSV – columns auto-detected
- 3 Set position range (default 1-20)
- 4 Configure impression, click, and competing page minimums
- 5 Toggle full URLs or grouped view
- 6 Download grouped or detailed CSV
Want me to run this for you?
I offer this as a managed service. You get the insights without touching the tool.
Related Tools
GSC Coverage Visualiser
Search ConsoleVisualise indexing issues from Search Console coverage reports with interactive Plotly treemaps and sunbursts.
GSC Data Exporter
Search ConsoleBulk download Search Console data beyond the 1,000 row limit with automatic batch processing.
GSC Question Finder
Search ConsoleExtract question-based keywords from Search Console using regex pattern matching.
Let's work together
Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.
Let's Talk