Looker Studio

The SE Ranking and Looker Studio integration is a powerful tool that connects your SE Ranking data directly to Looker Studio, Google’s free platform for reporting and data visualization. This connection allows you to build dynamic, interactive, and shareable dashboards from your SEO projects. Instead of manually exporting CSVs, you can create automated reports for all your reporting purposes, like tracking keyword performance, analyzing competitor traffic, and monitoring your domain’s health in real-time.

This guide provides step-by-step instructions for connecting SE Ranking as a data source in Looker Studio.

What is Looker Studio for SEO?

Looker Studio for SEO acts as a visual reporting layer on top of your raw data. By connecting SE Ranking, you give Looker Studio the “context” it needs to understand your SEO metrics. This allows you to:

• Visualize Trends: Turn spreadsheets of historical data into intuitive time-series charts to see your organic traffic growth, keyword position changes, and more.
• Combine Data Sources: Blend your SE Ranking data with other sources like Google Analytics, Google Search Console, and Google Ads to create a single, unified dashboard for all your marketing efforts.
• Create Custom Reports: Move beyond static reports and build dashboards tailored to your specific KPIs, whether it’s for internal analysis or client reporting.

1. Prerequisites

Before you begin, please ensure you have the following ready:

• SE Ranking Account: You will need an active SE Ranking account with API access. You can generate or find your API token in the SE Ranking API Dashboard.
• Google Account: Looker Studio is a free tool available to anyone with a Google account.

2. How to Connect SE Ranking to Looker Studio

Follow these steps to add a specific SE Ranking report as a new data source in your Looker Studio project.

You have two options:

1. Use the direct Connector Link: The quickest way is to click the [Link] in the tables below for the specific report you want. This will take you directly to the authorization step.
2. Use the Deployment ID: Follow the manual steps below if you prefer to add the connector via its Deployment ID.

Manual Steps:

1. Navigate to Looker Studio and click Create in the top left corner, then select Data Source.

2. In the connector gallery, search for and select Build your own (Partner Connectors).

3. You will be prompted for a Deployment ID. Copy the ID for the specific report you wish to connect from the tables in the next section and paste it into the field.

4. Click VALIDATE. Looker Studio will find the corresponding SE Ranking connector.

5. [Authorization] Click on the connector name to authorize and select it.

6. When prompted, provide your SE Ranking API token.

7. Click CONNECT in the top right corner.

Your SE Ranking report is now connected as a data source! Repeat this process for each unique report you wish to use in your dashboards.

3. Available SE Ranking Connectors & Deployment IDs

Here is a complete list of the available data connectors, their unique Deployment IDs, and direct Connector Links.

Keyword Research

Domain & Competitor Analysis

4. Usage Example: Building a Keyword Opportunity & Risk Dashboard

One of the most powerful ways to use this integration is to monitor how your keyword positions change over time. By tracking new, lost, and shifting keyword rankings, you can quickly spot opportunities and identify potential reasons for traffic loss. This example uses only the Domain Keywords connector.

1. Connect Source: First, connect the Domain Keywords data source using the steps outlined in section 2.
2. Add Scorecards for Position Changes: Add four scorecard components to your report. For each one, use “keyword” as the metric and apply a filter based on the pos_change dimension:
   • New Keywords: Filter pos_change to show only “new”.
   • Lost Keywords: Filter pos_change to show only “lost”.
   • Improved Keywords: Filter pos_change to show only “up”.
   • Declined Keywords: Filter pos_change to show only “down”. This gives you an at-a-glance summary of keyword volatility.
3. Create an “Opportunities” Table: Add a table to your report to highlight positive developments.
   • Data Source: Domain Keywords.
   • Dimensions: keyword, url.
   • Metrics: position, prev_pos, volume, difficulty.
   • Filter: Apply a filter where pos_change is either “new” or “up”.
   • Sort: Sort by volume descending to see your most valuable opportunities first.
4. Create a “Traffic at Risk” Table: Add a second table to monitor potential issues.
   • Data Source: Domain Keywords.
   • Dimensions: keyword, url.
   • Metrics: position, prev_pos, volume, traffic.
   • Filter: Apply a filter where pos_change is either “lost” or “down”.
   • Sort: Sort by traffic descending to prioritize the keywords that have the biggest impact on your traffic.

By combining these elements, you can build a custom seo looker studio dashboard that turns raw keyword data into actionable insights for your SEO strategy.

5. Video Guide

See the SE Ranking and Looker Studio integration in action! This video introduces the official connectors and demonstrates how you can turn your data into a powerful SEO reporting dashboard in minutes.

(Note: Video in progress)