As an experienced digital marketer and SEO expert, I know that no search engine optimization strategy can be truly effective without first performing thorough keyword research.
Regardless of how much or how good your content is or how many backlinks your website has, you’re going to struggle to rank if nobody is searching for what you’re writing about.
That’s why I’ve put together a guide on how to carry out keyword research, along with a helpful checklist and template for you to follow.
Quick Summary
Keyword research is a foundational SEO task that involves identifying popular words and phrases people enter into search engines, which can be used to strategize and optimize your content.
The process of keyword research involves understanding your niche, defining goals, listing relevant topics, identifying seed keywords, expanding the list using keyword research tools, and refining the list with competitive research.
Effective keyword research can help you rank higher in search engine results, understand the needs of your audience, and guide your content strategy, ultimately leading to increased website traffic and conversions.
Keyword Research Basics

Before showing you how to go about picking the most important and fruitful keyword ideas for your online business or site, let’s define what Keyword Research is and why it’s important for SEO.
What is Keyword Research?
Keyword Research for SEO is the process of finding and analyzing keywords that are most relevant to a particular niche and which can bring the most organic traffic to your site. This way, you can use those keywords to improve a website’s position in the SERPs.
However, it’s not only about finding terms that will drive the most traffic but also about finding the right search phrases that will help turn organic visits into conversions.
Why Is Keyword Research Important?
Keyword research is important for a number of reasons. Before you create an SEO strategy, you should conduct Keyword Research first. Otherwise, you won’t know which search phrases present an opportunity to improve your website’s position in the SERPs.
There are several reasons why Keyword Research is essential to your website’s growth…
Keyword Research allows you to identify a list of keywords with decent search volume that are the most relevant and valuable to your business or website.

Even if you have an idea of what internet users are searching for, guessing can only get you so far. By including the most popular keywords, you’ll be able to increase your website’s organic traffic.
Thanks to Keyword Research, you’ll also understand which queries your competitors are ranking for and create a strategy to eliminate this keyword gap and overtake them in the SERPs.
How?
You might find keywords relevant to your niche that your competitors aren’t ranking for, in which case reaching the top spots in the search results pages and driving more traffic becomes even easier.
Here are some more ideas to find easy keywords:
Lastly, analyzing your keyword ideas will help you answer some important questions like:
What will it take for my website to rank for this particular keyword?
How much traffic am I likely to get if I rank for this keyword?
What kind of content will I need to write/add to my page to rank for this keyword?
Is this keyword going to bring in more customers to my website?
Keyword Research Checklist

Without understanding what keywords your audience is searching for, your site won’t rank anywhere near its potential.
For those who want to know how to research keywords, we’ve put together a checklist outlining the core steps you should follow when carrying out Keyword Research for SEO.
To complete this Keyword Research process, you will need:
Ahrefs – This is one of the best keyword research tools on the market.
Basic spreadsheet skills
Keyword Research Template
We’ll go through the template below using thesoundjunky.com as an example.
Get An Overview of Your Website’s Keyword Visibility
The first step in this Keyword Research process is all about getting an overview of your website’s current keyword visibility – i.e., identifying which keywords your website is already ranking for.
If you have a brand new website that isn’t ranking for any queries, you can either skip these steps or do them for your most important competitors to give you an idea of what keywords you should target.
Raw Data
Enter your domain into Ahrefs’ Site Explorer tool, click Organic Keywords in the left sidebar.
Ensure that you see the keyword ideas for your target location (in this example, it’s the USA), click Export.

Then, click Full Export (if you’re ranking for more than 1000 keyword ideas) > Start Export.

Once exported, remove all columns from the spreadsheet apart from those that I have kept in the Raw Data tab of the Keyword Research template.
Copy these keywords into the tab and sort the keywords by Volume.

You now have a full list of keyword ideas that your website is currently ranking for based on search volume.
Keyword Map
The next step is to create a keyword map to see which URLs are ranking for which terms.
Create a copy of your Raw Data tab.
This time, order the columns so that you have the following:
URL
Keyword
Position
Volume
Difficulty
Traffic
Clicks
Now, sort the data by URL.
So that your sheet now looks something like this:

You’re now going to create a Pivot Table so that the keyword data looks more presentable.
Highlight all of the data by clicking on the blank cell in the top-left corner.

Click the Filter icon, Data > Pivot Table.

Select New sheet, click Create.

In the Pivot Editor, add in the rows in the same order listed above.
Be sure to deselect Show totals.

Call this Pivot Table, “Keyword Map” and hide your copy of the Raw Data tab by right-clicking on the tab and selecting Hide sheet.

You can stretch the URL column to show more text.
And that’s your Keyword Map complete – this is a more visually appealing and informative representation of the site’s keyword visibility.
For example, you can perform useful calculations to see:
The total search volume of all keywords that are ranking for each web page
The total estimated traffic of all keywords that are ranking for each web page
Low Hanging Keywords
More often than not, you’ll have lots of keywords ranking just outside of the first page (i.e. positions 11 – 30 in the search results).
These are potential quick wins that you can target as a priority.
To find your Low Hanging Keywords, go back to Ahrefs and this time, filter your keywords by Position,
From: 11
To: 20

After clicking Apply, you can export, copy and paste the terms into the Low Hanging Keywords tab.

Alternatively, you can create a copy of your Raw Data tab again and filter the terms by Position using the Filter icon.
You now have a list of search terms that you can optimize to climb into the first page of the search engines.
Long Tail Keywords
The next step is to identify long-tail search terms.
These keyword ideas often have a lower SEO difficulty and present traffic with good conversion potential.
Long-tail keywords might have lower search volume than general keywords, but they usually have low competition and are more likely to interest the target readers and generate conversions.
Essentially, you want to look for terms that contain words like:
Who
What
Where
When
How
Why
Best
Guide
Types
Review(s)
Etc
To do this, head over to the Ahrefs keyword analysis tool and type in the above phrases (separated by commas) into the Include text box.
In the Exclude text box, click Any target, deselect URLs and click Apply.

This will now show you the keywords that contain the above words/phrases.
Export, copy and paste these terms into the Long Tail Keywords tab.
Sort by Keyword from A to Z.

You now have a filtered list of long-tail terms that your website is currently ranking for. These are great for answering questions that your target audience may have about your niche, business, or site.
Potential Keyword Cannibalization
A common problem websites face is when multiple URLs with similar or the same content compete for the same keyword – this is known as keyword cannibalization.
Keyword cannibalization can really hurt a site’s SEO performance, so it’s important to ensure that there isn’t any internal competition between your landing pages.

Here’s a quick way to spot potential keyword cannibalization using Ahrefs.
Create another copy of your Raw Data tab and call it Potential Keyword Cannibalization.
This time, you want your columns to be ordered with:
Keyword
Position
Volume
URL
Cannibalized?
Sort your keyword ideas from A to Z – this is a super important step!
In the Cannibalized column, add the following Excel formula:
=if(A1=A2,"Yes",if(A2=A3,"Yes","No"))
This formula is checking whether there are multiple instances of the same keyword in the spreadsheet.
Copy this formula across all of the rows in your spreadsheet so that it looks like this:

Next, filter out the keywords that aren’t cannibalized.
Click the Filter icon, click the icon under the Cannibalized? column, deselect Yes, then click OK.

This will show you all keywords that aren’t cannibalized.
Highlight them all and delete the rows by right clicking, Delete selected rows to leave you with just the terms that are cannibalized.
Hopefully, your sheet will be empty at this stage (as you don’t want any cannibalization), but if not, it’ll look something like this…

Remove the Cannibalized? Column and sort by Volume to identify the most important keywords that have been cannibalized.
You now have a list of cannibalized keywords. To learn more about analyzing and fixing keyword cannibalization, check out this article.
Finding New Keyword Suggestions & Ideas
Up until this stage of this SEO Keyword Research process, we’ve only focused on the keywords that your website is already ranking for in Google’s SERP.
In this chapter, I’ll show you how to find new keyword ideas to target by using the same keyword research tool (Ahrefs) and other methods.
Identify Seed Keywords by Topic
A great way to build a foundation of new keyword ideas is to brainstorm the key topics that define your website’s niche with seed keywords.

Seed keywords tend to be broad search terms with high search volume.
For example, if you have a website that sells audio equipment, a seed keyword may be “turntable”, “record player” or “bluetooth speakers”.
You essentially want to ask yourself: what topics will people be searching for that are related to my business or website?
Once you’ve got a list of seed keywords, you can start to dig a bit deeper so that you can find the right new keywords you need to target… by looking at your competitors.
Reverse Engineer Your Competitors’ Keywords
The simplest and quickest way to reverse engineer your competitor’s keywords is to use Ahrefs’ Content Gap too.
This keyword research tool tells you which keywords your competitors are ranking for, but your website is not.
How to Find Your Competitors
There are two ways to find your top-ranking competitors. You can either:
Search one of your seed keywords in Google and grab the top 5 results that appear in the SERP.

Note that in some cases, the top results for your seed keywords may not be quite the same as your own i.e. they may serve a different purpose.
In this case, use a more specific keyword that will yield more relevant competitors.
For example, suppose you have an affiliate site that reviews turntables. In that case, you’re likely going to find more suitable competitors in the SERP for “turntable reviews” as opposed to just “turntable”.
This is because websites ranking for the keyword “turntables” (as seen in the screenshot above) are mostly online stores selling turntables instead of affiliate review blogs.
Use Ahrefs Site Explorer > Organic search > Top 10 competitors

When using this method, remember to select the correct country that you are targeting.
In addition, it’s worth remembering that Ahrefs calculates this competitor list by looking at which websites rank in the organic search results for the same keyword ideas as your own site in the demographic with the largest share of organic search traffic.
Therefore, it’s worth analyzing this list to ensure that the listed domains are indeed your direct competitors.
Content Gap Analysis
Once you’ve got your list of competing domains, head over to Ahrefs and click Content gap on the left sidebar.
Paste in the domains of your competing domains and let the tool do the rest by clicking Show keywords.

Here’s what you’ll see…

Export, copy and paste the data into your Content Gap Analysis tab.

You now have a whole list of keyword ideas that you can target on your website.
Remember to filter out any that aren’t relevant to your website – this is why it’s important to analyze your competitor list to only include the most relevant competing domains.
Ahrefs Keyword Research Tool
Although Google Keyword Planner is still a great keyword research tool because the data comes straight from Google, we tend to use Ahrefs’ impressive Keywords Explorer tool.
All you have to do is enter your seed keywords into the search bar, and Ahrefs will return information about this search term such as:
Search volume – How many times are people searching for this keyword? Where are the most searches coming from?
Keyword difficulty – How difficult will it be to rank in the top 10 positions of Google for this keyword?
Cost per click – Know how much are advertisers paying for each ad click in paid search results for this keyword?
On top of this, the report also outlines lots of new keyword suggestions that you may want to target.

Click Matching terms on the left sidebar to view a list of potential keyword opportunities to target.

Ahrefs found 144,328 keywords with a combined search volume of 606K based on this single seed term alone.
You can then export this list for each seed keyword (“topic”) and add them to your Keyword Research spreadsheet in a new tab.

Repeat this step for each of your seed keywords.
To go the extra mile, you can do the same for the other keyword ideas reports from the tool.

Terms match – All keyword ideas that contain the target seed keyword or phrase.
Questions – All keyword ideas that show you search queries that are phrased as a question. For example, they include question words like “who”, “what”, “when”, “how”, “why” etc.
Also rank for – All keyword ideas that the top 10 pages for your seed keyword also rank for.
Also talk about – Other keyword ideas, terms, and phrases that the top-ranking pages for your seed keyword mention frequently.
Analyzing Your Keywords
Up until this point, you’ve been collecting as much information about the keywords you may want to rank for as possible – it is called Keyword Research, after all.
Now, it’s time to analyze keywords ideas so that you can pick the right ones to target on your website.
Search Volume
The search volume is usually defined by the monthly average number of searches for a keyword. Note that this doesn’t refer to the number of people who placed the search.
