How To (Intelligently) Steal Your Keyword Strategy
When I am looking for a new niche, I always do the same thing.
First I brain storm a list of actual niches by observing the world around me.
Whether that’s in your house, the street, while watching a movie, in a mall or listening to music – niches are everywhere.
For example right now I can easily think of-
- Power tools
- Electric scooters
- Drones
- Video blogging
Once I have a target list of niches, I do some Google searches to see what kind of sites exist for a topic.
The best way to find affiliate type sites is to do searches with 2x types of keyword modifier-
- Best Power Tools
- Best Electric Scooters
- Best Drones
- Best video blogging
- Cheap Power Tools
- Cheap Electric Scooters
- Cheap Drones
- Cheap video blogging
…We can begin to steal our way to an intelligent keyword strategy!
How To (Intelligently) Steal Your Competitors Best Keywords
The easiest way to do this is with my personal Google sheet.
This is something I had developed to help me build intelligent keyword strategies in minutes rather than days-
This sheet will automatically spit out a personalized keyword strategy based on your competitors current 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
In fact:
With this free spreadsheet and the one I am going to give you tomorrow…
You’ll be able to create intelligent keyword & backlink strategies in minutes!
How To Setup The Keyword Theft Sheet
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: The SAMPLE sheet is view only, you need to make a copy of the blank template below to use it.
There are 4x tabs at the bottom to navigate through-
- Start Here – Enter your competitor domains here
- Data – Enter the data you export here
- Keyword Analysis – Automatically finds the best keywords for you to select
- 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 make a copy of the Google Sheet below-
Steal Your Keywords Sheet – MAKE A COPY OF ME
Do that by going to File > Make A Copy.
Next:
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)
UPDATE: The Ahrefs & SEO Powersuite versions of the sheets have problems at the moment. We are working on a fix, in the mean time enjoy the free SEMRush data.
How To Setup The Sheet For Your Niche
Setting up the sheet is easy and really just boils down to a 2 step process-
- Import the data
- Make our keyword selections
It really doesn’t get any easier than that and the sheet will do all the heavy lifting in the background for us.
FOLLOW THIS VIDEO TO SETUP THE SHEET
Step #1 – Start Here Tab
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.
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-
- Open one of the files from step #1
- Delete the first row of data
- Highlight all of the remaining data and copy it
- Then paste it into Tab #2 of the google sheet
- 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
Because I am going to show you how to steal all of your competitors best backlinks for those keywords VERY soon!
And once you have done that…
If you have any questions, please ask below and I will help you out!
And if you want to take things to the next level I highly suggest you check out my step by step 90 Day SEO strategy to grow your search traffic.
What Are Your Thoughts?
352 Responses
Hello thanks a lot,but my sites have not organic traffic our site techenical seo is good plz help me
https://searchlogistics.com/seo/on-page/seo-audit/
Hi Mathew I need some helpOn google SERPS for a particular keyword (Brochure Design) I am alway second after my competitor. I need help on overtaking them for that keyword .
Figure out what they are doing differently
very information I really like it
Thanks Matlida 🙂
Awesome Matthew, this is a great trick.Thanks a lot.
Happy to help.
I haven’t a ‘make a copy’ button in the spreadsheet. What I should do in such a case?
You need to make a copy of the BLANK spreadsheet. You can do it in that one.
Best SEO on that side of the pond 😀 Blimey!
Haha cheers!
You disabled copying the file
Nope – you need to make a copy of the blank spreadsheet. Just follow the setup instructions.
where i can download sheet
Just follow the setup instructions.
What’s the price?
It’s free, just make a copy of the blank sheet and get started.
Worked great for me, will be running a few sheets over the weekend to look for opportunities!
Great news Adam!
It is a useful sheet. I am looking forward to learning more about SEO technic
Well you’re in the right place 🙂
How do I download the file?
Follow the instructions 🙂
Thanks a lot for giving the idea about the backlink checker and also keyword finder of my competitors.
No worries Manish – hope you found the tool helpful.
Haha, cheers mate.
F**king legend
You just need to make a copy of the blank version from the post
i’m unable to download the semrush one properly for some reason. my email is murlin.josh@gmail.com if you have the time to send me it. I’d love to take a better look! and yes, I’m a subscriber 😉
Hi how to build up membership site?
https://searchlogistics.com/work/ideas/membership-sites/
Hi MathewGood work on the sheet, I’d be interested in getting more of your worksheets.RegardsKeith
Thanks Keith, if you subscribe to my mail list you’ll be within the first group of people that get access to any resources like this I release 🙂
Such a great automation done by you Matthew…Really appreciate your efforts to make this happen Keep doing great things & teach us more & more SEO tactics!
Thanks very much – I certainly will do 🙂
Export link did not work dear. Thanks
You just need to make a copy of the BLANK sheet
This is a lifesaver keyword strategy tool. Thanks so much
No worries Daniel – happy I could help
SEMRUSH trial setup keeps declining my credit card when there are no problems at all with it. Frustrating. Do I have to contact SEMRUSH directly or is the PROMO code out of date?
I chased up with SEMrush for you and they advised:’The user was granted 14 days free access, and I have checked the billing issue was because of his bank, not on our side, so it is better for him to contact his bank’.Hope this helps
Thanks for this
Glad I could help
I can not make a copy of the file
You have to make a copy of the blank sheet, not the sample sheet
Where is the spreadsheet?
In the ‘How To Setup The Keyword Theft Sheet’ section. Just follow the instructions
Really awesome info
Cheers Ali
Very cool. Can’t wait for the backlink tool!
You won’t have to wait long!
It is really a time saver, Thank You.waiting for competitors backlinks.
Cheers Ajay, it should hit your inbox pretty soon.
Thnaks for giving operating method. Now I will try this spreadsheet..
No problem Ethan – happy hunting.
Hey Matthew! where do I find the spreadsheet?
Just follow the instructions
Thanks for this wonderful information I must give you a thumbs up
Thanks a lot!
Thanks for the resource
No problem Chris
Great Great Information..really thank you
No problem at all Mustafa 🙂
Hi Matthew, where do I find the spreadsheet?Thanks
Go to the ‘How To Setup The Keyword Theft Sheet’ section.
Thanks for sharing
No worries Vivek
great job, thank you very much.
No problem 🙂
Nice overvieww, will be using this methid. thanks
Great news, thanks Shawn.
Dear Matthew,Thanks a million for sharing your intelligent spreadsheet, It’s extremely useful and worth spending $7 for ahrefs trial to export data from their base.Have a Happy&Successful New Year
Great news Pawel – you’re very welcome 🙂
Hi Matthew, I always saw your ad on facebook and I opened it today. Definitely it is very helpful. I am unable to find the off-page strategy. I am new to SEO and my niche is highly competitive. I don’t know how to do off-page and backlink strategy. Do you have more information like this article so I could do.Thank you !!
Hi Nick – yes I cover everything SEO – https://searchlogistics.com/seo/
yout tips are amazing Matthew
Thanks very much
Nice post thanks. I’m sure the tool will come in handy
Hope so too
sir this is really amazing …. thank you for this.
No worries Gourab 🙂
I cant find any spreadsheet here, please give me a link.Thank you
You need to choose which tool you want to use and in the right tab you’ll see the blank version of the spreadsheet you can make a copy of
Matt, thank you again and againI’m a follower since December 2014 (RankCracker) You’re still tha best.
Hey Oscar – thanks so much, glad to have you with me 🙂
impressed with the simplicity of your approach
Cheers Thomas
Your Competitor backlinks analysis spread not download ?
Just make a copy of the blank spreadsheet the same as this one. https://searchlogistics.com/steal-link-building-strategy/
thank you but is there a way of getting this info for a startup for free
There are free keyword research tools yes – https://searchlogistics.com/seo/keywords/free-keyword-research-tools/But you’ll find the data to be pretty limiting.
NIce information . useful for our website. thank you
Hope you are finding the spreadsheet helpful.
Hey, I signed for your mailing list and still didn’t get the keyword spreadsheet. What did I do wrong?
You get the spreadsheet by making a copy of the blank version in this post.