Blog / Analytics & Reporting / How to Create an SEO Agency Dashboard in Looker Studio: A Step-by-Step Configuration Guide

How to Create an SEO Agency Dashboard in Looker Studio: A Step-by-Step Configuration Guide

Written by

Lazarina Stoy

Oct 25, 2024

10 min read

Key takeaways

Step 1. Duplicate the template in Looker Studio: Click on the three dots and select Make a copy of the template to start working on it.
Step 2. Connect data sources: Go to Resource > Manage Added Data Sources, and configure the data sources by editing essential ones. Connect your SE Ranking project by selecting it in the configuration and allowing Looker Studio to access search engines. Click “Reconnect” to refresh its connection with updated project data.
Step 3. Configure custom fields and dimensions: Custom Title Length (GA4) categorizes page titles based on length to prioritize SEO improvements. Branded vs. Non-Branded Queries (GSC) distinguishes branded from non-branded search queries for better analysis. Query-Based Labels (GSC) labels keywords by average position to highlight high-priority terms. Top-Level Directory Menu (GA4) organizes pages by top-level directories to aid performance analysis.
Step 4. Configure data blends: Manage and edit data blends by going to the Resource > Manage Blends menu.
Step 5. Enable or disable pages: You can hide pages that are irrelevant to your report or client. Go to Pages > Manage Pages, select the page, and choose Hide in view mode to make it invisible to stakeholders.
Step 6. Share your dashboard: Invite others via email, schedule email delivery with custom messages, share a report link, embed the dashboard on a webpage, or download the report as a PDF for client presentations.

This tutorial is for SEO consultants, SEO Agency Managers, and other professionals who could benefit from making a copy of (and using) SE Ranking’s SEO Agency Manager Looker Studio Dashboard.

As we’ve discussed in our data visualization dashboards blog post, a well-configured Looker Studio dashboard can become a powerful ally in your SEO and site performance analytics efforts. SE Ranking’s Looker Studio Dashboard offers a powerful suite of features and data sources, including the kind of robust SEO analytics and client reporting features that are essential for SEO Agency Managers. But to get the most out of Looker Studio, proper configuration is key.

This guide is designed to take you step-by-step as you create an SEO dashboard in Looker Studio. We’ll go over everything from the initial setup and copying to connecting data sources and custom fields, all the way to adding and disabling data views. The objective of fulfilling these processes is to tailor the reporting experience to your agency’s unique needs.

Before jumping into the setup, let’s do a recap on what the Looker Studio dashboard contains in terms of sections and pages, their associated functions, and data sources.

1. At a glance – Performance Overview

Page

Core Metrics and KPIs

Overview

Provides an overview of KPIs and relationship of site performance to algorithm updates

Data Sources on Page

GA4
Google Search Console
Google Sheets (algorithm updates sync)

2. Core SEO Performance

3. Backlinks and Referral Traffic

4. Ads

5. SEO opportunities

Section

Page

Overview

Data Sources on Page

1. At a glance – Performance Overview

Core Metrics and KPIs

Provides an overview of KPIs and relationship of site performance to algorithm updates

GA4
Google Search Console
Google Sheets (algorithm updates sync)

Competitor Landscape

Provides an overview of tracked competitors’ performance

SE Ranking

2. Core SEO Performance

Website performance & Traffic sources

Provides an overview of traffic per channel, and deep dive into site traffic parameters

Organic Search Performance

Overview of Google Search traffic performance, including breakdown of branded/non-branded

Google Search Console

Rankings (tracked)

Overview of performance for tracked keywords, including ranking dynamics

SE Ranking

Site user behavior

Overview of user engagement and audience metrics, including revenue-related metrics, suitable for ecommerce websites

Technical SEO

Overview of website audit issues and core web vitals performance

SE Ranking
ChromeUX report

3. Backlinks and Referral Traffic

Backlink Overview

Backlinks overview – key metrics (backlinks and referring domains over time), and supplementary metrics

SE Ranking

Referral Traffic Analytics

Overview of website KPIs of referral and social traffic, and associated traffic sources

4. Ads

Google Ads

Campaign clicks, cost, and CPA

Google Ads

5. SEO opportunities

Query-based

Query-based opportunities, including query opportunity grouping and improvement areas

Google Search Console

Page-based

Page improvement opportunities, and title length assessments

Step 1: Copy the Looker Studio Dashboard

To copy the agency dashboard, access the report via the link and click on the three dots in the top-right corner of the report. Select ‘Make a copy’.

While you can configure your data sources now, it’s much easier to do so at a later stage. Apply these data sources and click on ‘Copy report’.

Step 2: Configure your data sources

Once you have copied the Data Studio dashboard, navigate straight to the added data sources by clicking on the Resource > Manage added data sources menu, located at the top.

This will open a list of data sources that have been added to the report, as seen in the screenshot below.

Reconnect data sources to your data

Go through this list individually and for each data source:

Click on the Edit button

Click on Edit connection

Select your desired data source from the list, change the name of the data source, and then click on Reconnect. In the next screen, click on Finished

Repeat this process for all data sources on the list

Additional notes on data configurations:

If you’re having trouble accessing the Google Algorithm Updates sheet, please make a copy of this sheet. It’s connected to Google’s public dashboard and updates automatically per HTML formula import.
Don’t change any of the configurations to the SE Ranking connectors. Simply select your project from the drop-down list and reconnect.
Don’t delete data sources. This will break the chart configurations. Instead, reconnect them to your desired GA4, GSC, or Google Ads data source or SE Ranking project.

Troubleshooting connector configurations in case of extended data configuration issues:

Keep in mind that you won’t be able to see the GSC data in the SEO Agency dashboard because you need to connect your own accounts first. If you don’t do this, you’ll see the ‘No Data Set Access’ error.

If you encounter any extended configuration issues, you can reconnect data sources, such as GA4, Google Ads, or Google Search Console. Just create a new data source, reconnect it to the charts, and then delete the demo. Here’s a quick demo of what this process would look like.

To do this:

Connect your data source via the Add data menu.

Use Add data menu to connect your data source

Connect to your selected data source (e.g. GA4 or Google Ads), and click on Add.

Identify pages containing data from this source by using the chart data source notes.

Right-click on a chart with the data source you’re trying to replace. Click on Select charts with this data source on page.

Select charts with this data source on page

Navigate to the right-side panel and click on the edit button next to the existing data source. Then, search for or select the desired data source from the drop-down menu.

Repeat this process with all pages containing your data source.
Once completed, navigate to the Resource > Manage Added Data Sources menu, and delete the old data source. It should now show up as being used in 0 charts.

Old data source must be used in 0 charts

Configure filters to the appropriate data sources

Filters have now been applied that are connected to the GA4 data source. If you encounter any errors, please troubleshoot the filters applied. You can navigate to the filters menu by clicking on Resource > Manage filters.

After reconnecting the agency dashboard to all of your data sources, click the Edit button for each filter to check that there is a data source associated with it. The first two should connect to SE Ranking’s connector, while the latter two should connect to your GA4 data source.

The former two filters have been applied to page 5: Rankings (tracked) under Core SEO Performance. The latter two have been applied to page 9: Referral Traffic Analytics, under Backlinks and Referral Traffic.

Step 3: Configure the custom fields and dimensions

There are a few custom fields and dimensions that have been added to the report. After you’ve done steps 1 and 2 in this section, we’ll go over each formula and its accompanying data source so you can add them to your report.

Here’s a recap on how to create custom dimensions in Looker Studio.

Create a custom title length SEO assessment dimension in GA4

Тhe point of this assessment is to provide you with a label that can be used to quickly categorize titles according to their length. You can export these from the visualizations within the SEO opportunities section of the report. You can also prioritize on-page improvements for these pages.

Here’s the formula for creating this dimension in the GA4 Data source.

CASE
  WHEN length(Page title) >= 50 AND  length(Page title) <= 60 THEN "Title - Perfect"
  WHEN  length(Page title) >= 40
AND  length(Page title)<= 50 THEN "Title - good"
  WHEN  length(Page title) < 40 THEN "Title - too short"
  WHEN  length(Page title)> 60 THEN "Title too long"
END

Create a custom title length SEO assessment dimension in GA4

Once everything is entered, go to page 12: Page-based, under the SEO Opportunities Section of the report. Make sure the next two charts use the custom dimension you created.

