Most SEO problems on established sites trace back to the same missing artefact: nobody can say which page is supposed to rank for which query. Content gets published because it seemed like a good topic, pages accumulate over years, and eventually the site has four articles half-covering the same subject and nothing covering the thing customers actually search for. A keyword map is the document that prevents all of it — a single list assigning every query you care about to exactly one URL.
What a Keyword Map Is
A keyword map is a spreadsheet with one row per target keyword and a column stating which URL owns it.
That is genuinely the whole concept. Its value is not complexity — it is that the assignment exists, is written down, and can be checked before anyone commissions new content.
It sits between keyword research and content production. Research produces a list of opportunities; the map turns that list into a plan by deciding what gets its own page, what gets grouped, and what already has a home.
Why It Matters More Than It Sounds
It prevents cannibalisation structurally. If every query has one assigned URL, you cannot accidentally publish a second page targeting it — the map tells you it is taken. This is the cheapest possible fix for a problem that is expensive to unpick later, as covered in keyword cannibalization.
It exposes gaps. Queries with no assigned URL are your content plan, already prioritised by volume and difficulty.
It exposes orphans. Pages with no assigned query usually should not exist, or need repositioning.
It makes briefing fast. Half of a content brief is already written once the map exists.
It survives staff turnover. Strategy that lives only in someone’s head leaves when they do.
Building One
Step 1: Export Your Existing Pages
Crawl the site and export every indexable URL. Screaming Frog’s free tier handles up to 500 URLs, which covers most sites. You want the URL, title tag, and H1 as a starting point.
Step 2: Add What Each Page Currently Ranks For
Pull your Search Console query data and match each URL to the query bringing it the most impressions. This tells you what Google thinks each page is about, which is frequently not what you intended.
Discrepancies here are informative. A service page ranking mainly for an informational query usually means the page is written for the wrong intent.
Step 3: Bring In Your Research
Add your target keywords from research — the terms you want to rank for, with volume and difficulty. Our guide to how to do keyword research covers building that list, and keyword difficulty explained covers filtering it to what your site can realistically win.
Step 4: Cluster by Intent
Group keywords that share a search intent. Several phrasings of the same request belong to one page, not several — the SERP overlap test in how many keywords to target per page is the reliable way to decide.
Each cluster gets one primary keyword and a set of secondaries.
Step 5: Assign
Match each cluster to an existing URL, or mark it as a gap. Every cluster gets exactly one URL. Every URL should ideally own exactly one cluster.
Conflicts surface immediately at this step. If two URLs both claim a cluster, you have found cannibalisation and now have to decide which survives.
Step 6: Prioritise the Gaps
Sort unassigned clusters by a combination of volume, difficulty, and business value. That ordering is your content calendar.
The Columns Worth Having
| Column | Why |
|---|---|
| Primary keyword | The term this page owns |
| Volume | Prioritisation |
| Difficulty | Whether it is winnable for your domain |
| Intent | Informational / commercial / transactional |
| Secondary keywords | Subtopics the page must cover |
| Assigned URL | The one page responsible — or “GAP” |
| Page type | Blog / service / product / category |
| Current position | From Search Console |
| Status | Live / needs update / to write |
| Priority | Your call |
Resist adding more. A map with thirty columns stops being maintained within a month.
Intent is the column people skip and should not. A commercial query assigned to a blog post will underperform regardless of how good the post is, because the SERP is showing service pages. Recording intent makes that mismatch visible at planning time instead of six months later.
Using It
Before commissioning anything, check the map. If the query is assigned, the job is to improve the existing page, not write a new one. This single habit prevents most cannibalisation.
When a page underperforms, check its assignment. Frequently the page is fine and the assignment was wrong — the target query has commercial intent and the page is informational, or the difficulty was always out of reach.
When planning internal links, the map tells you which page should receive links for which topic, and with what anchor text.
When auditing, any URL with no assigned cluster is a candidate for merging, updating, or removal.
Keeping It Current
The honest failure mode is that keyword maps get built once, used enthusiastically for a month, and abandoned. Three things that prevent that:
Keep it small. Map the queries that matter commercially, not every long-tail variant your tool returned. Two hundred well-chosen rows beats two thousand.
Update it when you publish, not on a schedule. Adding a row at publish time takes ten seconds. Reconstructing six months of publishing takes an afternoon.
Review quarterly against Search Console. Check whether the pages ranking for your target queries are the pages you assigned. Where they diverge, either the page or the assignment needs changing.
Where It Fits
A keyword map is the connective tissue between research and production. Research tells you what is worth targeting. The map decides what gets its own page. The brief tells a writer how to build it. Without the middle step, research output goes straight to production and the same topics get covered repeatedly by people who did not know the coverage already existed.
For a small site, the map might be forty rows and take an afternoon to build. For a large ecommerce catalogue it is a serious project. In both cases the return is the same: you can answer “which page ranks for this?” without guessing, and that one capability prevents most of the content strategy problems that accumulate on sites over time.
If you want a full keyword map built against your existing content, including the gap analysis and priority order, our SEO services start with exactly that. Reach out to the team at blogthememachine.com, and subscribe to our newsletter below for more strategy guides like this one.
