Your browser is out of date. The site might not be displayed correctly. Please update your browser.

Knowledge Base
Getting Started
Connecting Google Accounts to SEMrush
Integrating SEMrush Data with Google Data Studio

Integrating SEMrush Data with Google Data Studio Manual

Google Data Studio is a free online tool that lets you to customize visual reports using data from various sources. With a Business level SEMrush subscription, you can implement SEMrush data as a Data Source along with the other 150 sources of data available in GDS. This article will help you get started.

How it works

There are 2 separate connection points from SEMrush; One for pulling data from Domain Analytics, the second for Position Tracking. Domain Analytics lets you research search statistics on any domain in the SEMrush database, and Position Tracking lets you track a custom set of target keywords.

  • SEMrush Domain Analytics connector – to pull Domain Overview data including SEMrush Rank, top organic and paid keywords (Google Ads), and estimates of organic and paid traffic and traffic cost. Data is available for the most recent month only (historical data is not available).
  • SEMrush Position Tracking connector – to pull Visibility, Positions or an Organic Overview report from an existing Position Tracking campaign.

For additional help understanding connecting data sources to GDS, read this article from the Google Data Studio help center.

Corresponding API requests

The data that you can pull into GDS comes from the SEMrush API. Each connection point comes from a unique API request ( you can find details on all of these on the API documentation page):

  • Domain Overview = domain_rank
  • Organic Search Positions = domain_organic
  • Paid Search Positions = domain_adwords
  • Organic overview = tracking_position_organic
  • Organic visibility = tracking_position_adwords
  • Organic positions = tracking_visibility_organic
  • Google Ads visibility = tracking_visibility_adwords
  • Google Ads positions = tracking_overview_organic

The only difference here is that you cannot apply filters and sorting to your data source in GDS like you can using the SEMrush API.

Configuration

To configure the connection to SEMrush, you need to authorize both your Google account and SEMrush account to access data and add it to GDS.

Select “Authorize” and “Allow” in the subsequent windows to make the connection.

authorize

Parameters - Domain Analytics

Once you’ve authorized both of these sources, you can proceed to choosing the parameters of your report. For the Domain Analytics connection, the parameters are as follows:

semrush-data-studio-parametersReport type:

  • Domain Overview - this will pull an overview of the Domain’s search positions in the selected database.
  • Organic Search Positions - this will pull information from an Organic Positions report about the domain’s top 100 keyword positions in organic search results.  
  • Paid Search Positions - this will pull information from an Advertising Positions report about a domain’s top 100 keywords related to their use of PPC ads on Google Ads.

Database:
The regional database where SEMrush will look for the domain’s keyword positions.

Domain:
The domain to analyze.

After completing these fields, select “Connect” and you will arrive at the next step where you can customize the arrangement of your columns.

connect-data-studioSelect “Create Report” and you will be redirected to the Data Studio report builder where you can manually create the report that you want. Your configured connection with SEMrush will be available to add to your report as a Data Source.

Below is an example of what you could make with this connection. For help building your report, be sure to check out Google Data Studio's Help Center.
domain-overview-sample

Parameters - Position Tracking

Here are the Parameters you’ll see for a Position Tracking connection:

position-trackingReport type:

  • Organic positions - the domain’s positions in the organic search results of the target keywords
  • Google Ads positions - the domain’s positions in the paid Google Ads search results of the target keywords
  • Organic visibility - the domain’s visibility % among the organic search results of the target keywords
  • Google Ads visibility - the domain’s visibility % among the paid Google Ads search results of the target keywords
  • Organic overview - an overview of the domain’s rankings in the Google top 100, new and lost keywords, search terms with improved or decreased rankings, and changes in its ranking over a selected period

Project ID:
This is the unique code associated with your Project. You can find it in the address bar when you are viewing your Project on SEMrush as the numeric code following the /projects/ folder. In the example below, the ID is 564987.
Integrating SEMrush Data with Google Data Studio image 6Domain:

Enter the name of the domain, subdomain, subfolder or URL you want to pull data for. This can be your main domain or a competitor’s.

Domain Type:
Choose root domain, subdomain, subfolder, or exact URL.

Filter by keyword:
Enter a keyword to filter the keyword list in your report.

Filter by tags:
Enter a tag to filter the keyword list in your report. Multiple tags are allowed (separated by commas).

Display limit:
The number of results to show in your report. The maximum is 1500 results.

After completing these fields, you will be able to choose your data source’s columns and add this data source to your new report.

Example Reports

We’ve created two example reports that are publicly available. Please feel free to check out our Position Tracking example report and Domain Analytics example report to see our data sources in action.

Limits

These SEMrush Google Data Studio connectors are available only to users with a Business subscription. At this time, historical data is not available with this connection.

Manual
Show more