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

I'm sure you already know that in January 2019 we presented a document which allows you to upload information from the Serpstat API! No? Then read the post!

Many users appreciate the convenience and functionality of the document. That's why we decided to release a new version with advanced features. Serpstat Batch Analysis for Google Spreadsheets was created to simplify and automate the work with analytical information. You can get information about domains or pages, grouped in separate tabs of Google spreadsheet in just a few clicks.

To use the add-on and upload the necessary data, you need to copy the API key (token) in the personal profile and enter it into the appropriate field. After that you'll see a sidebar.

But the first question that arises: is the indicator that we get good or bad? To do this, we derive a scale where we show the relevance, based on the competitor analysis. This is the average value indicated by the green area.

If we approach the minimum value, it means that the words from the query are too far apart in the text on the page, or are seldom used.

If we see that the indicator is approaching the maximum, then this indicates spam. You can remove some of the repeated words, or distribute them less often in the text.

In the menu on the right you need to:

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

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

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

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

Select a report. Choose the API method which you need to get data. After that, filters will open (if they are provided for this method). Set up the filters and click Create Report.

The report will appear on a new table sheet:

To create reports using the add-on, you need to check Max number of API results to be exported:

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

If you don't have API access, please write to our chat or contact support by filling out the product demonstration form.

Serpstat Batch Analysis add-on for Google Spreadsheets is a unique tool that allows you to conduct batch analysis of data quickly and easily. In combination with the Serpstat API, the add-on offers advanced capabilities for analyzing competitors. To upload data with the Serpstat API, you need to: