Search Console is an excellent resource for any SEO, but it’s not without its limitations. Pulling the data you need can be time consuming with its cumbersome UI and lack of dashboard functionality. Thanks to Google Data Studio and the Search Console connector, it is now much easier for SEOs to draw valuable insight from their SEO data. In this post, I’ll look at the importance of data visualisation for SEO, and outline a few tips to help you improve your SEO reporting with Google Data Studio.
What is Google Data Studio and why is it relevant for SEO?
You’ve probably heard a lot of buzz about ‘data visualisation’ in digital marketing. Tools like Tableau and Klipfolio have been around a long time, but there's an element of exclusivity to data visualisation that makes the subject a bit impenetrable to some. However, Google Data Studio is a new (and free) contender to those platforms which aims to break down some of those barriers to entry and simplify data visualisation for marketers and analysts.
Why as an SEO should you care about it? Well, for several reasons it turns out. Not least because important stories live within marketing data, and visualisation has been shown to be a powerful method of communicating these stories. Also, thanks to Google Data Studio and the Search Console connector, it’s now incredibly easy to begin to tell the stories that exist in your Search Console data. I hope this post serves as a kind of starter to get you thinking about how you might use Google Data Studio and Search Console in your own reporting. And let's not forget the obvious plus regarding pricing: it's completely free.
See all of your Search Console data in a single dashboard
A big frustration I have with Search Console is in the design of the UI. By only allowing you to view a single dataset at any one time, you’re forced switch between reports or export data to Excel to build reports – it’s not exactly intuitive and can take up a lot of time just navigating your way around.
With the Search Console Connector, SEOs now can house all their ‘Search Analytics’ data in a single dashboard, whether at the site level or URL level. This means you can start to visualise things like click and impression Data over time in a much more fluid and easy to read way (without relying on the Search Console API), while being able to get very granular with it.
If you work as part of a larger marketing team, or are running other marketing channels alongside SEO, you can add multiple connectors (data sources) to the same report. This means instead of having to report on channel performance in silos, you can sit all of your key metrics in a single page. So if, for instance you're running SEO and PPC in unison, you could report click, impressions and CTR data alongside AdWords click, impression and CTR data to enable you to do quick comparisons of performance.
Visualise page and site performance over time
Thanks to the ability to create custom table Filters to any data set, Google Data Studio is increidbly easy to customise and enable you to conduct fine grain analysis of specific sections of your site over time.
Let’s say your site publishes a lot of AMP content and you want to understand how those pages perform over a given time period, but want to discount all non-AMP pages. Instead of having to set up filters within Search Console, and set your AMP criteria every time, you could add a table Filter to show only pages that match your AMP-criteria. Below is a kind of crude example, but one that works for this blog.
Easily compare CTR differences by country or device type
There’s a really helpful Search Console sample report already configured in Data Studio that lets you filter your data by country, and device. It sounds so simple, but this filter functionality alone means you can potentially save a tonne of time doing any comparative analysis across different territories or devices (or any combination of the two). Once you start playing around with filtering options across a page of pre-made reports, you’ll see for yourself how useful this can be.
I’m trying to integrate Google Data Studio into my own reporting as much as possible and have already found it to be beneficial in helping others understand what could be considered otherwise complex or hard to explain insights.
There’s so many interesting ways you can slice and dice search console data within Google Data Studio, and it feels like I’m only just scratching the surface myself. I suggest you set up own account and get started. You can read more about getting started with Google Data Studio here.