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-
Because you can use my keyword research template to build an intelligent keyword strategy without spending any money!
It only takes a few minutes to find all of the best keywords in your niche.
First take a look at this sample sheet and familiarize yourself with it.
Note: This sheet is view only, you need to make a copy of the blank template below.
There are 4x tabs at the bottom to navigate through-
Just take a moment to browse around and click on the checkboxes and things to see how it works.
When you are ready make a copy of the Google Sheet below-
Do that by going to File > Make A Copy.
You are going to take out the 100% free 14 day SEMRush trial.
This is where we are going to get all of the world class data to plug into the sheet without spending any cash! (mwahaha)
Setting up the sheet is easy and really just boils down to a 2 step process-
It really doesn’t get any easier than that and the sheet will do all the heavy lifting in the background for us.
Go to the first tab “Start Here” and enter the domains of your 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.
Head over to tab #2 – Data and import each of the files you exported in step #1.
The quickest way to do that is-
This is how you should do it-
Once you have loaded in the data from all of your competitors, you are ready for…
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!
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!
So there you have it! A free intelligent keyword research template that will-
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…
If you have any questions, please ask below and I will help you out!