New in Keywords in Sheets PRO: 5 new search result functions, including get rankings, top search results, top search titles, related searches and SERP similarity 🚀
Check out the video tutorial 🎥
1. Requirements
2. Our new functions
We’ve just released 5 new search result functions in Keywords in Sheets PRO, including:
- Get rankings
- Top search results
- Top search titles
- Related searches
- SERP similarity
It makes analysing search results so much faster! Near 70 countries supported 🌍
How do credits work?
Our search result functions use 1 credit per request (search results are cached for 7 hours).
In our $30 plan, you get 30,000 credits. That’s $0.001 per search result (some of of the lowest rates on the market). Or you can trial Keywords in Sheets for $1 for 7 days and get 500 credits.
Rankings
Get the rank of any URL in search results for a given keyword.
=rankings(keyword, url, country, language, featuredSnippet, refresh)
Ranking Results
Get the top ranking URLs in search results for a given keyword.
=rankingresults(keyword, country, language, num, featuredSnippet, refresh)
Ranking Titles
Get the top ranking titles in search results for a given keyword.
=rankingtitles(keyword, country, language, num, featuredSnippet, refresh)
Related Searches
Get the related searches from search results for a given keyword.
=relatedsearches(keyword, country, language, num, refresh)
SERP Similarity
Compare two search results and get the percentage of URLs that match from the top 10.
=serpsimilarity(keyword1, keyword2, country, language, refresh)
3. Good to know
Some useful information on how to use the functions (and how to save credits).
- You should drag the formula down to a maximum of around 100 rows. Google Sheets only allows you to run 30 functions simultaneously , so it will be slow at scale.
- Typically, around 5-10% of your functions will timeout. This is because Google Sheets has a 30-second timeout. Use the refresh parameter to quickly refresh all cells.
- Every time a search results function successfully returns data, it is stored in a cache for 7 hours. That means once you receive data from one of the search results functions, like Ranking Titles, you can use all of the other search result function, like Ranking Results, without using credits for 7 hours.
Thanks for stopping by 👋
I’m Andrew Charlton, the Google Sheets nerd behind Keywords in Sheets. 🤓
Questions? Get in touch with me on social or comment below 👇