Advertisement
  1. SEJ
  2.  ⋅ 
  3. Marketing Analytics

How to Take Search Console to the Next Level with Google Data Studio

Discover tips on how to make the most out of your Google Search Console data by using it in combination with Google Data Studio.

How to Take Search Console to the Next Level with Google Data Studio

It’s been really positive to see how quickly Google Search Console has been changing since the launch of the new version.

However, with all of these developments, it’s important not to put too much focus on working with Search Console data in its native user interface.

To get the most out of Search Console, particularly Performance data, we need to:

  • Extract parts of this rich data source.
  • Visualize it in compelling dashboards that surface organic insights quickly so that we can tell persuasive stories to clients, management and other stakeholders.

I’m going to show you how to get more out of Search Console data by using it in combination with Google Data Studio.

By building custom Search Console dashboards you will be able to:

  • Save a shed load of time by surfacing organic issues, fluctuations, and insights faster.
  • Ditch your boring reports and share compelling visualizations that influence and persuade.

The Setup

Unless you’ve been hiding under a rock, you’ll have at least some awareness of Google Data Studio and what it’s about.

If you want to learn more about using Google Data Studio, there are some great guides out there so I won’t be delving into that here.

I do, however, want to start by taking you through a couple of options available for pulling Search Console data into Data Studio.

Native Connector

The most obvious way to get Search Console data in Data Studio is by using the native connector to create a data source.

Data Studio Search Console connector

Using this connector is a quick and easy option for getting Search Console Performance insights into Data Studio.

The problem is that it is limited to Performance data alone and has a limited number of dimensions with which to dissect this data source.

Third-Party Tools

A better option is to access Search Console through a third party tool like Supermetrics.

Doing so will give you access to:

  • Sitemap metrics and Performance data.
  • A wide range of dimensions to help you slice and dice the data as required.

There are a number of different options and products available but I use Supermetrics for Google Sheets by:

  • Running Search Console queries in Google Sheets using the Supermetrics add-on.
  • Populating sheets with tables of Search Console data.

Supermetrics for Sheets

  • Setting scheduled data refreshing using the Supermetrics add-on to keep sheets populated with up to date data.

Supermetrics schedule refresh

  • Creating data sources in Data Studio using the Sheets connector.

Data Studio Google Sheets connector

  • Visualizing the data in a variety of Data Studio dashboards.

Data Studio visualisations

What Search Console Dashboards Can You Build in Data Studio?

With the flow of Search Console data into Data Studio in place, you can get down to the fun stuff: building pretty charts and graphs.

I use two main dashboards that serve different purposes and communicate different aspects of Search Console data.

I’ll spend the rest of the post taking you through them to give you inspiration for some visualizations that you can go off and create.

1. Top Level Trends Dashboard

The top-level organic trends dashboard provides a high-level overview of organic performance.

In addition to aiding SEOs and digital marketers, this could equally be shared with management, clients and other stakeholders who have a limited understanding of organic search but have an interest in its performance as a channel.

Let’s take a look at what this dashboard consists of.

Sitewide Trends

Data Studio GSC Top level trends dashboard

The dashboard kicks off with a sitewide year-on-year comparison scorecard to show how the overall site is performing in terms of impressions, clicks, and CTR compared to the previous year.

Below that, sitewide impressions, clicks, and CTR are trended on a monthly basis to clearly show the overall direction of organic performance.

In the case of the DeepCrawl site, we’ve seen strong and consistent growth in terms of the volume of impressions and clicks. Conversely, CTR has declined over this period, which warrants further investigation.

The key benefit of these graphs is that they remove the noise of the daily trending that you are locked into within Search Console itself, and you can instead visualize this information as clearly as possible.

Branded & Non-Branded Trends

Branded search performance Search Console

I’ve also included two sections using a similar format to the above to break out performance for branded and non-branded queries.

Splitting Performance data out in this way is possible as a dimension within Supermetrics, but if you are using the Data Studio connector you can create a filter where the query does/doesn’t include your brand name and its different variations.

Splitting out branded and non-branded performance is important because these could be telling different stories.

Non-branded search performance is more indicative of the effectiveness of SEO work, whereas branded search can speak more to the overall marketing efforts of a site and their success in growing brand visibility.

Directory Breakdown

Another way of breaking out Performance data in a top-level way is by splitting out clicks and impressions by site sections and trending this on a monthly basis.

