Keyword Mapping: How to Map Keywords to Pages (With Examples)

Keyword mapping is the process of assigning groups of related keywords to specific pages on your website, so each page targets one search intent. A good keyword map tells you which page should rank for which queries, where pages compete with each other, and which topics you still need to cover.

In this guide, I'll walk through the process I use: inventory, clustering by SERP overlap, and assigning clusters to URLs. I'll use a B2B SaaS website as the example throughout, and you can grab my free keyword mapping template at the end.

What is keyword mapping?

A keyword map is a spreadsheet that connects each URL on your site to the keywords it should rank for. Every page gets:

• One primary keyword: the main query the page is built around, usually the one with the highest search volume in the group.
• Several secondary keywords: variations, synonyms, and long-tail queries with the same intent, which Google already treats as the same topic.

Here's a simple example for a company selling expense management software:

The old approach was "one keyword per page." In practice, one page can rank for hundreds of queries. The real rule is one intent per page.

Keyword mapping vs. keyword research vs. keyword clustering

These three terms often get mixed up, but they're separate steps:

• Keyword research finds the keywords your audience searches for.
• Keyword clustering groups those keywords into sets that can be targeted by the same page.
• Keyword mapping assigns each cluster to a specific URL, whether that page already exists or needs to be created.

Research gives you the list, clustering gives you the groups, and mapping gives you the plan.

Why keyword mapping matters

1. It prevents keyword cannibalisation

Keyword cannibalisation happens when two or more of your pages target the same intent. Google can struggle to pick one, and the ranking URL may swap back and forth. A keyword map makes this visible, because the same primary keyword shouldn't appear against two URLs.

2. It shows your content gaps

Once every existing page is mapped, the clusters left without a URL are your content gaps. Each one is a page you need to create, which turns your map into a content roadmap.

3. It matches each page type to search intent

Mapping forces you to check what Google actually ranks for each cluster. If the top results for "expense management software" are all product pages and comparison lists, a blog post probably won't rank, however good it is.

4. It gives your internal linking a plan

When you know which page owns which topic, you know where to link. Supporting blog posts link to the product or pillar page that owns the commercial cluster, using natural, descriptive anchor text.

How to create a keyword map (step by step)

Step 1: Inventory your existing pages

Before mapping new keywords, map what you already have. Export your indexable URLs from your XML sitemap or a crawler, then add the queries each URL already gets impressions for in Google Search Console.

This shows you which pages already rank, what Google thinks each page is about, and where multiple URLs already overlap.

For a detailed walkthrough, see my guide on building a content inventory. To filter large query sets in Search Console, regex filters save a lot of time. For example, the regex expense (report|policy) returns every query containing either phrase.

Step 2: Build and clean your keyword list

Next, gather keywords from your keyword research tool, Search Console, competitor rankings, and conversations with sales and customer success. B2B SaaS teams often skip that last source, but it's where you find the language buyers actually use.

Then clean the list:

• Remove irrelevant keywords. For example, "expense management jobs" doesn't fit a software company.
• Remove duplicates, typos and near-identical variants.
• Add metrics. Include search volume, keyword difficulty, and intent for each keyword.

For the expense management company, the cleaned list might include:

• expense management software
• expense tracking software
• ramp alternatives
• expense report template
• how to create an expense report
• travel expense policy
• expense management for startups
• expense management quickbooks integration

Step 3: Cluster keywords by SERP overlap

This is the most important step, and the one most guides skip.

Don't decide whether keywords belong together based on how similar they look. Instead, check whether Google ranks the same pages for them. If two keywords share several of the same top-10 URLs, Google treats them as the same intent, and one page can target both. If the results are mostly different, they need separate pages.

A common starting point is to group keywords that share at least three or four URLs in the top 10. Then adjust based on what you see in your niche.

Using the example list:

• "expense management software" and "expense tracking software" have heavily overlapping SERPs. They go on one page.
• "expense report template" and "how to create an expense report" look related, but the first SERP is full of downloadable templates, while the second is mostly step-by-step guides. If overlap is low, they need separate pages, or the template page needs to be built so it satisfies both.
• "ramp alternatives" has its own SERP of comparison listicles. It becomes its own page.

You can compare SERPs for a handful of keywords manually, but it doesn't scale. I built a free SERP Overlap Tool for exactly this, and for larger lists you can pull results in bulk with my Bulk SERP Checker Python script.

Step 4: Check the intent and page type for each cluster

For each cluster, look at the SERP and note two things.

Search intent:

• Informational: the searcher wants to learn something ("how to create an expense report").
• Commercial: the searcher is comparing options ("ramp alternatives").
• Transactional: the searcher is ready to act ("expense management software pricing").
• Navigational: the searcher is looking for a specific site or page ("ramp login").

Page type: Is Google ranking product pages, blog posts, templates, comparison pages, integration pages, or tools? Your page needs to match the dominant format.

For B2B SaaS, this usually splits into:

For a closer look at reading search results, see my guide to SERP analysis.

Step 5: Assign each cluster to a URL

Now match each cluster to a page:

1. If an existing page already ranks for or fits the cluster, map the cluster to that URL.
2. If no page fits, map it to a new planned URL and mark it as "To create."
3. Choose the primary keyword for each cluster. It's usually the highest-volume term that best describes the page. The rest become secondary keywords.

A quick check: every primary keyword should appear only once in your map. In Google Sheets, a formula like =COUNTIF(C:C, C2)>1 flags any primary keyword assigned to more than one URL. More Sheets tricks are in my Google Sheets formulas for SEO guide.

Step 6: Resolve conflicts

Your inventory will probably show pages competing for the same cluster. The usual fixes are:

• Merge: Combine the pages into the stronger URL and 301 redirect the weaker one. This is best when both pages cover the same intent.
• Re-target: Refocus one page on a different cluster with its own intent. For example, move a general blog post from "expense management software" to "expense management for startups."
• Canonicalise: Point a near-duplicate page to the main version when both need to exist, such as filtered or parameter URLs.
• De-optimise: Remove the competing keyword from the weaker page's title, H1, and internal anchors.

Step 7: Optimise pages and plan internal links

With the map in place, optimise each page for its cluster:

• Put the primary keyword in the title tag, H1, and URL where it reads naturally.
• Cover the secondary keywords and related subtopics in the body. Match the depth and format of the pages that already rank.
• Add internal links from supporting pages to the page that owns the cluster.

In the example, the "expense report template" and "travel expense policy" posts would both link to /expense-management-software/, and the product page would link back to them as resources.

Step 8: Monitor and update the map

A keyword map is never finished. Every few months, check in Search Console that the URL ranking for each primary keyword is the one you mapped. If Google ranks a different page, or multiple pages get impressions for the same query, you have a mapping problem to fix.

Also update the map when you publish new content, launch new features or integrations, or notice new queries showing up in Search Console.

Keyword mapping example: B2B SaaS

Here's what a fuller map looks like for the expense management company:

The "Merge" status on the last row flags a cannibalisation fix: an older post on "business travel policy" is merging into the travel expense policy page.

Free keyword mapping template

To make this easier, I've created a free keyword mapping template in Google Sheets.

It includes these columns:

• URL: the existing or planned page.
• Page type: product, comparison, integration, use case, blog post, and so on.
• Primary keyword: the one main target query.
• Secondary keywords: supporting queries with the same intent.
• Search intent: informational, commercial, transactional, or navigational.
• Search volume: for the primary keyword, or the whole cluster.
• Current ranking URL: the page Google currently ranks, taken from Search Console or your rank tracker.
• Current position: where that URL ranks now.
• Status: Optimise, To create, Merge, or Redirect.
• Notes: conflicts, internal link targets, and next steps.

Make a copy, then follow the steps above to fill it in.

Common keyword mapping mistakes

• Grouping by how keywords look instead of by the SERP. "Expense report template" and "how to create an expense report" look similar, but Google may treat them as different intents.
• Forcing the wrong page type. A blog post rarely ranks for a keyword where Google shows only product pages.
• Mapping new keywords without auditing existing pages. This is how cannibalisation starts.
• Setting it once and never revisiting it. Rankings, SERPs, and your site all change, so the map needs to change too.

Final thoughts

Keyword mapping turns a keyword list into a plan. Inventory what you have, cluster by SERP overlap, assign each cluster to one page, and keep checking that Google agrees. The result is a site where every page has a clear job, with no pages competing against each other and a visible list of what to create next.