Keyword Mapping Template

Keyword Research Toolkit, template 2 of 6

Keyword Mapping Template

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

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

  • Excel workbook (.xlsx), opens in Google Sheets
  • PDF field guide, 9 to 11 pages
  • Blank and worked CSV templates
  • DataForSEO import script

Free, no email required. Version 3.0, updated November 2026.

Keyword Mapping Template.xlsx
K13fx=IF(H13="","",IF(H13<>"Ready","n.a.",IF(COUNTIFS($A$13:$A$1012,A13,$B$13:$B$1012,"<>"&B13)>0,"Conflicting URLs","Review intent")))

Start HereDashboardWorkspaceDelivery QAField Guide

The formula above is the real one from cell K13. Scroll it sideways to read the whole rule.

Connected to the DataForSEO API

This template is designed around one DataForSEO endpoint. Pull the data, convert it with one command, and the workbook does the rest.

Setup steps

DataForSEO Labs: Ranked KeywordsEvery keyword a domain ranks for, with its ranking URL, position and volumedataforseo_labs/google/ranked_keywords/live

Save the JSON responseThe full API response, kept as your source of truth.response.json

Run the import scriptOffline. No API calls, no credentials.dataforseo_import.py import --template 02

Paste at A13Dashboard, checks and action list update instantly.Keyword Mapping Template.xlsx

Column map for this template:Filled by the APIAudit trail (automatic)You add

KeywordTarget URLTopic clusterSearch intentMonthly searchesOwnerSource reference
5 of 7 input columns come straight from DataForSEO

What the keyword mapping template decides

A keyword map is the contract between your keyword research and your site architecture. It says, for every query you care about, which one page is responsible for ranking. When that contract is missing, two writers target the same query, a category page and a blog post compete, and Google picks whichever it likes on a given day.

This keyword mapping template keeps the map in one table: keyword, target URL, cluster, intent, volume and owner. Formulas count how many times each keyword appears, how many keywords each URL carries, and flag any keyword assigned to more than one URL as Conflicting URLs. The Dashboard lists every conflict so you can resolve them before they show up in Search Console.

Who it's for

  • SEOs building or cleaning up a site's information architecture
  • Content teams that need a single source of truth for who owns which topic
  • Migrations, where every keyword needs a destination on the new site
  • Agencies handing a clear page-by-page plan to a client

Where it fits in your workflow

The keyword mapping template answers one question. These three templates answer the questions around it:

What's inside the download

One ZIP with the workbook, a 7-column input template (blank and filled), the PDF field guide and an offline script that converts saved DataForSEO responses into the input CSV. The workbook has five tabs.

Workspace. The working table. 7 input columns, 4 calculated columns, room for 1,000 rows. Dropdowns, Yes/No fields and range checks catch bad inputs as you paste.
Start Here. What it decides, a four-step setup and the colour key.
Dashboard. KPI cards, charts, a ranked Top 10 and an automatic action list.
Delivery QA. Pass, fail or exclude each validation step with evidence, owner and date.
Field Guide. Every field explained, plus each formula in plain English.

How the keyword mapping template calculation works

Query assignments counts how many rows share the same keyword. Queries on URL counts how many keywords point at the same URL, which helps you spot overloaded pages. Assignment review returns Conflicting URLs whenever the same keyword is mapped to a different URL anywhere in the table, otherwise Review intent as a reminder to check the match.

The key formula, exactly as it appears in the workbook

=IF(H13="","",IF(H13<>"Ready","n.a.",IF(COUNTIFS($A$13:$A$1012,A13,$B$13:$B$1012,"<>"&B13)>0,"Conflicting URLs","Review intent")))
Result column Plain-English formula What it tells you
Query assignments COUNTIFS(all Keyword,Keyword) Number of rows assigning this exact keyword.
Queries on URL COUNTIFS(all Target URL,Target URL) Number of keyword rows assigned to this URL. Several supporting queries can be intentional.
Assignment review IF(COUNTIFS(all Keyword,Keyword,all Target URL," ≠ "&Target URL)>0,"Conflicting URLs","Review intent") Flags the same exact keyword assigned to different URLs.

The results you will see

Conflicting URLsReview intent

Green meets the checks, red needs fixing first, amber needs a human decision and blue marks an opportunity. Rows with missing or out-of-range inputs are held back in the Input check column until they're fixed, so a half-filled row never sneaks into a total.

How to use the keyword mapping template

  1. List your target keywordsPaste keywords with search volume, one per row. Include the ones you already rank for, not just new targets.
  2. Assign one target URL eachChoose 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 ownerPick an intent from the dropdown (informational, commercial, transactional, navigational, local) and name the person responsible for that page.
  4. Resolve every conflictOpen 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.

