Free Keyword Difficulty Tool & Opportunity Finder

 

A Free Google Keyword Finder and Ranking Difficulty Tool Built in a Google Sheet!


RankTank Keyword Opportunity Finder was initially built as an internal SEO keyword finder at CircleRank, Sean’s agency. The goal was to get a whole load of keyword suggestions, and at a glance be able to which ones would be easier to rank for based on competition. Luckily, mashing up SEMrush’s API with Google’s Autosuggest provided just such data!

We then took it a step further by crawling the top 10 results for any given keyword to see if the pages were optimized for said keyword. The less optimized the pages were, the easier it would be to rank! CircleRank uses this tool in house to find “sure things” that are relevant and on topic – in a super scaleable way!

Not sure where to start your keyword research?
Get this SEO tool free now!
Step 1:
Step 2:
Get the free SEO tool!
Click the button below to open Google Sheets and make a copy!
Open in Google Sheets

How to Use This Thing

It’s easy! Just enter your keyword in the “Starting Keyword” box and press enter! Let’s use screenshots to show off some of the deeper functionality:

1. Do I need access to SEMrush to use this?

No, but it sure helps! You can still get keyword suggestions in the first tab, and use the full features of the Advanced SERP Ranking Difficulty Analysis tab without ever having to enter an API key. However, using a SEMrush API key (only $15!) in the Config tab GREATLY expands the first sheet! Using the key, you’ll be able to select your search volume, result number and keyword ranking difficulty parameters – and have the matching keywords automatically highlighted!

 

2. How do I choose parameters and select keywords?

It’s easy! If you have your SEMrush API key entered in the Config tab, you can use the “Define Ideal Keywords” box (highlighted in red) to set up your parameters. Keywords falling within the parameters you set will be automatically selected and highlighted!

You can also use the “Choose Keyword” column (column C) to manually select keywords by changing the drop-down to “TRUE”, shown with an arrow in the screenshot. If you’re not using a SEMrush API key, this is how you will build your list!

3. Advanced SERP Ranking Difficulty Analysis

 

We’re really proud of this feature. The keyword drop-down is auto-populated from the keywords you’ve selected on the first sheet. Then, the Google Doc crawls the top 10 Google results for the term, and looks for 11 on-page metrics to determine if that page has been specifically optimized for that keyword.

The best part? It uses NO APIs whatsoever! It’s all done through formulas!

Back to top!

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.

20 thoughts on “Keyword Opportunity Finder”

  2. Francisco

    Hi,

    I seems that semrush closed its API for $15 USD and now it’s only available for business accounts. Now what we would do?

    (the sad part is that I’ve found this amazing tool today and noticed the api thing when I was about to buy one 🙁

    Reply
  5. Jose

    The sheet stopped working after the first try. It just hangs on semrush loading… and doesnt populate the cells below. Any idea how to fix ? I’ve tried logging in and out of the account.

    Reply
  9. Simon

    Hi Love the tool! But the SERP analysis tab only works on very few occasions for me (when it does its great!!) and I can’t figure out what i’m doing wrong/different.

    Can you give me any tips – advice on using it.

    Thanks in advance
    Simon

    Reply
  10. Juan Pastás

    Hi,

    =query(‘Google Organic Results Helper’!F:F,”SELECT F LIMIT 10″)

    Is throwing empty results in difficulty sheet. Any advice?

    Do I need to download a sheet called ‘Google Organic Results Helper’ from somewhere else?

    Thanks.

    Reply
  11. Tomislav

    Is there a chance you might add hr in the dropdown list? I would add it myself but the “Data” Worksheet seems to be hidden somehow.

    Reply
  12. Natalie

    Hi, is it possible to add Ukraine in drop-down list? Or you could you give me a hint how to make it by myself?

    I would be really grateful for that! Thank you in advance.

    Reply
  13. John

    I want to clarify what I mean. I need to check the difficulty of the keywords I bulk import. because i see you have a bulk import excel doc but u cant check keyword difficulty. thankyou

    Reply
  15. Tony

    Hi Sean,

    I am in Russia and SEM Rush also works for Russian. But in the drop down there is no option to select Ru as the country. Is these easy to add to the tool?

    Reply
  16. RAED

    That’s really a great tool…..
    It’s the easiest I’ve ever used ….. it saved me time and money for what I used to do on my own.

    Thanks RankTank

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*