Keyword Mapping Template with Intent and Cannibalisation Flags (Google Sheets)

This is the keyword mapping template I use between keyword clustering and writing content briefs. You give every keyword (or cluster) one target URL, and the sheet labels its search intent, scores its priority and flags the mapping mistakes that later show up as keyword cannibalisation.

Most keyword mapping sheets are a list with a URL column. The problems only appear months later, when two of your pages compete for the same query or a category page is asked to rank for a how-to question. I wanted a sheet that catches those problems while you’re still planning.

Who it’s for

SEOs, content managers and agencies planning new content or tidying an existing site. It works for a 50-keyword blog plan and for a few hundred clustered keywords from a semantic keyword research project.

How to use it

1. Open the Settings tab and replace the navigational words with your brand and product names. Check the page types and the page type × intent grid.
2. On Keyword Map, clear the sample rows and paste your clustered keywords with cluster, search volume and keyword difficulty. Add the current ranking URL and position from Search Console or your rank tracker if you have them.
3. Optionally paste an intent label from a classifier. Otherwise the sheet labels intent with whole-word rules.
4. For each keyword, choose a target URL, page status (existing or planned), page type and role (one primary keyword per URL, the rest secondary).
5. Read the Flags column and fix cannibalisation first, then overloaded URLs, then intent mismatches.
6. Use URL Summary, Cluster Summary and the Dashboard to see the plan per page and per cluster, then turn planned pages into briefs.

What you get

• Five automatic flags: the same keyword mapped to two or more URLs, a URL with too many primary keywords, a URL spanning several clusters, an intent that doesn’t fit the page type, and a ranking URL that isn’t your chosen target.
• A transparent 0-100 priority score from volume, difficulty and intent, with every weight editable.
• One row per target URL and per cluster, with counts and flags, plus a dashboard.
• A small synthetic sample so you can see every flag fire before you paste your own data.

Limits

The rule-based intent labels are a first pass, so paste better labels when you have them. The flags check your plan, which means a page can still compete in the results for reasons the sheet can’t see, such as internal anchors or duplicated sections. Formulas work in Google Sheets and Excel, with room for 1,000 keywords.

Pair it with my post on turning semantic keyword research into an actionable workflow, and go deeper in the Semantic ML-enabled Keyword Research course.