Keyword Cannibalization Checker Template (Optimization Theory, v3.0, November 2026)
==============================================================================

Find queries splitting clicks across two URLs, check whether intent really overlaps and decide whether to consolidate.

What it decides
  Which query and URL pairs are true cannibalization worth consolidating, which are distinct intents to leave alone, and which page should win.

Files
  Keyword Cannibalization Checker Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Keyword Cannibalization Checker Template - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO Labs: Ranked Keywords
  Fills automatically: Keyword, Landing page A
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Export query × page data: From Search Console, export queries with the pages that received clicks. Keep pairs where two URLs share a query.
  2. Enter clicks per URL: One row per query with both URLs and their clicks.
  3. Judge intent overlap: Look at both pages and the SERP. Mark 1 only if they serve the same need.
  4. Pick a winner and act: Set the preferred URL. Consolidate, re-target or add internal links pointing to the winner.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/keyword-cannibalization-template/
Part of the Content SEO Toolkit: https://optimizationtheory.com/download-view/content-seo-toolkit-6-audit-brief-and-testing-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