Check title length SEO assessment dimension in SEO opportunities section

Create a custom dimension to differentiate branded queries from non-branded ones within the GSC data source

This goal of this formula is to provide more granularity to your Google Search Console report. It does this by showing you a breakdown of your branded and non-branded queries. The same formula can be applied to the SE Ranking Report’s Keyword field.

Navigate to your Google Search Console connector and create a custom dimension using the following formula.

case
when REGEXP_CONTAINS(Query, 'brandname|brand^|brand name') then "Branded"
when REGEXP_CONTAINS(Query, '(not provided)|(not set)|(unavailable)') then "Not specified"
else "Non-Branded"
end

Differentiate branded queries from non-branded

Once you’ve done that, navigate to Page 4: Organic Search performance, located under the Core SEO Performance section of the Looker Studio dashboard. Make sure that this chart is using the custom dimension you just created, and displays counts of queries and URL clicks.

Check that chart is using the custom dimension you created

Additionally, check Page 1: Core Metrics and KPIs, located under the At a Glance Performance overview.

Check custom dimension under the At a Glance Performance overview

Create a custom text metric to label queries based on their average position in the GSC data source

Add another custom metric to the GSC data source. This metric will be a text-based metric. It will use the Average position field to determine labels for queries. Here’s the formula for this metric.

CASE
  WHEN Average Position >= 1 AND Average Position < 3 THEN "Money Keywords - Protect"
  WHEN Average Position >= 3 AND Average Position < 10 THEN "High value Keywords - Prioritize improvements"
  WHEN Average Position >= 10 AND Average Position < 20 THEN "Striking Distance Keywords - Improve"
END

Once you have created this field, navigate to Page 11: Query-based (under SEO opportunities) of the report. Make sure the metric has been added correctly to the following chart.

Create a custom top-level directory menu in GA4

Using the GA4 data source, create a custom field for a top-level directory. Note that this provides the most value for hierarchical websites that use the top-level directory to indicate sections. Otherwise, you can use a custom page section formula that corresponds with the structure of your website.

Here’s the formula:

CASE
  WHEN Landing page = '/' THEN "homepage"
  ELSE REGEXP_EXTRACT(Landing page, '/([^/]+)/' )
END

This formula is only used in Page 1: Core Metrics and KPIs, under the At a Glance Performance overview section in the following chart.

Step 4: Configure data blends

The reporting dashboard only uses two data blends, each of which has a similar function and set-up. Both metrics are used in the charts located at the bottom of Page 1: Core Metrics and KPIs, within the At a Glance Performance overview section of the dashboard.

You can edit these data sources by clicking on the Resource menu and then selecting Manage Blends.

Click to edit each of these individually and then reconnect your respective data source to the data blend. This may have already occurred automatically, in which case you don’t need to do anything. Please consult the configurations below in case you encounter any errors with these charts.

Step 5 (Optional): Enable or disable pages based on your preferences

You might want to disable certain pages that apply neither to your reporting nor your client’s operations.

To disable a section or page that you do not want your stakeholders or reporting collaborators to view, navigate to the report pages menu (from Pages > Manage Pages). Hover over the section or page that you want to disable and click on the three dots to open the page/section menu. Select Hide in view mode.

Step 6: Invite others to access your reporting dashboard

Once you have completed all of the steps above, invite others to access the report. Click on the share menu, and select one of the options listed below:

Invite others via their email
Schedule delivery of the Looker Studio dashboard via email. Create a custom message at a specified time and delivery frequency
Get report link to share
Embed report. Do this if you’re planning on embedding the Looker Studio dashboard through a webpage or via another interactive method
Download report if you want to present a PDF to your client by email or another presentation style.

Wrapping up

Now that you know how to create an SEO dashboard, don’t forget to check out SE Ranking’s diverse selection of Looker Studio dashboards. Here are some of the dashboards for your agency that you can find on our list:

Agency Tips SEO Analytics

689 views

Written by

Lazarina Stoy

Lazarina Stoy is an organic search consultant specializing in SEO and data science. She's worked with countless B2B, SaaS, and big tech teams to improve their organic positioning. Lazarina is an international speaker and resource creator, helping fellow SEOs discover how to use data science and machine learning in their day-to-day.