How To (Intelligently) Steal Your Keyword Strategy

Subscribe to my YouTube Channel Now –>

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 Modifier

  • Best Power Tools
  • Best Electric Scooters
  • Best Drones
  • Best video blogging

Cheap Modifier

  • Cheap Power Tools
  • Cheap Electric Scooters
  • Cheap Drones
  • Cheap video blogging

With a list of 5x sites that shows up regularly for those searches…

…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

Now personally I like to leverage Ahrefs huge warehouse of data in my business.

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

So I took my Ahrefs powered version of the sheet and also made SEMRush and SEO Powersuite (RankTracker) compatible versions as well.

This means you can build an intelligent keyword strategy without spending a penny

But the sheets do have some key feature differences-

Ahrefs Version SEMRush Version RankTracker Version
Automatically Finds & Filters Easy To Rank Keywords Yes Yes Yes
Create Intelligent Keyword Strategy Yes Yes Yes
Calculates Keyword Intent Yes Yes Yes
Current Featured Snippet Yes No No
Featured Snippet Potential? Yes Yes Yes
Keyword Database Size Largest Normal Smallest
Accuracy Highest Normal Lowest
Data Collection Time Instant Instant 10+ Hours
My Weapon Of Choice Yes No No
Trial Available? Yes – $7 Yes – Free Yes – 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 spreadsheet and the one I am going to give you tomorrow you’ll be able to build an intelligent keyword and backlink strategy backed by world class data.

I also built other sheets so you can get the job done with any of these tools/trials-

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

The decision is yours! I’ve already done all of the hard work for you.

How To Setup The Keyword Theft Sheet

It only takes a few minutes to setup each sheet.

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, you need to make a copy of the blank template below.

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 make a copy of the Google Sheet below-

Steal Your Keywords – Ahrefs Edition (blank)

Do that by going to File > Make A Copy.

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, you need to make a copy of the blank template below.

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 make a copy of the Google Sheet below-

Steal Your Keywords – SEMRush Edition (blank)

Do that by going to File > Make A Copy.

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, you need to make a copy of the blank template below.

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 make a copy of the Google Sheet below-

Steal Your Keywords – SEOPowersuite/RankTracker Edition (blank)

Do that by going to File > Make A Copy.

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

Make sure you get that setup right now and that you tick the boxes to make your final keyword selections.

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…

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

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

Subscribe to my YouTube Channel Now –>

