How to use ranktank google sheets real-time keyword tool
If you have not heard or known about this free and simple keyword tool, you should check it out.
I'll give you the link at the end of the article.
First, let me tell you the story how I stumbled upon this free and real-time tool ( which is very rare because even Google Search Console tool is not real time, at least at the time I wrote this ).
At that time, I was searching the free and simple tool to let me know how's the rank for a keyword, for a given URL.
To make the story short, I came across this ranktank free keyword tool.
The tool is really simple, it can be run only using Google Sheets.
No need to sign up for anything, but the author would appreciate it if you gave him your e-mail address.
After copying the tool to my Google Sheet, I opened it and I was a bit confused to see it.
I am confused how to get started with this tool.
Then, I tried to edit "Your domain" value with the domain of this site: kevinhq.com
I choose the region to be "United States" though when you clicked the down-arrow icon next to it, it will gave you a long list of other countries.
Same thing with the "Language" column.
I left it with "English"
Next, I jumped into the section where "Keyword", "MSV", "Rank", "Ranked URL", and the other columns are.
At this point I still don't understand how this works.
What I tried is I changed the value of "Keyword" column on the first row.
I typed "kevinhq rails" there.
Voila! When I finished the change, it seems to trigger the tools to work.
The text under "Rank" column is changing to "Crawling" for some seconds, then it shows "1" there.
The same thing happened on the rest of columns for that row.
Now I got how this tool works.
It's working based on the value you type on the first section here, by specifying the domain you want to check.
I never use SEMRush tools so I just left it as no.
What I loved most about this tool is its simplicity and it's very easy to use and get the informations you required:
What's the rank for that keyword on "Rank" column
What's the URL that ranked for that keyword on "Ranked URL" column.
Who's right above you on the "Who's right above you" column. This will be blank if you're ranked on the first. But this will give you the URL of the site which position is right above your site on SERP, for that keyword.
Who's right below you on the "Who's right below you" column. Same as "Who's right above you", it told you the site's URL which is right below yours on SERP.
Who ranks number one for that keyword on "Who ranks number one?" column. This will give you the site's URL which is on the top position of SERP for that keyword you inputed.
And the best stuff about this tool is it is checking on the real-time Google Search Engine Result Page.
This means, if you get ranked number one for the keyword you typed on "Keyword" column. You can see the same result when you're heading to google.com and type that same keyword, and you're going to see the same result.
Very cool, isn't it?
Unlike other tool, even for Google Search Console ( formerly Google Web Master Tools ), which only gave you the data from days or weeks or even months ago.
Before I forget, here's the link to the tool: https://www.ranktank.org/keyword-position-checker-tool/