36463 76 1
Serpstat updates 6 min read March 10, 2021

Serpstat API Batch Analysis Add-on For Google Sheets: Data Analysis In One Click

Serpstat API Batch Analysis Add-on For Google Sheets: Data Analysis In One Click
Stacy Mine
Stacy Mine
Editor at Serpstat

Stop exporting data from the interface to Google Sheets — extract it in bulk directly in a Google Sheets file. SEO API Batch Analysis Add-on automates and accelerates data analysis.

Whether you need to analyze a batch of keywords, domains, or URLs, the add-on can do it all! Let's learn more about the add-on and how to process big data sets with it.

Serpstat API Batch Analysis

API Batch Analysis add-on for Google Sheets is a unique tool that allows you to conduct data batch analysis quickly and easily. In combination with the Serpstat API, the add-on offers advanced capabilities for analyzing competitors and doing a keyword research. 

The extension helps to research data by domains, URLs, or keywords in bulk in real-time without having to access the Serpstat interface. You can use the option after installing the Serpstat extension to Google Spreadsheets.

    Setting up the add-on

    Step 1. Go to Chrome marketplace and press the Install button.

    Creating a project

    Step 2. Go through a short authorization with your Google account:

    Setting up a projectSetting up a project

    Step 3. Go to the Extensions section and select Serpstat Batch Analysis. There are two buttons in the menu: Create report and Settings.

    Opening a project

    Discover all benefits of SEO platform!

    Activate a free 7-day trial and try out batch analysis tools. We'll provide you with learning meterials and tutorials for a swift tools mastering.

    Start my journey

    Creating a report

    To use the add-on and generate the necessary data, you need to copy the API key (token) in My account and enter it into the appropriate field.

    You can later change linked token in Settings.

    Creating a project via Keywords selection

    After that, you'll see a sidebar.

    Creating a project via Keywords selection
    Note: the sidebar won't be opened until you enter a valid token.

    In the menu on the right, you are to:

    1. Select a search region. Choose a regional database for which you want to get a report.

    2. Select a cell range. It displays a cell value in which the cursor was placed by default. It must be set manually.

    Note: the data must be entered using A1 notation.

    To change the range, select the desired cells in the table. Click the icon near the corresponding field to save the changes.

    If you need to select multiple ranges, click "Add another range". You can seperate ranges by commas in the right menu.

    Logs in the project

    3. Select a report. Choose the API method for the data extraction. After that, filters will be opened (if they are provided for this method). Set up the filters and click Create Report.

    Logs in the project

    The report appears in a new table sheet:

    Logs in the project

    You can share a report with your team or client.

    How are credits charged?

    To get data using the Serpstat Batch Analysis add-on for Google Sheets, you need:

    1.Serpstat account
    2.API access
    3.API token

    Serpstat API Batch Analysis add-on spends API credits:

    Logs in the project

    API credits are spent according to the following formula: 1 domain / 1 URL / 1 keyword = 1 request.

    Experience the full capabilities of our SEO platform with a free trial.

    Try the platform for free for 7 days and see the benefits for yourself!

    Cancel any time.

    Sign up

    Use Cases

    The tool is primarily used by teams of specialists who require bulk analysis: SEO specialists, PPC specialists, copywriters, blog editors, SMM specialists, marketers.

    1.Conduct a competitor batch analysis: a list of pages or domains to analyze competitors' keywords and positions. 
    2.Look for missing keywords — keywords that your competitors rank for in the top 10, but your pages don't even rank in the top 100.
    3.Obtain competitive PPC analysis data: examples of competitors' ads, landing pages, keywords competitors use to run ads, and an approximate budget for their PPC campaigns.
    4.Collect a list of keywords for a page or website: research keyword variations and related keywords. List your keywords and expand them with new variations.
    5.Get search suggestions and questions to pick a trending topic for new content.

    If you still have questions, you can find answers in our FAQ, use cases or contact the technical support chat.

    Rate the article on a five-point scale

    The article has already been rated by 7 people on average 5 out of 5
    Found an error? Select it and press Ctrl + Enter to tell us

    Share this article with your friends

    Are you sure?

    Introducing Serpstat

    Find out about the main features of the service in a convenient way for you!

    Please send a request, and our specialist will offer you education options: a personal demonstration, a trial period, or materials for self-study and increasing expertise — everything for a comfortable start to work with Serpstat.

    Name

    Email

    Phone

    We are glad of your comment
    I agree to Serpstat`s Privacy Policy.

    Thank you, we have saved your new mailing settings.

    Report a bug

    Cancel
    Open support chat
    mail pocket flipboard Messenger telegramm