233 Responses

  1. Chris
    2.24.2020

    Thanks for the resource

    • Matthew Woodward
      February 24th, 2020 at 11:57 pm

      No problem Chris

  2. mustafa
    2.10.2020

    Great Great Information..really thank you

    • Matthew Woodward
      February 11th, 2020 at 7:49 am

      No problem at all Mustafa :)

  3. Edward Byrne
    1.26.2020

    Hi Matthew, where do I find the spreadsheet?
    Thanks

    • Matthew Woodward
      January 27th, 2020 at 5:39 am

      Go to the ‘How To Setup The Keyword Theft Sheet’ section.

  4. Vivek Singh
    1.25.2020

    Thanks for sharing

    • Matthew Woodward
      January 27th, 2020 at 5:43 am

      No worries Vivek

  5. Serge-Jérôme
    1.10.2020

    great job, thank you very much.

    • Matthew Woodward
      January 17th, 2020 at 11:27 pm

      No problem :)

  6. Shawn Morgan
    1.2.2020

    Nice overvieww, will be using this methid. thanks

    • Matthew Woodward
      January 17th, 2020 at 10:56 pm

      Great news, thanks Shawn.

  7. Pawel Wolniak
    12.30.2019

    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

    • Matthew Woodward
      January 17th, 2020 at 11:00 pm

      Great news Pawel – you’re very welcome :)

  8. Nick Jhon
    12.30.2019

    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 !!

  9. master
    12.19.2019

    yout tips are amazing Matthew

    • Matthew Woodward
      December 24th, 2019 at 4:03 am

      Thanks very much

  10. Vitor de Brito
    12.18.2019

    Nice post thanks. I’m sure the tool will come in handy

    • Matthew Woodward
      December 24th, 2019 at 4:10 am

      Hope so too

  11. gourab sahoo
    12.17.2019

    sir this is really amazing …. thank you for this.

    • Matthew Woodward
      December 18th, 2019 at 2:59 am

      No worries Gourab :)

  12. manvee
    12.16.2019

    I cant find any spreadsheet here, please give me a link.
    Thank you

    • Matthew Woodward
      December 18th, 2019 at 3:04 am

      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

  13. Oscar Valdemara
    11.23.2019

    Matt, thank you again and again

    I’m a follower since December 2014 (RankCracker)

    You’re still tha best.

    • Matthew Woodward
      November 26th, 2019 at 8:31 am

      Hey Oscar – thanks so much, glad to have you with me :)

  14. wthomas wallace
    11.22.2019

    impressed with the simplicity of your approach

    • Matthew Woodward
      November 22nd, 2019 at 11:43 pm

      Cheers Thomas

  15. Khan
    11.20.2019

    Your Competitor backlinks analysis spread not download ?

  16. Carlos Olaaka
    11.20.2019

    thank you but is there a way of getting this info for a startup for free

  17. DomS IT Solutions Pvt. Ltd.
    11.12.2019

    NIce information . useful for our website. thank you

    • Matthew Woodward
      November 14th, 2019 at 3:15 am

      Hope you are finding the spreadsheet helpful.

  18. Harold
    11.12.2019

    Hey, I signed for your mailing list and still didn’t get the keyword spreadsheet. What did I do wrong?

    • Matthew Woodward
      November 12th, 2019 at 1:19 am

      You get the spreadsheet by making a copy of the blank version in this post.

  19. Richard Leighton
    11.9.2019

    Hello Matthew, I heard your podcast with Spencer Haws today and feel lucky to have stumbled upon your great advice…

    • Matthew Woodward
      November 12th, 2019 at 1:25 am

      Thanks Richard, I hope it proves useful for you!

  20. Lawrence
    11.5.2019

    Hi Matthew, I am a KWfinder fan and am not looking to change search tools, so I suspect it is not designed for me. I do appreciate the time you have taken to create these sheets. All the best for the future. Warm regards, Lawrence

    • Matthew Woodward
      November 7th, 2019 at 2:59 am

      Sorry Lawrence.

  21. Collin
    10.21.2019

    Thanks for the info Matthew! Very clear, concise, and helpful. I’ll be following your work from now on.

    • Matthew Woodward
      October 22nd, 2019 at 7:38 am

      Thanks Collin – hope to see you here again soon :)

  22. jay
    9.16.2019

    Maaaaate… the sheet is locked! Sort it otherwise you’re just wasting peoples time.

    • Matthew Woodward
      September 17th, 2019 at 12:50 am

      Hi Jay – Yes the sample sheet is locked. You need to make a copy of the blank sheet.

      • Beb
        September 29th, 2019 at 7:21 am

        You can’t make a copy

        • Matthew Woodward
          September 30th, 2019 at 6:14 am

          You certainly can – make sure you are making a copy of the blank sheet which is where it says – ‘Steal Your Keywords Sheet – MAKE A COPY OF ME’

      • Google Drive Login
        October 6th, 2019 at 5:19 pm

        hi jayy – you sheet is locked you need to make more blank sheets

        • Matthew Woodward
          October 10th, 2019 at 11:55 am

          You need to make a copy of the blank sheet – the link to it uses this text ‘Steal Your Keywords Sheet – MAKE A COPY OF ME’

    • Iido
      October 10th, 2019 at 3:44 pm

      hey bro, just add the sheet to drive, and make a copy, the problem is solved

  23. Benjie
    9.2.2019

    Hi Matthew,
    It’s been awhile since the last time I commented on your posts. You’ve come a long way! Seeing your success inspires me to start my own blog or vlog on my own niche.

    Thank you again for your helpful posts! This is a goldmine, sames through with your other posts!

    Congratulations to your Success! Keep inspiring people!

    PS. Hope you don’t mind if I include my website. But currently it is down for maintenance.

    Thanks Again!

    • Matthew Woodward
      September 3rd, 2019 at 2:34 am

      Hey Benjie, glad I was able to help

  24. Marcus Ollison
    8.26.2019

    I’ve downloaded the worksheet. Looking forward to finding great competitive keywords.

    • Matthew Woodward
      August 27th, 2019 at 2:33 am

      Enjoy Marcus!

  25. Nick Martins
    8.20.2019

    Can this tutorials be used to offer seo service on fiverr? and if possible it is, what can be the gig title on fiverr and what would be delivered. Please I need enlightenment or is there any software that can be used to render seo service. I don’t mind buying if its under my capacity

    Thank you

  26. parbat
    8.15.2019

    I am sick of searching for your spreadsheet. I have spent like 2 hrs searching for it but couldn’t find it. I always get into the bonus section of your page but cant find any spreadsheet or anything there.

  27. Khuram Shahzad
    8.8.2019

    Thanks Matthew for you great sharing and see changing tips and tricks

    • Matthew Woodward
      August 12th, 2019 at 10:45 pm

      No problem Khuram!

  28. Sathiya
    7.24.2019

    Thank you Matthew! This is something i was looking for.

    • Matthew Woodward
      July 25th, 2019 at 2:47 am

      Great news

  29. Muzammil Ijaz
    7.20.2019

    Whoever reading this, you’ll be successful someday! just keep on pushing.

    • Matthew Woodward
      July 25th, 2019 at 2:54 am

      Thanks for the encouraging words :)

  30. Tom
    7.19.2019

    I followed all the instructions, waited for the grey progress bar to finish but when I click Tab 3 there are only about 5 keywords there. I imported nearly 5,000 from my competitors to tab 2, any ideas what’s going wrong?

    • Matthew Woodward
      July 25th, 2019 at 3:08 am

      Either your keywords were bad or you didn’t set it up correctly

  31. Sudeendra
    7.11.2019

    I enjoy, cause I found exactly what I was taking a look for.You’ve ended my four day lengthy hunt! God
    Bless you . Have a great day.

    • Matthew Woodward
      July 12th, 2019 at 4:57 am

      Wow 4 days! Hope you’ve now found what you needed.

    • JAFER KT
      August 12th, 2019 at 2:14 am

      Thanks for Sharing this great information all..

      • Matthew Woodward
        August 12th, 2019 at 10:16 pm

        No problem Jafer

  32. Lisa
    6.19.2019

    Hey, I’ve received the welcome email and clicked on all three links in the email:

    download my intelligent Google Sheet
    Click here to download the sheet now
    this spreadsheet

    I’m not able to get the sheet. Are you able to share it by sending a direct link.

    Many thanks,

    Lisa

    • Matthew Woodward
      June 19th, 2019 at 7:07 am

      Weird – everything is working fine this end. Which version do you want?

  33. pribadi
    6.12.2019

    I failed to use your worksheet. I managed to copy the data into Tab #2, but there is no results in tab #3. There is only “N/A” results.
    I was using the blank sheet, where there is only shoutmeloud.com.

    I look forward to your assistance. Thanks.

    • Matthew Woodward
      June 12th, 2019 at 4:31 am

      You need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”.

  34. Michelle Christie
    6.10.2019

    Thanks for sharing, find good keywords is always a challenge and with so many tools I always get confused. One issue I always have is trying to figure which keyword is the best to target.

    • Matthew Woodward
      June 10th, 2019 at 9:14 pm

      Hey Michelle – well now you can use this spreadsheet to do all the research for you :)

  35. Rodrigo Toca
    6.9.2019

    Hey Matthew!!
    Both the files and your post is brilliant!! Been following your guidelines with some success =)
    I have the same issue as most here; Tab3 doesn’t show anything and in order to prepare a better question:
    1.- I am using the tool
    2.- I have opened the bolded sheets in blank and made a copy to my drive.
    3.- I’ve added at least 2 competitors on Tab1
    4.- I’ve added 6,000 rows on Tab 2
    5.- When you go to Tab3, there’s just an “N/A” with the Query all have copied before in cell D2. There doesn’t seem to be any formulas apart from column G for the featured snippet and column H for the Intent.
    6.- Tried to see if I had to run a macro but there are none
    7.- Not sure how to make it do the magic that you do with that voodoo SEO of yours =)

    Any thoughts?

    • Matthew Woodward
      June 12th, 2019 at 4:30 am

      Hey Rodrigo. I have just tested it all and seems to be working with no issues. You need to wait for Google to save the sheet then do the calculation.

      You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”.

      If you are still having problems then send a screenshot of tab #2 and a quick explanation to my email – [email protected]

  36. Cav
    6.8.2019

    Hi Matthew,

    I signed up and followed your instructions for the spreadsheet but after importing the data into tab 2 nothing is populating in Tabs 3 and 4. All I’m seeing is #N/A on those tabs. Not sure what the issue is.

    • Matthew Woodward
      June 12th, 2019 at 4:25 am

      This could be because you need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”. I have tested it all again my end and everything is working. If you are still having problems then send a screenshot of tab #2 and a quick explanation to my email – [email protected]

  37. Chris Labbate
    6.7.2019

    Matthew, WOAH, this is Grand. This is the first time I have used any of your strategies or processes, but I am SHARING this one in Facebook groups like crazy. Using it right now for one of my main SEO clients who are in a very narrow niche (Rural High-Speed Internet) with high competition levels for keywords. Halfway through the organic keyword swipe, but Im dying to get to the backlinks module. I love this SOP so much, Im going to do a Youtube video showcasing the process on my YouTube channel! Killer Stuff Bro! thanks a million.

    • Matthew Woodward
      June 10th, 2019 at 9:41 pm

      Thanks Chris! Make sure you send me a link to that youtube video :)

  38. Mik
    6.3.2019

    Hi Matthew, not sure what I’m doing wrong. I have followed steps 1 & 2 and tab 3 is not being populated? Thanks

    • Matthew Woodward
      June 12th, 2019 at 4:26 am

      Hey Mik, this could be because you need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”. If you are still having problems then send a screenshot of tab #2 and a quick explanation to my email – [email protected]

  39. Dane Alexander
    6.3.2019

    Really impressed with this strategy so far. Looking forward part 2. Cheers!

  40. gregory michiels
    5.29.2019

    Hi,i copied all the data from my competition to tab 2 (data)
    but nothing shows up in tab 3 (keywords)
    What did i do wrong or forgot?
    Thanks

    • Matthew Woodward
      June 12th, 2019 at 4:27 am

      Hey Gregory, I have tested it my end and all seems to be working well. You need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”.

  41. Breathe Fresh
    5.29.2019

    Thank’s For posting this informative article, I applied it and already my website traffic is increasing.

    • Matthew Woodward
      May 29th, 2019 at 5:23 am

      That’s fantastic news!

  42. Tess
    5.27.2019

    You provide some of the best and most actionable SEO tips and strategies online today. I have always loved your blog and work. I really appreciate this awesome share!

    Thanks!!!

    • Matthew Woodward
      May 29th, 2019 at 5:35 am

      Hey Tess, thanks very much. If something is worth doing then might as well make it the best :)

  43. Simon Williams
    5.26.2019

    when in step 3 no data comes up just N/A what am I doing wrong

    • Matthew Woodward
      June 12th, 2019 at 4:27 am

      Hi Simon – This could be because you need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”.

  44. bhavesh parmar
    5.24.2019

    This is one of the most helpful tutorials. I really appreciate your work, please keep it up and help others in such a unique way.
    Thanks

    • Matthew Woodward
      May 27th, 2019 at 5:46 am

      I certainly intend to – thanks

  45. Sumit
    5.18.2019

    sorry but you were not providing any type of downloading link through mail. you are making people fool. dont make people fool, f you really want to provide real content they do what you promise. I check your mail and it redirect to this page and i am not found any type of spreadsheet over here

    • Matthew Woodward
      June 11th, 2019 at 9:21 am

      If you took as much time to read the page as you took to complain, you would have found 1 of the 6 links to the spreadsheet to download.

  46. Saad Mir
    5.15.2019

    where is the download guide link? :-(

    • Matthew Woodward
      May 15th, 2019 at 2:17 am

      In the – How To Setup The Keyword Theft Sheet section. You’ll see the bold pink link with ‘(blank)’ at the end

  47. amjad
    5.14.2019

    how to use this tool

    • Matthew Woodward
      May 15th, 2019 at 2:02 am

      Just follow the guide :)

  48. BDzek
    5.14.2019

    Ive tried make a copy but is not working.What seems the problem?

    • Matthew Woodward
      May 15th, 2019 at 2:04 am

      No problems my end, are you making a copy of the blank version?

  49. Josh
    5.12.2019

    Hey,

    I followed all the steps but it seems it’s not doing the “keyword analysis” in Tab 3 nor the “final selection” in Tab 4.

    Both Tabs 3 and 4 have an error
    #N/A
    =QUERY(A2:D500,”select A,B,C,D WHERE A IS NOT NULL ORDER BY C ASC LIMIT 300″,0)

    Kindly let me know why the error occur and what should I do? Thanks!

    Reply

    • Matthew Woodward
      June 12th, 2019 at 4:28 am

      Hi Josh – This could be because you need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”. If you are still having problems then send a screenshot of tab #2 and a quick explanation to my email – [email protected]

  50. Spooky Boo
    5.10.2019

    Going through everything to find the spreadsheet. lol Haven’t found it yet. This is great info though. Keywords are a little hard because mine is all horror fiction in a story linkable universe, but I’m managing. Hoping to rank on scary stories and scary stories for adults which is a really huge market. But I’ll get there!

    • Matthew Woodward
      May 13th, 2019 at 2:47 am

      In the ‘how to set up the keyword theft sheet’ section, scroll down half a page and you will see it in bold

  51. jack
    5.10.2019

    section3 “keyword analysis” is blank.. i followed what your steps.

    • Matthew Woodward
      June 12th, 2019 at 4:29 am

      Hi Jack. You need to wait for Google to save the sheet then do the calculation – You have to wait for the little grey progress bar to finish on the right side and for it to say “all changes saved”. All is working when I tested it.

  52. JC Aranzado
    5.7.2019

    Thank you for sharing this keyword strategy. It was very useful!

    • Matthew Woodward
      May 8th, 2019 at 11:07 am

      No worries! Hope you found it useful.

  53. TheShopAlert
    5.4.2019

    Thank you for sharing this great amazing tutorial, I will start my keyword strategy.

    • Matthew Woodward
      May 6th, 2019 at 6:37 am

      Great decision.

  54. Karl
    5.4.2019

    Just took advantage of the SEOPower tools special you ran. Now I would like to take advantage of the spreadsheets. Once I provide my email address, I get to this page for “How To (Intelligently) Steal Your Competitors Best Keywords” But isn’t there a spreadsheet for backlinks? I can’t find a link to it on your site.

    Thank you for your tools.

  55. Abhishek Kuriyakottu
    4.30.2019

    I have one competitor kw sheet with shortcuts, but this is very very smarter than which I created.

    Thanks Bro!

    • Matthew Woodward
      May 2nd, 2019 at 1:00 pm

      No probs Abhishek, glad it was useful!

  56. Mintu
    4.28.2019

    Good post. Thanks a lot.

    • Matthew Woodward
      April 29th, 2019 at 12:27 pm

      No worries! Hope it proves useful :)

  57. Anjie
    4.21.2019

    I can’t find the Excel file

    • Matthew Woodward
      April 22nd, 2019 at 2:05 am

      It’s in the ‘How To Setup The Keyword Theft Sheet’ section

  58. Manjit
    4.17.2019

    thanks a lot

    • Matthew Woodward
      April 22nd, 2019 at 2:30 am

      *thumbs up*

  59. njoo.co.ke
    4.16.2019

    I thought I was getting a FREE PDF in exchange for my email subscription! :(

    • Matthew Woodward
      June 11th, 2019 at 9:37 am

      Where are the words PDF or eBook on any of the pages or video you went through? This is a free tool, not a PDF someone through together in an hour.

  60. ASHOK KUMAR
    4.15.2019

    That’s Great Idea. Very nice.

    • Matthew Woodward
      April 15th, 2019 at 10:58 am

      Happy to help :)

  61. Ahson
    4.12.2019

    unable to copy the sheet no link provided….

    • Matthew Woodward
      April 22nd, 2019 at 2:52 am

      The link is in bold in the ‘How To Setup The Keyword Theft Sheet’ section.

  62. manisha
    4.11.2019

    Thanks, Mathew

    • Matthew Woodward
      April 15th, 2019 at 12:00 pm

      No problem Manisha.

  63. addis Bekele
    4.9.2019

    Thank you man this is a million dollar post

    • Matthew Woodward
      April 10th, 2019 at 7:24 am

      Thanks, appreciate it :)

  64. Narayan Hariharan
    4.8.2019

    Thanks a lot!!!

    • Matthew Woodward
      April 10th, 2019 at 7:30 am

      No problem Narayan!

  65. Togedr
    4.8.2019

    Thanks For this post. really helpful

    • Matthew Woodward
      April 10th, 2019 at 7:31 am

      Glad to hear it.

  66. Ralph Smit
    4.5.2019

    Thanks! This looks awesome! If I make a copy of the blank sheet, will it also work if I open it in Excel instead?

    Thanks! Ralph

    • Matthew Woodward
      June 11th, 2019 at 9:37 am

      I haven’t tested it in excel

  67. rajesh
    3.23.2019

    Thanks a lot for sharing, Keyword strategy plays important role in any seo campaign

    • Matthew Woodward
      March 25th, 2019 at 3:11 am

      It sure does Rajesh!

  68. sukhbir
    3.21.2019

    Great help as always. will try it out. thank you for sharing.

    • Matthew Woodward
      March 22nd, 2019 at 3:12 am

      No problem, glad I could save you a bunch of time :)

  69. Amir
    3.21.2019

    That was great!

    • Matthew Woodward
      March 22nd, 2019 at 3:15 am

      Awesome :)

  70. Steven
    3.19.2019

    LOVE this…

    Can i use more than 5 competitor’s sites?

    Is there a way to clear the Select column in Tab #3

    • Matthew Woodward
      March 22nd, 2019 at 12:54 pm

      No and no sorry =/ but a clear all button would be good, let me add that to the ideas list!

  71. Shashank Ranjan
    3.19.2019

    Sounds good Mr Matthew. Would like to try this. Thanks for sharing!

    • Matthew Woodward
      March 21st, 2019 at 6:43 am

      No problem! You’re very welcome Shashank :)

  72. Frank
    3.18.2019

    Tab 3 gives me gibberish :)

    #N/A No FALSE

    #NA cell contents are:
    =IFERROR(__xludf.DUMMYFUNCTION(“QUERY(A2:D500,””select A,B,C,D WHERE A IS NOT NULL ORDER BY C ASC LIMIT 300″”,0)”),”#N/A”)

    • Matthew Woodward
      March 22nd, 2019 at 12:55 pm

      Which sheet?
      Which tool?
      Does the columns of your sheet on tab 2 match the columns on the sample sheet in tab 2?

  73. Kimberly
    3.18.2019

    I made a copy of the blank file, clicked on the ‘view the full tutorial’ and there’s no sound. ?

    • Matthew Woodward
      March 22nd, 2019 at 12:55 pm

      If your using chrome you might have to enable sound manually bwecause it auto plays

  74. David
    3.18.2019

    Blank sheet won’t work either , thoughts?

    • Matthew Woodward
      March 22nd, 2019 at 12:55 pm

      “wont work” doesn’t allow me to help you

  75. Polash SK
    3.18.2019

    Awesome!!! waiting for the further info. Thanks Matt.

    • Matthew Woodward
      March 21st, 2019 at 6:51 am

      No worries, happy to help Polash :)

  76. Nishant Chandravanshi
    3.16.2019

    I love you Matthew, my brother… You are such an amazing person. I have stopped visiting other blogs after landing on this page. I want to say many things but it is not a good place but yes you are marvelous.

    I have watched your PBN videos and you told us to not use Gmail for backlinks. Right.
    1. Should we use google spreadsheet or Microsoft Excel?
    2. How can I do if I want to attach a spreadsheet as you do? If someone wants to download it, they have to share that post.
    3. How I can set up the comment box (facebook account – like & share) like you do?

    I can understand you are a very busy person and you do not have leisure time to reply but when you get leisure time (2019), please help me. Take your time buddy. I can wait for you and now I am a regular reader of your blog. I am not allowed to use a third party website but still, I take the risk for your blog because I learn something. one click on your website equal to 2-3 learning. .. Awesome Awesome & Awesome.

    • Matthew Woodward
      March 22nd, 2019 at 12:56 pm

      I use Google for lots of things but NOTHING to do with PBN’s!

      And I havent tested if this works in excel so let me know haha

      That is done with a social locker

  77. Jason
    3.15.2019

    Great tool but I don’t see any quick or easy way to remove branded searches from the competitor data.

    How do you clean the data to remove all of the branded searches the competitors pages rank for?

    • Matthew Woodward
      March 22nd, 2019 at 12:57 pm

      Great idea for a future version, I could build that pretty easily! Thanks!

  78. G
    3.13.2019

    Hi Matt,

    Steps 1 and Steps 2 are no problem but when I try and complete Step 3 the all the sheet says is N/A. The function says: “=IFERROR(__xludf.DUMMYFUNCTION(“QUERY(‘#3 – Keyword Analysis’!E2:K1000,””select E,F,G,H,I, J Where K=””&TRUE&”” ORDER BY G,F LIMIT 100″”,0)”),”#N/A”)”. Got any idea how I can fix this?

    • Matthew Woodward
      March 22nd, 2019 at 12:57 pm

      Which sheet?
      Which tool?
      Does the columns of your sheet on tab 2 match the columns on the sample sheet in tab 2?

  79. Raj
    3.13.2019

    Hey Matthew,

    Appreciate your work,

    Thanks for sharing the blank sheet, but for some reason it’s only view access for me :(

    • Matthew Woodward
      March 22nd, 2019 at 12:57 pm

      Which one?

  80. Robbert
    3.11.2019

    Excellent Matthew, thanks a lot!
    I’m using it and it seems that the ranking keywords function is only available for the US.
    Entering other (European domains) just give zero results. Maybe it’s good to add that to the instructions.
    best regards, Robbert

    • Matthew Woodward
      March 22nd, 2019 at 12:58 pm

      Hmmm follow up with their support team because that doesnt sound right

  81. Michael Bryan
    3.10.2019

    Thanks Matthew was trying to work out to do this in libre office but you have saved me the pain, looking forward to the other sheet that collects all those beautiful back links to give to my va

    • Matthew Woodward
      March 16th, 2019 at 7:49 am

      Cheers Michael, sounds like it was good timing then :)

  82. cheefoo
    3.8.2019

    Thanks for the awesome kw guide. If we would like the 3rd tab (kw analysis) to show lower volume say 100, how should we change the query ?

    Because we focus more on local seo, and the volume will be much lower.

    • Matthew Woodward
      March 22nd, 2019 at 12:58 pm

      You can’t but I will release a new version with that taken care of

  83. Andrew
    3.8.2019

    Doesn’t allow me to make a copy

    • Matthew Woodward
      March 8th, 2019 at 10:35 am

      The blank sheets do, the sample sheets don’t

  84. John
    3.7.2019

    Is the analysis tab supposed to have 300 keywords maximum? I added 5,000 to the second tab, and tab 3 shows 300 keywords analyzed. Thanks

    • Matthew Woodward
      March 22nd, 2019 at 12:59 pm

      Yes it outputs to the top 300

  85. Aby
    3.6.2019

    Hey, thanks for sharing. Got a question: How is this different than just using ahrefs to analyze a competitor’s backlinks?

    • Matthew Woodward
      March 22nd, 2019 at 12:59 pm

      Ahrefs don’t merge data from multiple profiles nor do they do any of the filtering

  86. TA
    3.6.2019

    This is a huge time saver! Thanks for making it available.

    • Matthew Woodward
      March 8th, 2019 at 3:33 am

      No problem, glad I could help save a bit of time!

  87. Harry
    3.5.2019

    Thank you so much Matthew,
    As usual your post full with great information. I will follow this guide.

    • Matthew Woodward
      March 6th, 2019 at 10:26 am

      Thanks Harry. Good luck!

  88. jay
    3.5.2019

    my export is a text file. how do I get this to look proper in excel?

    • Matthew Woodward
      March 22nd, 2019 at 1:00 pm

      If its a csv file make sure your opening it in excel

  89. Carl
    3.5.2019

    I do not see the File link. I tried various ways of downloading, copying the formula, clearing the cache, refreshing and rebooting. I clicked the red link:
    When you are ready make a copy of the Google Sheet below-

    Do that by going to File > Make A Copy.

    Same problem on both the keyword page and the links page. I sent you an email with a png of what i see on my screen.

    • Matthew Woodward
      March 5th, 2019 at 2:24 pm

      I haven’t seen any email sorry

  90. Godwin
    3.5.2019

    That was great!

    • Matthew Woodward
      March 6th, 2019 at 10:27 am

      Perfect!

  91. Mattijs
    3.5.2019

    Awesome! Is it possible to change the minimum keyword volume shown in the keyword analysis tab?

    • Matthew Woodward
      March 22nd, 2019 at 1:00 pm

      Not yet!

  92. umair ansari
    3.4.2019

    This is super cool.

    • Matthew Woodward
      March 22nd, 2019 at 1:00 pm

      No worrys :)

  93. Joel
    3.4.2019

    This is an incredible resource! I did all of this manually on my own in the past so when I used the spreadsheet my mind exploded haha thanks, Matt!

    • Matthew Woodward
      March 22nd, 2019 at 1:00 pm

      That’s why I built the sheet haha

  94. Shaheen
    3.4.2019

    Thanks Matt, this looks killer as always! You probably have enough clout man, you should see if they’ll make you an approved app so we can get their partner API key thing without having to go all in on an API plan.

    PS. Love the styling, Google sheets wizardry is one thing, but you don’t see brand consistent sheets that often!a

    • Matthew Woodward
      March 22nd, 2019 at 1:01 pm

      Yeah I wanted to but they were shy about it. Thanks, styling is nothing fancy just a few headers!

  95. Dave
    3.4.2019

    Very Good!

    • Matthew Woodward
      March 4th, 2019 at 1:42 pm

      Thanks very much Dave!

  96. Jordan
    3.4.2019

    Guys, is the sheet working alright for everyone? After pasting the data in sheet two, there no keywords being processed in sheet 3. It stays blank.

    Awesome tool, Matt! Incredible idea.

    • Matthew Woodward
      March 4th, 2019 at 2:53 pm

      Sorry Jordan, try making a copy now and make sure it’s from the link in bold not from the sample sheets.

  97. Hernan Theis
    3.4.2019

    Thanks, Woodward!
    Excellent Job!

    • Matthew Woodward
      March 4th, 2019 at 1:20 pm

      Glad I could help :)

  98. Bruno Santos
    3.4.2019

    Hello,

    Thank you for such an interesting strategy. I’ve loaded a total of 8000 keyword into the sheet but just around 200 are being copied to the #3 sheet. How can I solve this?

    Thank you.

    • Matthew Woodward
      March 22nd, 2019 at 1:01 pm

      Yes its limited to that number

  99. Phil Gregory
    3.4.2019

    Great Freebie Matt, much appreciated

    • Matthew Woodward
      March 4th, 2019 at 1:06 pm

      No problem Phil :)

  100. Nelson
    3.4.2019

    Hi Mathew Woodward, what if we blog about politics and the content produced isnt important pass that day. My niche doesnt suppor ever green content.
    Thanks

    • Matthew Woodward
      March 22nd, 2019 at 1:02 pm

      Then you can only look at keywords that had 2017 or 2018 in them and predict what they will be with 2019 in them

  101. David
    3.4.2019

    Hey,

    I followed all the steps but it seems it’s not doing the keyword analysis nor the final selection.

    Both Tabs 3 and 4 have an error
    #N/A
    =QUERY(A2:D500,”select A,B,C,D WHERE A IS NOT NULL ORDER BY C ASC LIMIT 300″,0)

    Thanks for sharing and save us time

    • Matthew Woodward
      March 22nd, 2019 at 1:02 pm

      Which sheet?
      Which tool?
      Does the columns of your sheet on tab 2 match the columns on the sample sheet in tab 2?

  102. Reece Major
    3.4.2019

    Wow this is amazing!

    Thanks a lot, Mathew!

    • Matthew Woodward
      March 4th, 2019 at 1:07 pm

      Hey Reece, glad you liked it! Hope it proves useful.

  103. Peter Nyiri
    3.4.2019

    I am really amazed about the the stuff that you come out with. Originally I came across your blog by accident. I have been following you since. The best thing I learned from you is writing thorough blog posts and I must admit that I stole this strategy of yours… But this has been the best thing I’ve ever done. A blog post I wrote a while ago using this strategy has produced a thousand dollars in affiliate commissions and I am really happy with that! Thanks.

    • Matthew Woodward
      March 4th, 2019 at 1:09 pm

      Thanks Peter! That’s awesome news, keep up the great work :)

  104. Jon
    3.4.2019

    Beautiful!

    • Matthew Woodward
      March 4th, 2019 at 1:09 pm

      Cheers Jon!

  105. lyndon ogden
    3.4.2019

    Hi Matt,

    I already have an account. There seems to be no way of linking the spreadsheet?

    Cheers
    Lyndon

    • Matthew Woodward
      March 22nd, 2019 at 1:02 pm

      Linking?

  106. Chimezie
    3.4.2019

    This is really an awesome time saver.
    Thank you so much.

    • Matthew Woodward
      March 4th, 2019 at 1:10 pm

      Happy to help!

  107. Matthew Simiana
    3.4.2019

    Handy sheet, looking forward to the rest of the tutorial.

    • Matthew Woodward
      March 4th, 2019 at 1:12 pm

      Thanks Matthew!

  108. Dima
    3.4.2019

    Great so far, can’t wait for the further info.

    • Matthew Woodward
      March 4th, 2019 at 1:11 pm

      Thanks a lot Dima :) Hope you find it as useful as I do.

  109. Kristjan
    3.4.2019

    Good morning Matthew, awesome sheet!
    Am I being thick, can’t actually make a copy of the sheet…

    • Matthew Woodward
      March 4th, 2019 at 2:54 pm

      Try it now… Make sure you are making a copy of the blank sheet (link in bold) not the sample sheets in the tabs :)

  110. Carl King
    3.4.2019

    Sounds great Matthew! Looking forward to the pudding.

    • Matthew Woodward
      March 4th, 2019 at 1:17 pm

      We all love a bit of pudding :)

    • Stephen
      August 2nd, 2019 at 10:15 am

      This really a nice write up. It will help in my blog.

      • Matthew Woodward
        August 3rd, 2019 at 2:17 am

        Cheers Stephen

  111. Adflix
    3.4.2019

    Awesome , can’t wait for tomorrow

    • Matthew Woodward
      March 22nd, 2019 at 1:02 pm

      If it ever comes

  112. Tony
    3.3.2019

    I can’t make a copy on your google spreadsheets. Please check that.

    • Matthew Woodward
      March 4th, 2019 at 2:55 pm

      Hey Tony, you can’t make a copy of the sample sheets but you can make a copy of the blank sheet (link in bold a bit further down).

What are your thoughts?

* Name, Email, Comment are Required