How to connect SE Ranking data sources to view data in Google Looker Studio – Knowledge Base

In order to use the data provided in SE Ranking’s demo report in Google Looker Studio, you first need to authorize the SE Ranking Rank Tracker connector in the list of Partner Connectors in your Google Looker Studio account.

Once authorized, you need to define 6 data sources, namely Rankings Overview for Google, Rankings Overview for all search engines, Average Rankings Chart, % In TOP 10 Chart, Search Visibility Chart, Detailed Rankings.

Rankings Overview for Google

1. Open the connecter via a direct link and name the report.

2. If you haven’t done this already, you will then need to authorize Google Looker Studio and the SE Ranking Rank Tracker connector:

rank_tracker

3. Next, under Parameters, select “Rankings Overview” as the Report Type, select an SE Ranking project from the list of available options, and define the Search Engine ID as “200” (meaning Google). Click “Connect”:

rank_tracker

Note: You can learn about the Search Engine ID in our Google Looker Studio integration guide .

4. In the next window, click “Add a field”

add_a_field

5. Define the Field Name as “Top Type”, the Field ID as “calc_x6qogtpl1b”, enter the following piece of code into the text area marked as Formula:

CASE
  WHEN `position_organic` >= 1 AND `position_organic` <= 3 THEN '1. Top 1-3'
  WHEN `position_organic` >= 4
 AND `position_organic` <= 10 THEN '2. Top 4-10'
  WHEN `position_organic` >= 11 AND `position_organic` <= 30 THEN '3. Top 11-30'
  WHEN `position_organic` >= 31
 AND `position_organic` <= 100 THEN '4. Top 31-100'
  ELSE '5. Out of index'
 END

6. Click “Save”:

top_type

Note: The field needs to be created with the Field ID parameter, so that when you further copy the report, you can restore the “Distribution of top positions” chart.

Rankings Overview for all search engines

Create a new data source, change its name to “Rankings Overview for all search engines” to get data on all search engines tracked in a project.
Select “Rankings Overview” as the Report Type, select an SE Ranking project from the list of available options, but leave the Search Engine ID option blank.
Click “Connect”:

Average Rankings Chart

Create a new data source, change its name to “Average Rankings Chart”.
Select “Average Rankings Chart” as the Report Type, select an SE Ranking project from the list of available options, define the Search Engine ID as “200” (meaning Google).
Click “Connect”:

% In TOP 10 Chart

Create a new data source, change its name to “% In TOP 10 Chart”.
Select “% In TOP 10 Chart” as the Report Type, select an SE Ranking project from the list of available options, define the Search Engine ID as “200” (meaning Google).
Click “Connect”:

Search Visibility Chart

Create a new data source, change its name to “Search Visibility Chart”.
Select “Search Visibility Chart” as the Report Type, select an SE Ranking project from the list of available options, define the Search Engine ID as “200” (meaning Google).
Click “Connect”:

Detailed Rankings

Create a new data source, change its name to “Detailed Rankings”.
Select “Detailed Rankings” as the Report Type, select an SE Ranking project from the list of available options, define the Search Engine ID as “200” (meaning Google).
Click “Connect”:

Once all six Data Sources have been set up, you can copy SE Ranking’s demo report:

copy_demo_report

In the popup window, you need to assign previously created Data Sources, and click “Copy Report” to generate a copy of the report that you can work with.

copy_report