3 Great SEO Tools for Google Sheets in 1 add-on!

The “Authoritas Really Useful Keyword Tool” add-on gives access to three core SEO tools powered by the Authoritas SERPs API.  You have the option to query all 3 tools at once or to just select the specific tools and output format you are interested in.

*** 1- Keyword Ranking for Google Sheets ***

Add a list of keywords to any sheet and get rankings for multiple domains from any search engine worldwide.

*** 2 - Top 100 SERP Results for Google Sheets ***

You can also get a list of the top 100 competing sites for every keyword.

*** 3 - Keyword Research with User Intent ***

Our keyword research tool gives you User Intent, Above the Fold analysis and comprehensive suggestions from related searches and People Also Ask results.

*** HOW TO GET STARTED ***

Get a free API key from Authoritas and get 1,000 keyword credits per month for free.  For further details see: https://www.authoritas.com/google-sheets-add-on-the-really-useful-keyword-tool/

*** Common SEO Use Cases & Challenges Solved by this Sheets add-on ***

- Perform one-off or regular scheduled keyword ranking tasks
- Check the rankings of multiple domains in one go (so you can track social media channels, sub-domains and microsites)
- Pull-in and analyse the top 100 competitors for any keyword in any major search engine worldwide
- Perform in-depth keyword research and get related keywords, questions people ask, universal SERP features and unique to Authoritas – the keyword or user intent for the keyword phrase
- Once the data is in Sheets you can easily visualise it in Google Data Studio and/or send it to Big Query
- If you are considering using the Authoritas SERPs API for your SEO project, then the Google Sheets add-on is a great way to test the API without having to get an engineer to do it for you

*** Further Details of these 3 great SEO tools ***

1. Keyword Ranking for Google Sheets

This tool replicates the keyword ranking functionality found in the Authoritas SEO platform.

If you have ever wanted to create your own keyword rank checking tool then we’ve just made the job really easy for you.

Simple enter a list of keywords and a search engine combination and click ‘RUN’.

You can run a request on-demand whenever you want and/or you can schedule lists of keywords to run on a regular schedule (daily, weekly or monthly).

Your Google Sheet will then call our Keyword Ranking API and create a task to collect all the data for you.  For each valid request we return the following data in a new sheet called “Keyword Rankings”:

Organic Rank – the position for your domains within organic ranking results only
Organic URL – the page(s) for your domain(s) which is ranking in the organic results
Above the Fold – a flag indicating whether the organic ranking page is above the fold of the page
Visible – a flag indicating whether the Organic URL is visible to a user without scrolling (e.g. It may appear but be hidden in a carousel)
Universal Rank – the position for your domains within all results types (e.g. Including organic, featured snippets, videos, images, social, etc).
SERP Feature – The type of Universal Search result – e.g. Video, News, Image, etc.
Universal URL – the page(s) for your domain(s) which is ranking in the Universal Ranking position
Above the Fold – a flag indicating whether the organic ranking page is above the fold of the page
Visible – a flag indicating whether the Universal URL is visible to a user without scrolling (e.g. It may appear but be hidden in a carousel)

We also record the full request details for each keyword request to help your analysis: Date and time, the Search Engine, Region, Language, Device, Town, Latitude & Longitude.

2 - Top 100 SERP Results for Google Sheets

This tool gives you the complete listing of all ranking URLs and universal search results for each keyword, as if you had made a request to the Authoritas SERPs API.

This is a great way of analysing the URLs you are competing with to diagnose competitors who are outperforming you and Universal Search opportunities to go after such as Featured Snippets, Videos, Images, People Also Ask, etc.

3 - Keyword Research with User Intent

N/B: You must select Google as your search engine if you want to use this tool.

This gives you deep information about your keyword and related keywords and replicates some of the advanced keyword research tools and data in the SEO platform.  It offers you a great way of improving your existing keyword research process.  Enter a seed list of keywords and the service will return a list of up to 8 related keywords and up to 4 questions that people also ask (this may not appear for all keywords).

Uniquely, the service will also return you the User Intent for each keyword which should help you determine what type of content you need to write for each keyword phrase.

Local Intent – Do local listings appear for this keyword. This flag is a signal that local businesses have a good opportunity to compete with major national brands.

Dominant User Intent – This indicates the primary intent of the user across the 4 types of User Intent.

Navigational Intent Score – Search terms that are centered on a brand, company or person.

Informational Intent Score – Keywords that have low commercial intent.
Research Intent Score – Search phrases with strong commercial intent earlier in the buyer journey.

Transactional Intent Score – Search phrases with high purchase intent and value close to the end of the buyer journey