TRY OUR PACKAGES
Expand your seed list The Google Keyword Planner will take your seed list(s) and expand on them by providing related search terms users might use to find a website or webpage like yours. Here’s what you need to do:
Generally, the more searches a keyword receives, the better because we know people are searching this particular query. But the higher the search volume, the greater the competition, so we don’t want to select high search volumes only.
With your spreadsheet (.csv file) downloaded, you’ll see several columns of data. You’ll want to focus on three columns only: ‘Keyword’, ‘Avg. Monthly Searches’ and ‘Competition’. Unclutter the sheet by deleting all other columns.
Step 3: Build out keyword lists using Google Ads Keyword Planner.
Let’s run through each step in more detail so you can get the best use out of the template.
Open your template and add the keywords you feel your target audience might use to find your website, starting at your theme and then branching out. It’s also important to consider all three types of queries:
Here’s an example. A skincare brand geared towards the premium marketplace with eco-friendly goals could identify luxury face cream, sustainable body lotion, and organic skincare as their themes.
Finally, refine your list of keywords by deleting those we’ve identified above as either irrelevant or with a low search volume. You now have the final keyword selection, otherwise known as the ‘clean list’.
The tool we use to identify our keyword ranking is Accuranker , but there are many more SEO tools you can use, including:
This guide forms part of our SEO Standard course. If you’re looking to elevate your SEO strategy and master the basics of search engine optimisation, take a look at the range of SEO training courses delivered by our in-house experts.
It’s essential in SEO to make sure the pages you are targeting for any particular keyword match the query’s intent. To help you establish whether keywords should be targeted on landing pages, supporting pages, or informational pages, it’s useful to organize your keywords by commercial intent.
Step 4: Analyse and refine full keyword list.
Once you have finalised your keyword selections, the next step is to see if you’re already ranking for the keywords identified. This process will let you spot gaps in content or key pages not performing as you would expect. You’ll want to ask questions such as:
Access the Keyword Planner tool You will need access to your Google Ads account or create a new account using any Google account. Once you’ve logged in, go to Tools at the top of the page and select Keyword Planner from the dropdown menu.
Depending on your business, your website may be geared towards one theme only or a variety of themes. Once you’ve determined your theme(s), you can list these in the Seed List tab on your template.
In this guide, we will walk you through each step of the research process. We’ll cover how to do keyword research through to analysis of keyword ranking and content mapping. To get started, open the keyword research template . This version is view only, so you’ll need to make a copy. You can do this by going to File then Make a copy.
Now, explore the keywords appearing in the list. You’ll find some seem irrelevant, off-topic or provide too little search volume to warrant inclusion in your final keyword selection.
Step 2: Create your seed list.
Here at Jellyfish Training, we believe in the power of effective keyword research. Whether you’re an SEO beginner or specialist, our free keyword research template in Google Sheets will help you focus your research, whatever your level.
Long-tail keywords: Longer, more specific keyword phrases that can be easier to rank for but have lower search volume.
On the other hand, keywords identified as ‘low search volume’ receive very little search traffic on Google. These can be identified as keywords generating under 250 searches a month. This low search volume indicates these keywords may not be relevant to our target audience and won’t result in traffic to your website.
So, to refine your keyword selection further, it’s a good idea to split your ‘clean list’ into the following groups:
Once you’ve made a copy of the template, you’re ready to jump into keyword research. To make sure you get the most value from this guide, we’ve divided it into seven steps:
This next step focuses on finding effective keywords using your seed list.
Open as Google Sheet.
This template brings together all those different approaches into one place. So instead of bouncing around between a thousand tabs, losing track of where you are in the process…
Download as Microsoft Excel.
Download the Keyword Research Template.
The Digital Marketing Templates Library.
Keyword Research Template.
When you’re done, you’ll have a BIG list of keywords. Plus all the metrics to help you pick which to target.
In SEO there’s nothing more important than choosing the right keyword. This template makes it easy to create a large list of keywords to choose from. And to add the metrics you’ll need to evaluate them.
Streamline and organize your keyword research with this free template (available in Excel and Google Sheets). Whether you’re starting a new SEO project, want to improve your site’s search traffic, or are looking for target keywords for a new piece of content, this template will help you do keyword research quickly and effectively.
You can just go through this template. Simple. Step-by-step.
How to use this template.
Here’s what’s included in this keyword research template:
Like pretty much everything in SEO, keyword research is more complicated than ever. Back in the day, everyone used the old Google Keyword Tool. Today? There are a million different tool options. Plus, you’ve more techniques for finding keywords coming out every week.
But at the end of that process, you’ll still have to pick one. Here’s how to do that: