Search our Knowledge Base
Search

Data Studio with Rank Ranger Data via Supermetrics



Learn how to integrate Rank Ranger rank data into Google Data Studio via Supermetrics connector.

Before you start building reports in Data Studio, we encourage you to browse through our marketing dashboard sample dashboards (password is demo) or consider scheduling a Rank Ranger demo to allow us to demonstrate how marketing dashboards with our rank plus third-party integrated data can be created inside our platform using templates. 

We understand that sometimes companies already have reports built in Data Studio that they've been sharing with clients and are only looking to add rank data to those existing reports, so we've worked with the friendly folks over at Supermetrics to provide you with an option for adding Rank Ranger rank data to your reports via our API.  With the Supermetrics JSON connector, you can connect our Campaign Stats and Rank Stats data as detailed in this document.

Requirements:
Rank Ranger customer support is able to assist you only with our data and APIs, if you need assistance with Supermetrics or Data Studio beyond the instructions in this documentation please contact the Google Data Studio Support or Supermetrics Support team.
             
Data Studio report with Rank Ranger data
 

How to Integrate Rank Data into Data Studio

 



Campaign Stats Metrics

           
 
Rank Ranger Campaign Stats API for Supermetrics provides:
  • Campaign ID
  • Campaign Name
  • Campaign Domain
  • Keyword ID (optional)
  • Search Engine ID
  • Search Engine Name
  • Search Engine URL
  • Search Engine Country
  • Local Business Name
  • Total number of Keywords
  • Total number of Search Engines
  • Search Engine ID (Avg) - for average rank metrics
  • Average Rank Today
  • Average Rank Week
  • Average Rank Month
  • Search Engine ID (Overview) - for minimum and maximum rank metrics
  • Minimum Rank
  • Maximum Rank
  • Search Engine ID (Change) - for rank change metrics
  • Rank Change Up (number of keywords)
  • Rank Change Down (number of keywords)
  • No Change (number of keywords)
  • Search Engine ID (Visibility) - for visibility metrics
  • Visibility Score
  • Visibility Date

Example Data Source URL - only change the 2 highlighted fields:
https://www.rankranger.com/api/v2/?get_campaign_stats&key=YourAPIKey&campaign_id=XXXXX&output=json&start_date=#sdate#&end_date=#edate#

Campaign IDs can be obtained by running the Get Campaigns in a Package API or Campaign Export utility.

Rank Stats Metrics

            
 
Rank Ranger Rank Stats API for Supermetrics provides:
  • Rank
  • Rank Date
  • Domain URL
  • Landing Page URL
  • Keyword
  • Tags
  • Average Search Volume
  • Search Engine URL
  • Search Engine Name
  • Search Volume

Example Data Source URL (only change the 3 highlighted fields):
https://www.rankranger.com/api/v2/?rank_stats&key=YourAPIKey&campaign_id=XXXXX&domain=domain.com&start_date=#sdate#&output=json&json_arr=1

Campaign IDs can be obtained by running the Get Campaigns in a Package API or Campaign Export utility.

Integrate with Supermetrics Connector

             
 
Add the Supermetrics Custom JSON/CSV/XML Connector to Data Studio
In the Data Studio Data Studio Data Sources screen:
1. Click the Create button and Data Source
2. Select the Supermetrics Custom JSON/CSV/XML Connector

select Supermetrics connector


3. Choose a Google account

Authorize Supermetrics connection

Data Source Parameters
4. Select JSON
5. Enter the Source URL from the Rank Ranger campaign that you want to integrate data for based on the data type:
  • Campaign Stats format
    https://www.rankranger.com/api/v2/?get_campaign_stats&key=YourKey&campaign_id=12345&output=json&start_date=#sdate#&end_date=#edate#

  • Rank Stats format
    https://www.rankranger.com/api/v2/?rank_stats&key=YourKey&campaign_id=12345&domain=example.com&start_date=#sdate#&output=json&json_arr=1
6. Check the option to Convert Numeric Strings to numbers
7. Check the option to Convert Date Strings to dates
8. Click the Connect button


enter data source parameters

Allow Parameter Sharing?
9. Click the Allow button

allow sharing

Successful Connection: Campaign Stats Metrics
10. Change the "Untitled Data Source" to "Campaign Stats" or another short phrase that will help you identify the data in the report building screen.
11. Click the Create Report button

Campaign Stats fields

Successful Connection: Rank Stats Metrics
10. Change the "Untitled Data Source" to "Rank Stats" or another short phrase that will help you identify the data in the report building screen.
11. Click the Create Report button

Rank Stats fields


Add to Report

12. A message displays explaining how Data Studio handles specific parameters. If you are in agreement, click the Add to Report button and you'll be able to begin building your report.

add data source to report


Rank Ranger Data in Data Studio Report example

            
 
Campaign Stats and Rank Stats in Data Studio

Example of Rank Ranger data in Data Studio report

Campaign Stats
If you have added a Campaign Stats data source to your Data Studio, when you add a chart or table element to your report, you'll have the option to select that Data Source and add the metrics displayed in the Available Fields section.

Campaign Stats in Data Studio

Rank Stats
If you have added a Rank Stats data source to your Data Studio, when you add a chart or table element to your report, you'll have the option to select that Data Source and add the metrics displayed in the Available Fields section.

Rank Stats in data studio

Table Styles
A few customers have pointed out some display behavior in Data Studio that they wished to change and so we're sharing this information: 
  • The table default includes row numbers, if you don't want them displayed then select the element, click STYLE and scroll down to Table Body and uncheck the option
  • When rank is not found in the top 100 results by our rank tracker, by default they display the word "NULL". If you want to change that, then select the element, click STYLE and scroll down to Missing Data and select the option you prefer. Presently, options include "No Data", "0", "-", "null" or leave blank.

chart and table style settings

Rank Ranger customer support is able to assist you only with our data and APIs, if you need assistance with Supermetrics or Data Studio beyond the instructions in this documentation please the Google Data Studio Support or Supermetrics Support team.

How to Generate New API Keys


You can obtain API Keys per user if your Rank Ranger account has API access by navigating to
1. Account  
2. Connections > API & Connected Apps
3. Click the Generate Key button
4. Select a User and add a note (optional)
5. Click the Add button

Generate API Key

How to Obtain API Access


If you see an error message when accessing the Account > Connections > API & Connected Apps screen, then to obtain API access you will need to upgrade to a package that includes API access by completing a custom package request form or contacting Rank Ranger support with your requirements.

Get the ultimate SEO tools with the Rank Ranger Software
Learn More About Rank Ranger