This data can easily be pulled using the directory level dimensions provided by default in Supermetrics.

When it’s set up it will show you how various sections on a site are contributing to the overall organic performance and how this has changed over time.

In the graph above you can see where we migrated over a section of our site where the green section turns to yellow.

You can see that the migration was a success because the new site section (in yellow) grew substantially compared to the performance of the old section (green) in the subsequent months (November 2018 onwards).

Long Tail vs. Short Tail Performance

Keyword performance by query length

Using a similar style of graph to the directory breakdown, you can use query length as a dimension to gain an understanding of long and short tail performance.

This could be taken one step further, by bucketing together different query lengths to group short, mid and long tail queries.

Additionally, I’ve used the device and geographic dimensions to trend desktop vs. mobile performance and country-level performance in similar ways to the above.

2. Monthly Insights Dashboard

The second dashboard takes a more granular view, looking at Search Console Performance data on a monthly basis.

The Monthly Insights dashboard is useful for more regular check-ins to promptly detect changes and review performance.

Monthly Trends

Monthly organic trends

This dashboard features two comparison scorecards with month-on-month and year-on-year comparisons of impressions, clicks, and CTR.

Below the scorecards are three graphs showcasing performance data on a daily basis to identify more immediate fluctuations.

Device, Geographic & Search Type Trends

GSC search type, device and geo graphs

Below the sitewide metrics sit a series of graphs configured to detect changes in various types of organic traffic.

Impressions, clicks, and CTR are shown horizontally and device, country and search type breakdowns are shown vertically.

This is useful for flagging the source of fluctuations in organic traffic and forming the basis for further investigation.

Page & Query Performance

GSC top performing pages and queries

Following on from the device, geographic and search type trends are the top performing pages and queries for the last month, with a comparison to the previous month.

Of course, this is information that can be gained from the Search Console UI, but the benefit is that it saves you time as you don’t have to configure filters such as date ranges each time. The insights are there ready for you immediately.

Biggest Winners & Losers

GSC biggest increases and decreases in clicks and impressions

I’ve built some more pre-populated tables which show the biggest changes comparing last month to the previous month.

The biggest winners are queries that have seen the biggest increase in clicks, impressions, CTR and average position and the biggest losers are those that have seen the biggest decrease.

It is worth adding a filter to set a minimum number of impressions or clicks so that you’re displaying changes for queries that you care more about ranking for.

For example, who cares if you move up 50 positions for a query if your average position is 200?

These tables are something I would previously look for in Search Console itself, but it’s handy to have these pre-configured in a dashboard ready for me to review on a monthly basis.

Fraggle Performance

We’ve recently started optimizing our content to get fraggles in the SERPs.

While the name sounds like a rather unpleasant skin condition, fraggles are actually another name for the jump links in SERPs that deep link to specific sections of a page.

Jump links in Google search resultsGetting fraggles for your site’s pages is pretty straightforward and they are particularly useful for sites with a lot of long-form content because they help get searchers to the information they want faster.

Fraggle performance graphs

As fraggles are something we’re optimizing for, I decided to include this as part of the reporting in my Search Console dashboards.

I found that by filtering down URLs to those that contain a “#”, this surfaces the performance of fraggle impressions and clicks in search.

The above graphs and table show monthly tracking of fraggle performance in search and the tables below reveal which pages and queries we are receiving fraggles for.

Top performing pages and queries with fraggles

Do Yourself a Favor…

Since I’ve been sharing my work on Data Studio, I’ve spoken to many people who are interested in learning about how they can build dashboards to streamline reporting, but don’t seem to have the time.

We’re all busy, I get it.

But it only takes a handful of hours to set up dashboards like the ones above and the costs are minimal (or free, depending on your setup).

Once you have these dashboards and automated processes in place, the hard work is done and you can reap the benefits in terms of time saved in the long run.

I hope this post has been useful in demonstrating how you can set up simple but effective organic search dashboards.

Google Data Studio is evolving rapidly, so I’d love to see you share your own dashboards and how you’re getting the most out of Search Console and other data sources.

Some Helpful Resources

More Resources:


Image Credits

All screenshots taken by author, April 2019

ADVERTISEMENT
Sam Marsden SEO & Content Manager at DeepCrawl

With more than five years digital marketing experience, Sam Marsden has built a range of SEO and digital marketing skills ...