SEO Keyword Research Template

Access our keyword research template. Free to use and share via Google sheets.


Free keyword research template from Jellyfish Training

The following guide forms part of our SEO Standard Course. If you want to know more about how keyword research fits into your SEO strategy then check out our next available course dates.

Click here to access the template on Google Sheets

How to use the template

In order to use the template you'll need to first of all make a copy of the template that you will be able to edit   how to make a copy of our template

Step 1: Select your themes

Identify what the core theme/s of your website and marketplace are. Depending on your business, your website may be geared solely towards one theme, or it might be geared towards a variety of themes. These will generally reflect the top level products or service categories that your organisation offers.

Update the 'Seed List' tab on the template sheet to reflect your own themes.

choosing keyword research themes

Step 2: Create your seedlist

Considering the themes identified for your site, what are the most likely queries a user might enter into a search engine when looking for the products, services or information you offer?

Using the template, add the words that you feel a potential client might use to find your website online under each theme. Create a list of the 6-12 most likely keyphrases. You can also use actual search terms identified within Google Search Console or Google Ads for your own site.

seed list examples

Step 3: Build out keyword lists using Google Ads

i. Access the Keyword Planner tool

You will need access to your Google Ads account or create a new account using any Google account.

https://adwords.google.com/home/tools/keyword-planner/

How to find the keyword planner within the Ads interface

ii. Expand your seed list

The Google Keyword Planner will take your seed list/s and expand upon them by providing further related search terms that users might utilise to find a website or webpage like yours.

To begin, select the first option – ‘Search for new keywords using a phrase, website or category’.


using the Google keyword planner

 

Copy the keywords from your first seed list and paste them into the ‘Your product or service field. Make sure that the targeting options match your intended geographical and language targets.


 

Once you hit ‘Get ideas’ Google will return average monthly search data for keywords within your seed list plus all of the terms Google considers to be related.

Use the download function within the Google Keyword Planner to export your full keyword list into an Excel document.

illustration of keyword planner download function

Step 4: Analyse & refine full keyword list

The .csv file downloaded will contain several columns of data that are unnecessary. Delete these until you have only the ‘Keyword’, ‘Avg. Monthly Searches’ and ‘Competition’ columns remaining.

how to enter your seed list into the keyword planner

 

Manually look through all of the keywords in your Full Keyword List. You will find that some may seem irrelevant, off subject or provide too little search volume to warrant inclusion in your final Keyword Selection. Remove these keywords so that you are left with a ‘clean list’.

Step 5: Intent analysis

It is essential in SEO to make sure that the pages you are targeting for any particular keyword match the intent of the query. To help you to understand whether keywords should be targeted via core commercial landing pages, supporting pages or informational pages it is helpful to classify your keywords by commercial intent.

It is essential in SEO to make sure that the pages you are targeting for any particular keyword match the intent of the query. To help you to understand whether keywords should be targeted via core commercial landing pages, supporting pages or informational pages it is helpful to classify your keywords by commercial intent.

Create a new column and mark the key phrases that you think directly match your core products/services with ‘high’ conversion intent. Where you think a user could be interested in your product/service, but perhaps isn't at the stage where they are likely to convert, mark these as a medium. If you think the query relates to your potential audience, but at this stage, they're not likely to be interested in your offering, mark these as low.

Classifying commercial intent during your keyword research

 

Step 6: Final keyword selection

Your ‘clean list’ of keywords will include all of the keywords that you should consider targeting as part of your SEO campaign. Naturally, some of these phases will be of greater value than others – some will be ‘vanity’ keywords while others will be ‘long tail keywords’. It is advisable to split your Final Keyword Selection into the following groups.

  1. Primary Opportunities - Keywords listed in your final selection which provide the most desirable opportunities, in terms of conversion intent and search volume. Your website/webpage will typically most aggressively focus towards these primary opportunities.
  2. Secondary Opportunities - Alternative (often long tail) keywords which provide variation to the primary opportunities. These keywords will typically generate less search volume but still provide good relevance, although possiby lower conversion intent, and are valid for inclusion within your SEO campaign.
  3. Tertiary Opportunities - Further keyword alternatives providing the least lucrative opportunities in terms of search volume, and of med-low conversion intent. In many circumstances, these will be least aggressively targeted within an SEO campaign. These phrases are those you're likely to target with supporting content or blog posts.

Step 7: Keyword ranking and content mapping

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 enable you to spot any gaps in content or key pages that are not performing as you would expect.

  • Are there priority keywords you've identified that you are not ranking for? This should help you to identify opportunities for new content.
  • Are some page/keyword combinations performing poorly compared to the site average? If so these pages will require further analysis and strengthening.
  • Are the pages that are ranking for your chosen keywords the ones you would expect? If so you may be cannibalising search by targeting the same terms with different content.

The tool we use in-house for this is - https://www.accuranker.com/. Although there are plenty of good alternatives - just search for 'rank tracking tools' on Google.

Once you've completed all the steps above you'll need to repeat for each of the themes you identified. Once this is done you're ready to progress with your campaign.

If you want to know more you can also check out our blog post on Advanced Keyword Research.

Want to know more about SEO? Join us for our SEO Standard, SEO Advanced or Local SEO Training courses

PUBLISHED BY

Chris Hutty

SEO Trainer & Evangelist

Hi, I'm Chris and I'm a dedicated SEO Trainer here at Jellyfish Training. Read more

Read these next

The Google Marketing toolkit for digital marketers
A Social Media Plan to save you hours of work
Receive regular updates on news, views and offers from Jellyfish and our Training Blog.
Your data will be handled in accordance with our Privacy Policy

5
Inspiring and knowledgeable trainer

Gained very practical advice that I could immediately put into practice.

5
Great environment for learning

The training was relevant, insightful and presented in a fun but professional manner.

5
They certainly know the digital world

Very useful insights that have paid off time and time again since the course.