How To Visualize Serpstat Reports Using Google Data Studio Connector

All you need is a Google Account to create reports. Several data sources are available for analysis and clarity, and if you want to analyze Serpstat data, you should apply the Serpstat connector. This tool allows you to access the Serpstat reports.

Now there are two available Serpstat reports, which you can download in the Looker Studio: Domain History and Competitors. Depending on users needs, we'll extend the range of options in the future.

Looker Studio shows the following data:

• Organic traffic and visibility: the amount of organic traffic and the visibility of the website, which is calculated based on the keywords for which the domain appears in search results.

• Organic keywords: the list of keywords for which the website analyzes is displayed in the search engine results.

• Paid keywords: the list of keywords for which the domain ranks in the paid search results.

• Competitors: See the list of your competitors, visibility, traffic, and keywords dynamics and domain's visibility.
  

Click on the button to connect Looker to Serpstat and set reports. You can authorize by connecting to your Google Account:

To integrate the data from Serpstat, you should enter your API token. You can find it in your profile:

If the token is valid, your data will be connected to the Looker Studio. To try the analysis, you should do the following:

• Enter a domain for the analysis in the form example.com.

• Choose the method you want to use to collect the information. There are currently two reports available: Domain History and Competitors.

• Set the search engine database from which the data will be displayed.

• Click on the button Connect in the upper right corner.
  

In the upper left corner you can rename the report.

After setting up the data sources, you'll have a new window with 2 tabs: Create Report and Explore.

You can view and adjust the data for visualization on the Explore tab. In the navigation menu on the right, you can select the parameter (it is convenient to select date for the History report, and domain name for Competitors) and indicators. On the Create Report tab you'll find a report template. This is an example of what your report might look like. It is formed by two reports: Domain History and Competitors.

The Domain history report corresponds to the first three tabs:

• Organic traffic and visibility

• Organic keywords

• Paid keywords.

The Competitors report corresponds to the competitors tab.

Depending on specified data sources, the template fills in the area that corresponds to the specific Serpstat report. If you don't want to visualize all the data offered, you can easily delete unnecessary tabs. The template introduced above is just an example and the user can set any report in any convenient way.

If you want to combine two reports in one to have all the information in one place, you have two ways:

We create two separate History and Competitors reports.

Go to the Competitors report and copy the tables on the page:

Go to the History report, select the fourth page and insert the data.

If you don't want to create two separate reports and transfer data by copying, you can do everything in one report. Create the History report. Then go to Resource → Manage added data sources and click on the Add a data source button:

Select Serpstat Connector:

In the configuration window enter the same domain, but choose another report. Then add this data to the history report:

Go to the Competitors tab and add this field to the report:

Reports are stored in a cache so you can load them faster. When setting up the connector and creating the report, you will see a note that the data is being updated every 12 hours.

You can set how often the connector should update the data source. For example, sheets can be checked every 15 minutes (default) for 4 or 12 hours to see if there is updated data. Some data sources only support setting by default (12 hours).

The data can be updated manually at any time in the report:

Or in the Explore tab:

To disable cache data storage, make the following settings:
File → Report Settings → Enable Cache.

With this setting, the manual update is still available.

To display Serpstat reports in Google Looker Studio, you should have:

• a Serpstat account

• API access

• personal API token in your profile.

You must have the Max number of API results to be exported credits to create the report in the Looker.

If you don't have the API access, contact the support team by completing a product demonstration form, or you can use our live chat.

Limits are spent while choosing the report type, depending on which method you choose and how many lines of results you get in the finished report. Next limits are spent while updating the report (12 hours each or on request). You can create the report and update it only when needed, thus saving limits.

Google Looker Studio is a useful tool that lets you visualize data quickly and easily. In combination with Serpstat, it offers unlimited possibilities for analyzing SEO ranking services. To visualize the Serpstat reports, you should: