Wednesday, March 30, 2022
This article shows how to create a monitoring dashboard for your Search traffic on Data Studio. While Search Console provides out-of-the-box charts and filtering capabilities, Data Studio allows you to customize your own charts and view them side by side with other data, such as Google Ads, Analytics, YouTube, BigQuery, and others. If you missed our previous article in this series, check it out at Connecting Search Console to Data Studio.
Before we dive into dashboarding, we have some good news for Data Studio users: as of today, the Search Console connector includes data for Discover and Google News traffic, similar to the data recently added to the API.
In today’s post, we’re sharing a dashboard for you to use with your own data; it makes it easy to toggle between different Search Console properties, data types, devices, and more. You can link your own data to this template to monitor your site’s Google Search traffic.
Keep reading to learn more about the dashboard.
When you build a dashboard, you should always start by defining its purpose, and the majority of cases can be classified as one of three options:
Today we’ll discuss a monitoring performance dashboard, which should help you find out issues as they happen. Usually, this kind of dashboard uses simple visualizations such as line or bar charts, and tables — those are quick to interpret. Then, if an issue is discovered, the SEO or analyst can proceed to a deeper data exploration (this will be covered in the next post).
As mentioned, this post provides
to monitor Google Search performance. In this section, we discuss how to get your Search data into Data Studio, what functionality
and data the dashboard provides, and why we made some of the design decisions.
Sign in to Data Studio, create a
Search Console data source, and choose the
URL Impression table, which includes data for web, image, video, news, discover, and googleNews on a URL level basis.
The Property Parameter you choose here will be the default one in your report, but you’ll have access to the others
through a filter, more about it later in the post. To learn more about the data visit the
Performance report help pages.
The header of the report includes several options for you to filter the data in the charts:
A line chart is the most effective visualization to show how metrics change over time. In this case, we chose to look at both Clicks and Site CTR. In the line chart image, weekends and weekdays have very different patterns (one of the reasons it’s important to always use a multiple of 7 in your line charts date range) — keep your eyes on days that break that pattern!
Note that this image is for a website that is work oriented, hence the traffic is high on weekdays and low on weekends. It might look very different for your site.
We have not included Google Analytics data in this report, but it might be interesting to include a chart showing how many conversions the website got from organic Google Search. Learn how to connect Google Analytics to Data Studio; this would help closing the loop.
When you analyze trends and patterns, charts will be more helpful to you, but if you want to go deeper, it’s more effective to analyze particular URLs (or groups of them) using a table. For example:
Most dashboards don’t need to be mobile friendly as people use them on their computer. But a monitoring dashboard can be often used while commuting to work, so it might be important for it to be mobile-friendly.
In order to create a good mobile experience for a monitoring dashboard, set “Display mode” to “Fit to width” (found under report and page layout) — this will adjust the dashboard width to the screen size. If you choose this option, make sure to check how the report looks on different screen sizes.
If your report includes a single domain with no subdomains, you might consider removing the domain name from your report to make the tables less cluttered. For example, if you’re building a report for
example.com/cool-dashboards/search, you’d see only
/cool-dashboards/search. To do so, you can create a calculated field to remove the domain name from the URL using a regular expression. For example, for a
.com domain name you could use the following expression:
REGEXP_EXTRACT(Landing Page, ".*\\.com/(.*)$")
In the next post, Optimizing website performance with a Search Console bubble chart, we’ll discuss an advanced chart that may help you understand where to focus your attention when it comes to optimizing your Search efforts.
As always, let us know if you have any questions through the Google Search Central Community or the Data Studio Community. Also, if you’re on Twitter, make sure to follow us; we’ll announce future posts over there.