The Intelligent Keyword Research Template

The easiest way to do keyword research is by using my free keyword research template.

This is something I had developed to help me build intelligent keyword strategies in minutes rather than days.

This free keyword research template will spit out a personalized keyword strategy based on your competitors search rankings in less than 5 minutes.

It does a bunch of cool things-

  • Automatically find’s the best keywords with high search volumes & low competition
  • Tell you if its possible to win a featured snippet
  • Calculates the intent of the keyword to help you focus on $$$ keywords

Click Here To Download It Now

How Does It Work?

In essence the sheet finds all of your competitors best keywords and then tells you which one’s you should focus on ranking for first.

You can take a look at a sample here.

But if you want to use it, make a copy or download it – you need to click here.

It is really simple to use, but you must connect it to one of these tools/free trials-

  • SEMRush– Exclusive 14 day 100% free trial for my readers
  • RankTracker – Free version available
  • Ahrefs – $7 but by far the best data

Personally I leverage Ahrefs huge warehouse of SEO data in my business.

But not everyone has the same preferences (or budget) as me.

So I had my developer make it work with the free trials of SEMRush and SEO Powersuite (RankTracker) as well.

This means you can use my keyword research template to build an intelligent keyword strategy without spending a penny

But the data sources do have some key feature in the differences-

Ahrefs VersionSEMRush VersionRankTracker Version
Automatically Finds & Filters Easy To Rank KeywordsYesYesYes
Create Intelligent Keyword StrategyYesYesYes
Calculates Keyword IntentYesYesYes
Current Featured SnippetYesNoNo
Featured Snippet Potential?YesYesYes
Keyword Database SizeLargestNormalSmallest
AccuracyHighestNormalLowest
Data Collection TimeInstantInstant10+ Hours
My Weapon Of ChoiceYesNoNo
Trial Available?Yes – $7Yes – FreeYes – Free

So choose your weapon wisely!

Personally I use Ahrefs because it has the largest database of data which produces the most accurate results.

And given this data will guide the future success of my business – it’s important to have accurate data.

The only down side is their trial costs $7…

BUT:

With this free keyword research template you’ll be able to build an intelligent keyword strategy backed by world class data.

How To Setup The Free Keyword Research Template

It only takes a few minutes to setup my free keyword research template.

Click the tabs below to view the instructions and download the sheet for your tool of choice-
  • Ahrefs Instructions
  • SEMRush Instructions
  • SEO Powersuite (RankTracker) Instructions

Ahrefs Keyword Theft Setup Instructions

Getting this setup with Ahrefs is really easy.

First take a look at this sample sheet and familiarize yourself with it.

Note: This sheet is view only – click here to access the full sheet.

There are 4x tabs at the bottom to navigate through-

  1. Start Here – Enter your competitor domains here
  2. Data – Enter the data you export here
  3. Keyword Analysis – Automatically finds the best keywords for you to select
  4. Final Selections – Shows your final keyword selections

Just take a moment to browse around and click on the checkboxes and things to see how it works.

When you are ready download your copy of the sheet.

How To Setup The Sheet For Ahrefs

Setting up the sheet is easy.

First we import all the data we need, then we make our keyword selections!

Step #1 – Start Here

Go to the first tab and enter the domains ofyour competitors (without http or www) in column A-

Then click on the links to automatically open the right report that you need.

Click on the export button and select the first 2,000 rows to export-

Repeat this for each of the competitors until you have exported all of the data.

Step #2 – Loading The Data

Head over to tab #2 – Data and import each of the files you exported in step #1.

The quickest way to do that is-

  1. Open one of the files from step #1
  2. Delete the first row of data
  3. Highlight all of the remaining data and copy it
  4. Then paste it into Tab #2 of the google sheet
  5. Repeat the process adding each report you exported in step #1 to tab #2

This is how you should do it-

Once you have loaded in the data from all of your competitors, you are ready for…

Step #3 – Keyword Analysis

Now head over to the 3rd tab #3 – Keyword Analysis.

This sheet has already found the easiest to rank for keywords with the highest search volumes for you-

It also includes some extra helpful columns like if a featured snippet currently exists and if there is opportunity for one in the future.

It will also tell you if it’s a tyre kicker keyword (ignore these) or a commercial based keyword.

Just work through the sheet and tick the little tick box when you find keywords you like!

Step #4 – Review Your Final Selections

Last but not least jump over to the 4th tab #4 – Final Selections and review your final keyword choices.

Once you have done that, your personalized keyword strategy is complete!

SEMRush Keyword Theft Setup Instructions

Getting this setup with SEMRush is pretty straight forward.

First take a look at this sample sheet and familiarize yourself with it.

Note: This sheet is view only – click here to access the full sheet.

