Keyword Mapping for SEO: How To Do It + Free Template

keyword-mapping-process-1 Keyword Mapping for SEO: How To Do It + Free Template

Keyword mapping is the process of grouping keywords into topics and assigning them to pages.

Keyword mapping process

The benefit of having a keyword map is that it tells you: 

  • What new pages to create 
  • What they should talk about 
  • How to optimize existing pages 

Let’s look at how to create one. Download the keyword mapping template to follow along. 

If you have a list of keywords for mapping, skip this step. Otherwise, you need to find some before you can fill in the template. To do this, head over to Ahrefs’ Keywords Explorer and enter a few broad terms that define your industry. 

For example, if you sell coffee equipment online, you might enter: 

  • coffee
  • espresso
  • cappuccino
  • french press
  • percolator

From there, head to the Matching Terms report. This shows you all the keywords in our database containing one or more of your seeds. In this case, over four million keywords: 

word-image-169543-2-1 Keyword Mapping for SEO: How To Do It + Free Template

You can then narrow this report further using filters. 

For example, if you want low-competition keywords, try filtering for keywords with: 

  • Low KD scores. The top-ranking pages for these have few or no backlinks, so you shouldn’t need many to rank either. 
  • Low DR sites in the top 5. If these are ranking, you don’t need to be a big brand to rank. 
word-image-169543-3-1 Keyword Mapping for SEO: How To Do It + Free Template

Check out the resources below for more ways to find keyword ideas. 

Further reading

Many of your keyword ideas will fall under the same broader topic. If that’s the case, you can map them to the same URL and target them all on one page. 

For example, take a look at these keywords: 

  • best coffee for cold brew 
  • best coffee beans for cold brew 
  • best cold brew coffee beans 
  • cold brew coffee beans 

They all have the same or similar intent, so creating separate pages for them would be a waste of time. 

But the question is, how do you group a big list of keywords into topics without losing your mind? 

This is where keyword clustering comes in. 

Keyword clustering is the process of grouping keywords with the same or similar intent. You do this by looking at the similarity of search results between keywords. If they’re similar, you can infer they have the same or similar intent and should be mapped to the same page. 

In Ahrefs, you can cluster keywords instantly. Just click the “Clusters by Parent Topic” tab. 

word-image-169543-4-1 Keyword Mapping for SEO: How To Do It + Free Template

For example, the “best coffee for cold brew” cluster has 43 keywords matching my filters—all of which clearly have the same or similar intent. 

word-image-169543-5 Keyword Mapping for SEO: How To Do It + Free Template

Once you’ve found a topic you want to cover, record it in your keyword map template alongside its Keyword Difficulty (KD) and Traffic Potential (TP) score. You can find these by looking at the Parent Topic’s metrics in Keywords Explorer. 

word-image-169543-6-1 Keyword Mapping for SEO: How To Do It + Free Template

If you already have a page about the topic, add its URL to the “URL” column. If not, leave the column blank. 

word-image-169543-7 Keyword Mapping for SEO: How To Do It + Free Template

If you’re unsure which topics make the most sense, choose ones with traffic and business potential. 

how-to-find-best-topics Keyword Mapping for SEO: How To Do It + Free Template
How to find the best topics to cover

A topic has traffic potential if the top-ranking page gets traffic. You can check this by looking at the Traffic Potential (TP) metric for the Parent Topic in Keywords Explorer. This is the estimated traffic to the current top-ranking page. 

For example, the TP for “best coffee maker” is 28K: 

word-image-169543-9 Keyword Mapping for SEO: How To Do It + Free Template

A topic has business potential if the traffic is likely to be lucrative for your business. 

This is subjective. It depends on what searchers are looking for and what your business does. 

For example, people searching for “best coffee maker” are looking for recommendations. You can tell because this is what’s already ranking. 

word-image-169543-10 Keyword Mapping for SEO: How To Do It + Free Template

If you have a coffee affiliate site, this is a high business potential topic because you can earn commissions on recommendations. If you roast and sell your own coffee online, the business potential would be lower as it would be hard to “sell” your product in the content. 

Not sure if you have a page about a topic?

Run this Google search for each topic it makes sense for you to cover: site:yourwebsite.com [parent topic]. If you already have a page about the topic, you should see it in the results. 

For example, this site already has a page about the best coffee for cold brew

word-image-169543-11 Keyword Mapping for SEO: How To Do It + Free Template
This page is clearly about the topic. 

… but doesn’t have one about the best coffee grinders (all the results are more niche): 

word-image-169543-12 Keyword Mapping for SEO: How To Do It + Free Template
None of these pages are about the best overall coffee grinders. 

Secondary keywords are subtopics within a cluster that help you understand search intent and wouldn’t be worth targeting on standalone pages. 

For example, here’s one that stood out to me in the “best coffee grinder” cluster: 

word-image-169543-13 Keyword Mapping for SEO: How To Do It + Free Template

This keyword (“best value coffee grinder”) tells us that searchers aren’t looking for expensive recommendations. They just want a decent grinder for a decent price. 

It also gets very little search volume, so it likely wouldn’t be worth targeting on its own page. 

Let’s add it as a secondary keyword to our keyword map. 

word-image-169543-14 Keyword Mapping for SEO: How To Do It + Free Template

Not sure whether a secondary keyword makes sense?

Creating a keyword map is pointless unless you take action on it. 

Here’s how to choose the right one for each topic in the template: 

  1. If you don’t already have a page about the topic, choose Create.
  2. If you have an existing page about the topic that could rank higher or cover the topic better, choose Optimize.
  3. If you have a page about the topic that ranks and covers the topic well, choose No action.
word-image-169543-19-1 Keyword Mapping for SEO: How To Do It + Free Template

If you’re not sure whether an existing page covers a topic well, plug the primary and secondary keywords into Keywords Explorer and use the Target filter to see where your page currently ranks. If any are outside the top five, it could probably use some optimization for that subtopic. 

For example, this page about the best coffee for cold brew ranks in the top five for all its primary and secondary keywords besides one: 

word-image-169543-20-1 Keyword Mapping for SEO: How To Do It + Free Template

Having checked out the top picks on the page using Ahrefs SEO toolbar, I noticed that it doesn’t list many ground coffees. Most are whole bean. 

word-image-169543-21-1 Keyword Mapping for SEO: How To Do It + Free Template

So, it might be worth adding some other ground options here. 

This is what the current top-ranking page does: 

word-image-169543-22-1 Keyword Mapping for SEO: How To Do It + Free Template

If your page already covers the subtopic well but could still rank higher, try adding more internal links with relevant anchor text.

To find internal linking opportunities, use Ahrefs’ Site Audit.

  1. Select your project 
  2. Go to the Internal link opportunities report 
  3. Paste your URL into the search and select “Target page” from the dropdown 
word-image-169543-23-1 Keyword Mapping for SEO: How To Do It + Free Template

Look through the recommendations and add internal links where it makes sense. Pay particular attention to those with terms from your secondary keywords (e.g., “grounds”) in the “Keyword context” column. 

Further reading

If you’re working with a team or freelancers, you can assign them the task to create or optimize a page from Google Sheets. Just type @ and then their name in the assignee column. 

word-image-169543-24 Keyword Mapping for SEO: How To Do It + Free Template

They should receive an email notification about the task. 

Next steps

If taking action on your keyword map pays off, you should hopefully see organic traffic start to rise for the pages you create and optimize. You can track this using the Portfolios feature in Ahrefs. As the name suggests, it lets you track search performance for a portfolio of URLs. 

You can create a portfolio from the Dashboard like this: 

word-image-169543-25-1 Keyword Mapping for SEO: How To Do It + Free Template

Once added, you’ll be able to see if traffic to the portfolio is rising, flatlining, or decreasing from the dashboard: 

word-image-169543-26 Keyword Mapping for SEO: How To Do It + Free Template

Got questions? Ping me on Twitter X.

RECOMMENDED POSTS

Find Out More

Marketing Tips You Need

Keep In Touch

Quick Subscribe

Client Reviews Tell The Tale.

Nicole NoblesApril 18, 2024
Dan was a delight to work with. I needed a few headshots taken for my LinkedIn profile and Dan provided the easiest and most comfortable experience using state-of-the art equipment in a very professional setting. Also, the turn-around time on results was quick and I felt completely engaged and satisfied during the entire process. I highly recommend his services.Donny RitcharoenDecember 19, 2023
I got headshots taken and they turned out so well! The lighting was amazing.Tessa ChanMay 31, 2023
We used Appture to build a lodging website, and they were awesome! Dan went above and beyond to show us the functions and make all of our changes. Appture is our go to for web design from now on!Abigail HaleOctober 26, 2022
Dan did a fantastic job making me feel comfortable while shooting. He also made me look great! I don't photograph well, so I am very pleased with the results and speed at which I got the final product.Lily GostinSeptember 13, 2022
Appture knows their business and will go the extra mile for their customers. They do high quality work and provide great ongoing support.Chris McCorkindaleMay 25, 2022
Anita CauthornMay 24, 2022
It’s so rare in these times to find one man with so much wow factor and more rare to find men with similar interest and passion in their life journey as myself . Dan Elliott has been introduced to many in what is now considered as the Terror Dome , a place where many dreams are not deferred they are detoured to routes that lead to dead ends , he comes in full of optimism so infectious that he, maybe with out knowing is energizing those who have ventured where others would fear going with just the right jolt to forge on in the way of helping fallen humanity … His various fields of expertise has helped many in my region and I can only imagine the number he has effected beyond those I know … from day one I knew “ this was a man of kindred spirit “ Dan Elliott is a Gem and adds glimmer to things he touches … I’m a Witness ….and eternally grateful….L.Rashaan RichMay 21, 2022
Dan and his group are highly capable and knowledgeable. They work fast and get the job done. I highly recommend Appture.Justin FrankMarch 26, 2022
They are highly specialized in their work and constantly seek innovation.Ismail YenigulMarch 14, 2022
Dan is a marketing wizard. Honest, Experienced and a read deal. I am blessed to have him in my journey online :) Highly recommended.Sabbir HasanMarch 7, 2022
So much to say. Creative, Intelligent, Talented, Limitless, Affordable. It's amazing what these guys can do.Hack mackMay 17, 2019
We'd used some other agencies before, but man, they simply knocked us all over. After being in business for 30 years, I wonder how much more business we'd be doing if we'd hired them earlier.Rebecca HoneaMay 17, 2019