Keyword research is essential for a strong content strategy, but it can sometimes be overwhelming when presented with hundreds and thousands of keywords. With seemingly every keyword having a difficulty ranking of 70+.
In this article I'll show you the basics of how to use keyword research tools to find rankable keywords regardless of your sites domain rating for basically any niche you can think of. With examples for a few different tools and niches to follow. So you can see how it works in practice.
The easiest way to find keywords is to use a keyword research tool like Ahrefs or SEMrush. But this can also be done with our sites statistics from Google Search Console and Google Ads Keyword Planner which are available for free. These tools will give you a list of keywords related to your seed keyword and their search volume, difficulty, and other metrics.
This data can then be used in conjunction with a keyword grouping software like Optiwing to group keywords into topical clusters so we can find groups of keywords with the lowest difficulty rating and highest volume to tailor our content to, and get localized and device specific insights.
We can then answer questions like:
Once you understand what your target audience is looking for, you can tailor make content that is search intent-oriented while still providing value to everyone who discovers it. This is essential, especially considering Google's Helpful Content Update. This update is designed to rank content higher that genuinely helps users and provides value for their specific needs. So for understanding user intent and to get your content to rank higher, you will need to do keyword research. Which is a much simpler task than you might think.
We can then use good internal linking strategies to help us rank for these easier keywords.
Let's get started, first we need to find keywords related to our site's niche that we would want to rank for.
Keyword Research Tools Needed: Ahrefs/SEMrush & Optiwing
The scenario: We’re running an e-commerce website in the snow sports industry. We want to write content about the best snowboards, the top snowboard boots/bindings, and snowboard reviews, to start ranking for keywords related to the industry.
First we will need to select some starter keywords. These will be broad search terms that covers the industry or niche as a whole.
I simply chose snowboard to try to catch as many related keywords and accessories as possible. Note: It is often wise to include both the singular and plural form of your keyword. For this example, you could also include "snowboards" in your keyword research, but for simplicity we will be sticking to just "Snowboard".
Next, we'll be using SEMrush's keyword magic tool. Here’s how to do it:
Once our keyword report is ready, click on "Broad Match" or ("Terms Match" on Ahrefs) to see all results with our seed keyword in them.
SEMrush will find all keywords/search terms that have our seed words in them. In this case, we have 298,975 keywords with the seed keyword "Snowboard" in them.
We need to curate our list of matching terms for the best result and to git rid of some unnecessary keywords we don't care to target. Since we're running an E-commerce platform we're going to target more commercial or transactional keywords.
The easiest way to do this is create list of includes. Includes are any words that should appear in the search terms along with our seed keywords.
Anything like "best", "top", "review", and "reviews" and one of my favorites "beginner". These are all great ways to narrow our results down. Remember to choose "Any Word" when you create this filter or it will require every word in the list to be in the search term, if you are making localized content you can include the name of your location or nearby locations as well.
This narrowed our results down to 25,812 keywords, this is a lot better but we can narrow this down even more to refine our results a bit more.
We want to narrow our list down even further and we can do this by adding some exclude keywords. An exclude word is any word that we don’t want to appear in our search terms. In this case, since we are running an E-Commerce platform and focusing on commercial intent keywords we don’t want our list to include terms like "best places to snowboard" or "snowboard shop near me".
So, we create an exclude list. My list has the following words in it: "place", "places", "near me", and "shop". Add your list to the Exclude filter and click Apply.
Our list has now shrunk to 24,818 keywords. We could group these now, but this would use quite a lot of resources and include a lot of very low volume keywords so we're going to narrow it down until we have a list of around 500-10,000 keywords depending on the size of our niche.
Let’s see if we can narrow our list down a bit more.
Click on the Volume filter, and add a minimum. In this case I decided anything under 20 volume wasn't worth targeting. This will narrow our keyword list down quite a bit.
This narrowed our list down to 4,711 keywords, a much more reasonable number, we could narrow this down more by adding more include/excludes or tweaking our volume further but I'm going to stick with this list.
Now we’re going to use a keyword grouping tool to help us understand how we can best use this keyword list. Hit the Export button. Remember to export all the rows as CSV, or UTF-16 (Microsoft Excel CSV). You’ll end up with a file that looks something like this.
But we’re not done there, this file isn’t particularly helpful to us. We could spend hours picking through relevant low difficulty keywords and looking them up on Google to see what else is ranking for them. But we’re going to use a keyword clustering tool to do this automatically and save us some time.
This will also show us ways to rank for multiple keywords with a single article.
Once you’ve got your exported list, head over to the Optiwing Dashboard.
Optiwing will take our file and group our keywords into topical clusters. This is a great way to see how we can best use our keyword list.
It should look something like this:
Finally, choose your geography and device. For this example, I’m leaving it as the United States and Desktop.
Click on Launch Job.
What does Optiwing actually do?
Optiwing takes your keyword list and runs every single keyword through Google. It will group any keywords that share at least 3 ranking results the first page of organic Google results.
Basically if a set of keywords have 3 or more ranking pages that are the same, we know that we only need one article to target that set of keywords because the same pages rank for different variations of those keywords. Once our job is complete, we can take a look at the results.
We will see a list of keywords, and the number of variations in each grouping. They will be sorted by total volume of every keyword in the group. Each of these groups can be it's own article on our website.
Each button has the primary keyword as the title. We can also see the aggregate volume, the Keyword Difficulty (How hard it is to rank for a particular keyword on a scale of 0-100). We can click on the button to see the keywords in that group.
We can now look through this list and find the highest volume and lowest difficulty keywords to target in our article.
You will want to look for groups of keywords that have a difficulty score under 30, or ideally under 10. They should also be relevant to our niche, and have a decent amount of volume.
When writing an article, we try to keep the primary keyword in the title, meta description, H1 header, and first paragraph. We’ll use keyword variations as H2's and organically sprinkle them throughout our content in a way that doesn't detract from the content but is consistent with normal speech or conversation. This will help us rank for not only the primary keyword, but the variations as well.
Keyword Research Tools Needed: Google Search Console, Google Ads Keyword Planner & Optiwing
The scenario: We’re trying to get more traffic to our blog by making more content related to the search queries that are already performing well for our website.
First, we're going to head over to Google Search Console and look under the performance tab to see which search queries our website is generating the most clicks from. Here are the results from our example website:
Then we'll go to Google Ads Keyword Planner and enter the top 10 queries from our website into the keyword planner keyword discovery tool.
Select all keywords and click "Download keyword ideas" to download the entire list of related keywords.
Download the results as a .csv file
In order to group our keywords we need to make sure our file is properly formatted, remove the extra lines added at the top of the .csv file by Google Keyword Planner, make sure the first row is labels and the following rows are keywords/stats.
Our file will look something like this when done, we can manually remove rows to get rid of keywords we don't want to include in our grouping, or sort by volume and remove low volume keywords if we want.
Now we can open up Optiwing and start a new job with our edited csv file.
Now we have groupings of keywords we can target with a single article each, we can again use these topical clusters to target high volume, low difficulty keywords relevant to our niche and double down on what's already working and generating clicks for us.
For this example, Google uses a different keyword difficulty ranking and we want to target groups of keywords as close to 0 difficulty as possible, and ideally under 10.
How do we best use our list of grouped keywords? Here are some tips:
Browse through your keyword list and highlight or save options using the following criteria:
Ideally, you’d want to create articles for every keyword group. However, this can be expensive and time-consuming. So, I believe in prioritizing keywords. If a keyword is high in volume, low in difficulty, relevant to your niche, and aligns with your business goals, it’s should be your initial target.
I personally like Backlinko's Guide to On-Page SEO.
Using internal linking to boost the content we want to rank is a great way to improve ranking for these easier keyword. You can also use external links if you have the option. Create internal links on secondary keywords (also known as keyword variations). This is a powerful way of boosting your overall SEO performance.
As for external links, if you're guest posting or link building, use the keyword variations as your external link anchors.
Thats that simple step-by-step guide to finding rankable keywords.
To recap, here are the steps again:
Following these steps consistently will help you become a topical authority in your niche. The more articles you can create to cover a topic entirely the higher you will rank, and will likely earn you backlinks over time if you are creating valuable content. Remember, SEO is a marathon not a sprint, and providing useful and valuable content is foremost important.