There are 4x tabs at the bottom to navigate through-

  1. Start Here – Enter your competitor domains here
  2. Data – Enter the data you export here
  3. Keyword Analysis – Automatically finds the best keywords for you to select
  4. Final Selections – Shows you final keyword selections

Just take a moment to browse around and click on the checkboxes and things to see how it works.

When you are ready download your copy of the sheet.

How To Setup The Sheet For SEMRush

Setting up the sheet is easy.

First we import all the data we need, then we make our keyword selections!

Step #1 – Start Here

Go to the first tab and enter the domains ofyour competitors (without http or www) in column A-

Then click on the links to automatically open the right report that you need.

Make sure you are on the Organic Research > Positions report-

And then on the right side, scroll down a bit and click on the export button and select the first 3,000 rows to export-

Repeat this for each of the competitors until you have exported all of the data.

Step #2 – Loading The Data

Head over to tab #2 – Data and import each of the files you exported in step #1.

The quickest way to do that is-

  1. Open one of the files from step #1
  2. Delete the first row of data
  3. Highlight all of the remaining data and copy it
  4. Then paste it into Tab #2 of the google sheet
  5. Repeat the process adding each report you exported in step #1 to tab #2

This is how you should do it-

Once you have loaded in the data from all of your competitors, you are ready for…

Step #3 – Keyword Analysis

Now head over to the 3rd tab #3 – Keyword Analysis.

This sheet has already found the easiest to rank for keywords with the highest search volumes for you-

It also includes some extra helpful columns like if there is opportunity for a featured snippet.

It will also tell you if it’s a tyre kicker keyword (ignore these) or a commercial based keyword.

Just work through the sheet and tick the little tick box when you find keywords you like!

Step #4 – Review Your Final Selections

Last but not least jump over to the 4th tab #4 – Final Selections and review your final keyword choices.

Once you have done that, your personalized keyword strategy is complete!

SEO Powersuite/Rank Tracker Keyword Theft Setup Instructions

Getting this setup with RankTracker is super easy although it takes a while to pull all the data back.

First take a look at this sample sheet and familiarize yourself with it.

Note: This sheet is view only – click here to access the full sheet.

There are 4x tabs at the bottom to navigate through-

  1. Start Here – Enter your competitor domains here
  2. Data – Enter the data you export here
  3. Keyword Analysis – Automatically finds the best keywords for you to select
  4. Final Selections – Shows you final keyword selections

Just take a moment to browse around and click on the checkboxes and things to see how it works.

When you are ready download your copy of the sheet.

How To Setup The Sheet For RankTracker

Setting up the sheet is easy.

First we import all the data we need, then we make our keyword selections!

Step #1 – Start Here

Go to the first tab and enter the domains ofyour competitors (without http or www) in column A-

In RankTracker go to the Keyword Research > Ranking Keywords tool and enter your competitors domain-

Important: Make sure that RankTracker pulls back all of the search volumes and difficulty scores.

And then on the right side, scroll down a bit and click on the export button and select the first 3,000 rows to export-

Repeat this for each of the competitors until you have exported all of the data.

Step #2 – Loading The Data

Head over to tab #2 – Data and import each of the files you exported in step #1.

The quickest way to do that is-

  1. Open one of the files from step #1
  2. Delete the first row of data
  3. Highlight all of the remaining data and copy it
  4. Then paste it into Tab #2 of the google sheet
  5. Repeat the process adding each report you exported in step #1 to tab #2

This is how you should do it-

Once you have loaded in the data from all of your competitors, you are ready for…

Step #3 – Keyword Analysis

Now head over to the 3rd tab #3 – Keyword Analysis.

This sheet has already found the easiest to rank for keywords with the highest search volumes for you-

It also includes some extra helpful columns like if there is opportunity for a featured snippet.

It will also tell you if it’s a tyre kicker keyword (ignore these) or a commercial based keyword.

Just work through the sheet and tick the little tick box when you find keywords you like!

Step #4 – Review Your Final Selections

Last but not least jump over to the 4th tab #4 – Final Selections and review your final keyword choices.

Once you have done that, your personalized keyword strategy is complete!

Wrapping It Up

So there you have it! A free intelligent keyword research template that will-

  • Automatically find the best keywords with high search volumes & low competition
  • Tell you if its possible to win a featured snippet
  • Calculates the intent of the keyword to help you focus on $$$ keywords

Click Here To Download It Now

And tomorrow I’ll also send you another intelligent sheet that is focused on finding all of the best backlinks for those keywords as well!

Because once you have done that…

…you will have an intelligent SEO plan of attack based on cold hard data!

Click Here To Download The Intelligent Sheets Now

If you have any questions, please ask below and I will help you out!

What are your thoughts?

* Name, Email, Comment are Required
0 Shares
Share
Tweet
Pin
Share