The worked example in the Workspace tab. Clear the lime input cells, paste your CSV at A13 (values only) and every result recalculates.

Fill the keyword mapping template with DataForSEO

Every template in this library is built to run on DataForSEO data. This one uses DataForSEO Labs: Ranked Keywords: every keyword a domain ranks for, with its ranking URL, position and volume.

Most of the data columns fill automatically. Add the business inputs listed below, then paste.

  1. Request the dataSend this request with your DataForSEO API login (HTTP Basic auth).
    POST https://api.dataforseo.com/v3/dataforseo_labs/google/ranked_keywords/live [ { "target": "yourdomain.com", "location_code": 2840, "language_code": "en", "limit": 1000 } ]
  2. Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
  3. Convert it with the included scriptIt runs offline, makes no API calls and never sees your credentials.
    python3 Automation/dataforseo_import.py import --template 02 --input response.json --output my-inputs.csv
  4. Add what the API can't knowTopic cluster, Owner
  5. Paste at A13Clear the demo rows, paste the CSV values at Workspace cell A13 and the dashboard updates.
Fills automatically from DataForSEO You add
Keyword, Target URL, Search intent, Monthly searches Topic cluster, Owner

Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable. Before a big pull, estimate the cost with the DataForSEO pricing calculator. The same steps, plus an example request file, are in the download's Automation folder.

Worked example: Northbeam Outdoor

Every template ships filled with data from Northbeam Outdoor, a fictional outdoor-gear retailer that appears across all 40 workbooks, so you can see what useful output looks like before you add your own. This workbook has 20 example rows.

20Records
0Rows with input issues
4Conflicting assignments
17Unique target URLs

Two keywords in the example were mapped twice by different people, which is exactly how cannibalization starts in real teams. The conflicts surface on the Dashboard immediately.

Top 10 by monthly searches

# Keyword Monthly searches
1 trail running shoes 40,500
2 trail running shoes 40,500
3 rain jacket womens 27,100
4 waterproof hiking boots 22,200
5 mens down jacket 18,100

Input fields

Keep the columns in this order when you prepare a CSV. A missing observation stays blank; use 0 only for a measured zero or a verified No. Fields marked DataForSEO can be filled automatically by the included script.

CSV field Column Meaning and rule Source
keyword Keyword Exact query in the selected country and language. DataForSEO: keyword
target_url Target URL The intended canonical landing page. DataForSEO: url
cluster Topic cluster Human-approved group based on intent and SERP review. Your records
intent Search intent Informational, commercial, navigational or transactional. DataForSEO: intent
search_volume Monthly searches Provider monthly search-volume estimate. Use one market, language and source date. DataForSEO: search_volume
owner Owner Person accountable for the next action. Your records
source_ref Source reference Task ID, export filename and observation scope. Retain the untouched source response separately. Optional. DataForSEO: source_ref

Reading the result honestly

Multiple queries on one page are normal when they share intent. Multiple destinations for the same query deserve a review.

Limits. This catches mapping conflicts, not ranking cannibalization. Use resource 22 for measured page competition.

Keyword mapping template mistakes to avoid

Mapping by keyword instead of by intentTwo keywords with the same SERP belong on the same page even if the words differ. Cluster first, then map the cluster.
Overloading one URLIf Queries on URL climbs into the dozens for a single page, it's usually covering several intents. Consider splitting it.
Leaving planned pages blankGive planned pages a URL now, even if it's a placeholder. Blank targets hide gaps in your plan.

Tips from practice

  • Use the SERP overlap template to decide which keywords share a page before you map.
  • Export the map as CSV and join it to Search Console data to see which pages rank for queries mapped elsewhere.
  • Revisit the map after every content audit, since merged and retired URLs change ownership.

Frequently asked questions

What is keyword mapping in SEO?

Keyword mapping is assigning each target keyword, or keyword cluster, to the one page on your site that should rank for it. It prevents internal competition and shows where new pages are needed.

How many keywords should map to one page?

As many as share the same search intent and SERP. A page commonly owns one primary keyword and a handful to a few dozen close variants.

How does the template detect conflicts?

It counts rows where the same keyword is assigned to a different URL. Any keyword with more than one target URL is flagged as Conflicting URLs.

Can I use this for a site migration?

Yes. Map keywords to the new URLs, then use the redirect mapping template to make sure every old URL that ranked for those keywords points at the right destination.

Part of the Keyword Research Toolkit

Get all 6 Keyword Research templates in one ZIP, or the complete set of 40 SEO and GEO templates with the 401-page field handbook.

Download the Keyword Research Toolkit

See the complete SEO & GEO toolkit

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.

More on digital marketing in our blog

See all posts