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

Assign every keyword to exactly one URL and catch conflicting assignments before they become cannibalization.

What it decides
  Which single URL should own each keyword, and where your map assigns the same query to two different pages.

Files
  Keyword Mapping Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Keyword Mapping 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, Target URL, Search intent, Monthly searches
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. List your target keywords: Paste keywords with search volume, one per row. Include the ones you already rank for, not just new targets.
  2. Assign one target URL each: Choose the existing or planned URL that best matches the intent. Use the cluster column to group keywords that belong on the same page.
  3. Label intent and owner: Pick an intent from the dropdown (informational, commercial, transactional, navigational, local) and name the person responsible for that page.
  4. Resolve every conflict: Open the Dashboard action list. Each row is a keyword mapped to more than one URL. Pick one owner page and plan internal links or consolidation for the other.

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-mapping-template/
Part of the Keyword Research Toolkit: https://optimizationtheory.com/download-view/keyword-research-toolkit-6-seo-planning-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
