Documentation > Campaigns > Third Party Integration

Supermetrics Rank Ranger Connector for Data Studio

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 reporting platform package with API Key, Campaign ID and tracked domain
Supermetrics account with Data Studio Custom JSON/CSV/XML Connector
Google account

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

3. Choose a Google account

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

Allow Parameter Sharing?
9. Click the Allow button

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

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

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.

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.

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.

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.

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 Obtain API Access

If you'd like to help determining which of our API plans is most appropriate for your needs, contact our service team and an account manager will be happy to assist you.

If you already have a Rank Ranger plan and see an error message when accessing the Account Settings > 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.

If your company has API services included in a plan and you aren't able to access the screen, contact your company's Rank Ranger account administrator to request that your user permissions be set to include access to the Account Settings > API & Connected Apps screen.

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. Campaigns
2. API Resources
3. API Key Generator
4. Click the Generate Key button
5. Select a User and add a note (optional)
6. Click the Add button

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

Featured SEO Tools

SEO Dashboard Rank Tracker Social Analytics Link Manager White Label SEO

Marketing Dashboard Keyword Finder Insight Graph API

Resources

Top 100 Websites Rank Risk Index Google Algorithm Updates Google SERP Features Tool Mobile SERP Features Tool Visual Guide to SERP Features SEO Glossary

Rank Ranger

Pricing Contact us Blog Help Center Documentation Brand Ambassadors

Search our Knowledge Base
	Search