Free resource

Free Keyword Mapping Template (Editable, CSV Download)

Keyword mapping means deciding which single page is responsible for which keyword. Without it, two pages end up competing for the same search (keyword cannibalisation), important keywords have no page at all, and nobody knows whether a page is doing its job.

The table below is a working template. Edit the example rows, add your own, and download the result as a CSV. The examples are illustrative, not real data.

Start free trial View pricingUpdated November 1, 2026

How to use the template

  1. List your keywords from research, Search Console queries and competitor analysis.
  2. Group by intent. Keywords that a single page can satisfy go together; keywords needing a different type of page (guide versus product versus comparison) do not.
  3. Assign one page per group. Check the live results to see what type of page ranks. If every result is a guide, a product page will struggle.
  4. Mark gaps. Keywords with no suitable page become content briefs.
  5. Mark conflicts. If two existing pages target the same keyword, merge, differentiate or redirect.
  6. Record volume, difficulty and position, then review quarterly.
  7. Track the mapped keywords in your rank tracker, grouped by page.

What each column is for

ColumnPurpose
Primary keywordThe main term the page is responsible for
Secondary keywordsClose variants the same page should cover
Search intentInformational, commercial investigation, transactional or navigational, so page type matches
Target page URLThe one page assigned (or the planned URL)
Page typeGuide, category, product, service, comparison, tool
LocationCountry or city for local keywords
Volume and difficultyPrioritisation from keyword research
Current positionFrom your rank tracker
StatusPlanned, drafted, published, needs update
Next actionThe single next step

Using it with Bizsenti AutoSEO

Use keyword analysis to fill volume and difficulty, bulk import the keywords into the rank tracker and group them by page, then scan to fill current position. Competitor analysis helps find keywords competitors rank for that you have not mapped.

A worked example with ten keywords

A fictional dental clinic. Notice how related keywords share one page and different intents get different pages.

KeywordIntentAssigned page
dentist leedsLocal transactionalHome or main service-area page
emergency dentist leedsLocal transactionalEmergency dental care page
teeth whitening costCommercial investigationTeeth whitening page with prices
how long does teeth whitening lastInformationalSection and FAQ on the whitening page
invisalign vs bracesCommercial investigationComparison guide
dental implants leedsLocal transactionalDental implants page
are dental implants painfulInformationalFAQ on the implants page
children's dentist leedsLocal transactionalChildren's dentistry page
nhs dentist leedsNavigational / localA page explaining NHS and private options
wisdom tooth removal recoveryInformationalGuide linked from the surgery page

Several keywords share a page when the intent matches, and a keyword with a different intent gets its own page.

A search intent cheat sheet

IntentTypical signalsPage type
Informationalhow, what, why, guide, tipsGuide or article
Commercial investigationbest, vs, review, compareComparison or list
Transactionalbuy, price, near me, bookProduct, service or booking page
Navigationalbrand namesHome or specific page

Check the live results to see what kind of page ranks. If the results are all guides, a product page will struggle for that keyword.

Fixing keyword cannibalisation

If two of your pages compete for the same keyword, work through these options.

  1. 1

    Confirm it is a real conflict

    Search the keyword and note whether your two pages swap places or both rank poorly.

  2. 2

    Check intent

    If the pages serve different intents, differentiate their titles, headings and focus.

  3. 3

    Choose a winner

    Pick the stronger page by content quality, links and conversions.

  4. 4

    Merge or redirect

    Combine the best content into the winner and 301 redirect the other.

  5. 5

    Update internal links

    Point links to the winner, using descriptive anchors.

  6. 6

    Monitor

    Track the keyword to confirm the consolidated page improves.

Use the resource

Replace the example rows with your own keywords. Volume and difficulty come from your keyword research tool; position comes from your rank tracker.

Primary keywordSecondary keywordsSearch intentTarget page URLPage typeLocationVolume (monthly)DifficultyCurrent positionStatusNext action

Frequently asked questions

How many keywords per page is right?

One primary keyword with close variants that share the same intent. There is no fixed number.

How often should I update the map?

Quarterly, and whenever you add pages or services.

What is keyword cannibalisation?

When two or more pages on your site target the same search, so they compete with each other and neither performs as well as one stronger page could.

Can one page target several keywords?

Yes, if they share the same intent. One primary keyword plus close variants is typical.

Can I download it?

Yes. Edit the table and download as a CSV.

Are the example rows real data?

No, they are illustrative.

Automate the repetitive parts

Bizsenti AutoSEO handles tracking, audits and reporting so you can focus on decisions. 7-day free trial, no card required.

Start free trial

Related pages

Related guides

Sources and references

  1. Google Search Central: SEO Starter Guide
  2. Google Search Central: Creating helpful, reliable, people-first content

Written by the Bizsenti AutoSEO editorial team. Last reviewed November 2026. Third-party facts can change; check the linked sources for the latest.