How to Map Keywords to Pages: A Simple Keyword Mapping Template
One keyword cluster per page, one page per cluster. Here's the spreadsheet template and the rules for assigning keywords.
Keyword mapping is the process of assigning each keyword cluster to one specific page on your site. It's a spreadsheet, not a strategy — but it's the spreadsheet that prevents every structural SEO problem: cannibalization, orphaned pages, duplicate content, and content gaps.
The rule is simple: one cluster per page, one page per cluster. Every deviation from this rule is a problem to fix.
Why mapping prevents cannibalization
Keyword cannibalization happens when two pages target the same intent. Google has to choose between them — and it often oscillates, giving neither page a stable position.
The only reliable way to prevent cannibalization is to decide, before you write, which page owns which keyword cluster. That's what a keyword map does. It's an explicit ownership document. When you're planning a new article, you check the map first. If the cluster is already assigned, you either write a genuinely different angle (different intent, different audience) or you don't publish a second page.
Without the map, you're relying on memory to know what you've already targeted. Memory fails, especially when you're 60 articles into a blog. The map doesn't.
The template structure
A functional keyword map has five columns. That's all you need.
| Column | What goes here |
|---|---|
| Primary Keyword | The main query the page is built around — the one you'd use in the title and H1 |
| Intent Type | Informational / Commercial / Transactional — this determines the page format |
| Supporting Keywords | 3–10 related terms and variations that belong on the same page |
| Target URL | The page path that owns this cluster (existing or planned) |
| Status | Existing / Planned / In Progress / Live |
Create one row per cluster. If you're starting from scratch, create one row per content topic you've identified. If you're mapping an existing site, start with your current pages and assign clusters to them.
The assignment rules
Rule 1 — Group by intent first, then by topic.
Two keywords that look the same but represent different intents need different pages. "Project management software" (informational) and "buy project management software" (transactional) both relate to project management software, but they serve different searchers at different stages. Assigning them to the same page forces a format conflict.
Group all informational keywords about a topic together. Group all commercial investigation keywords together. Group all transactional keywords together. Then map each group to the appropriate page type.
Rule 2 — Cluster by specificity level.
Don't mix broad and long-tail keywords into the same cluster unless they share the exact same intent. "Content marketing" and "content marketing strategy for B2B SaaS startups" are not the same cluster. The first belongs on a broad, high-level pillar page. The second belongs on a specific article targeting that niche.
A good cluster has: one primary keyword, and supporting keywords that are variations of the same specific query (different word order, synonyms, minor modifiers). Not adjacent topics.
Rule 3 — One page wins, others link.
If multiple pages could reasonably cover a keyword, pick one winner and make the others support it. The supporting pages get internal links to the winner with descriptive anchor text. This concentrates ranking signal on one page rather than splitting it across several.
Rule 4 — Planned clusters are your content backlog.
Every cluster row with status "Planned" is an article that hasn't been written yet. When you want to build out your content calendar, pull every Planned row and sort by potential value (impressions from GSC impressions data, or your rough estimate of audience demand). The top 10 Planned rows are your next 10 articles.
This means your keyword map is also your editorial calendar. They're the same document.
Building the map for an existing site
If you already have 30–100+ pages and no map, build it retroactively. The process:
Step 1 — List every live URL. Export your sitemap or use a crawler (Screaming Frog free tier handles 500 URLs). You want every indexable page.
Step 2 — Pull GSC data. For each URL, what are the top 3 queries driving impressions? This tells you what Google currently thinks each page is about. In many cases it confirms your intent; in some cases it reveals that Google is ranking the page for a different query than you intended.
Step 3 — For each page, assign a primary keyword and intent. This is the reverse-mapping step. You're discovering the cluster that already exists, not inventing one.
Step 4 — Look for overlaps. If two pages are both drawing impressions for the same primary keyword, you've found a cannibalization instance. Flag it in the map — fix decision: merge, redirect, or differentiate.
Step 5 — Identify unmapped clusters. Go back to your keyword research list. Every cluster that doesn't match an existing page is a gap — a Planned row.
The gap-finding outcome
The most valuable output of keyword mapping isn't the assignment of existing pages — it's the list of clusters with no page. These are your content gaps.
Every Planned row represents:
- A topic your audience searches for
- A page you haven't built yet
- A potential ranking opportunity with no cannibalization risk (since no page currently covers it)
When you prioritize your content backlog, prioritize by estimated traffic value and commercial relevance to your product or service. High-volume informational topics build awareness. Commercial investigation topics drive trial and demo signups. Transactional topics convert directly.
How keyword mapping connects to internal linking
Once you have a map, internal linking becomes systematic rather than ad-hoc. For each page, the map tells you:
- Which sibling pages share the same topic cluster (link to them with relevant anchor text)
- Which broader pillar page they belong under (link up to the hub)
- Which narrower supporting pages link down to them (link down to more specific articles)
This is how topical authority builds: not through random internal links, but through a structured hierarchy that matches your keyword map.
Use RankCrab's internal link extractor to audit an existing page's internal link structure and confirm that your most important pages are receiving links from topically related content.
Maintaining the map
The map is only useful if it stays current. Add a row whenever you publish a new page. Update the status column when a Planned page goes Live. Flag new cannibalization instances when you find them in GSC.
A maintained keyword map that you review monthly prevents the structural drift that eventually requires expensive site-wide audits.
The underlying keyword research process — finding the clusters that populate the map — is covered in the keyword research hub, including the free methods that work without any paid tools.