How to Do Keyword Mapping for SEO (With a Simple Sheet)
Assign every keyword to the right page so each page has a clear job and nothing competes with itself.
Keyword mapping means deciding which page on your website should rank for which keywords. Every important page gets one main keyword (plus close variations), and every important keyword has one home. It prevents two pages competing for the same search and shows exactly which pages you still need to create.
Step 1: Collect your keywords
Gather keywords from your research, Search Console queries, competitor pages and customer questions. Our guides to long-tail keywords and low-competition keywords show where to look.
Step 2: Group keywords by intent
Keywords that would be answered by the same page belong together. "Rooftop solar price", "solar panel cost for home" and "how much is a 3kW solar system" are probably one page. "How to clean solar panels" is a different page. Paste your list into the search intent cluster tool to group them quickly, then review the groups yourself. See how to group keywords by search intent.
Step 3: Build the map
Create a sheet with these columns:
- Page URL (or "new page needed")
- Main keyword
- Secondary keywords in the same group
- Intent โ informational, commercial, transactional or local
- Page type โ guide, category, product, service, comparison
- Status โ ranking, needs work, to create
Step 4: Match groups to existing pages
For each group, find the page that best fits its intent. If two pages both fit, you may have cannibalization โ decide which one should rank and merge or refocus the other. Read what keyword cannibalization is.
Step 5: Plan new pages for the gaps
Groups with no matching page become your content plan. Prioritise by business value and how realistic it is to rank.
Step 6: Optimise each page for its map entry
Use the main keyword in the title, H1, URL and opening, and cover the secondary keywords as natural subtopics. Link between related pages in the map.
Keyword clustering vs keyword mapping
Clustering groups keywords; mapping assigns those groups to pages. You need both โ clustering first, mapping second.
A worked example
An interior design studio had 40 pages and 300 keywords. Mapping showed three blog posts all targeting "modular kitchen designs", while there was no page for "modular kitchen cost". The team merged the three posts into one strong guide, created a pricing page, and gave each service page one clear keyword group. Rankings for both topics improved over the following months.
Signs your site needs a keyword map
- Two or more pages swap positions for the same search.
- Writers keep proposing topics you have already covered.
- Important services have no dedicated page.
- Blog posts rank for searches your service pages should own.
- You cannot quickly say which page targets a given keyword.
If two or more of these sound familiar, an afternoon spent building the map will save many hours of wasted content later.
Related guides
More free tools: browse all our free SEO tools, no sign-up needed.
Frequently asked questions
How many keywords should one page target?
One main keyword and its close variations โ often several related phrases with the same intent.
Should every keyword have its own page?
No. Keywords with the same intent belong on the same page.
How often should I update my keyword map?
Whenever you plan new content, and review it every few months.
Can a homepage target a keyword?
Yes โ usually your brand and main business description.