How to make a Search Console Dashboard in Google Data Studio

How to make a Search Console Dashboard in Google Data Studio

Search Console is a great tool from Google, and in this post I’ll show you how to build a Search Console Dashboard in Google Data Studio.

It has a great, very user-friendly interface. If you haven’t used it before, here’s what it looks like.

A screenshot of the Search Console performance report.

It’s very clean and user-friendly.

However, adding the information to Google Data Studio allows you to share, embed and email the report to colleagues or clients.

What Search Console shows

Search Console displays four main metrics.

These are;

  • Clicks – how many times a user clicked through to your site
  • Impressions – how many times a user saw a link to your site in the search results
  • Site CTR – the percentage of impressions that resulted in a click
  • Average Position – the average position among search results for your site

You can also add the Search Console data to dashboards alongside Google Analytics data.

In this blog post, I’ll show you how to create a simple Search Console dashboard in Google Data Studio.

Below is the dashboard itself.

Steps to creating a basic Search Console Dashboard

The first step is to choose your data source.

Adding Data sources in Data Studio.

Click Add a Data Source.

Then choose Search console.

You will need to authorize Search console to connect with Google Data Studio.

This can sometimes cause issues, and you may have to remove Google Data Studio’s permissions to get it to connect to Search console.

Adding Search Console as a Data Source

Hopefully everything will work out, and you can then choose between Site Impression and URL impression.

In this example we’ll use Site Impression.

We choose Site Impression and then have the following fields from our Data Source.

The fields in the Search Console Dashboard data source in Data Studio

We can then add it to the report.

Adding to the Data Studio report

Once we’ve added it the report, let’s choose the date range we want to work with. In this case let’s use Google’s new Advanced Date Range options.

Adjusting the date in Google Data Studio

If we look at Search Console, it can take around three days for the latest data to appear in it. The screenshot below is from Search Console on 9 March. You can see the most recent date is 6 March.

A graph from Search Console

So let’s use the new Advanced Dates feature to choose Today > Minus > 3 > Day as our End date, and Today > Minus > 10 > Day to give us our starting date.

Advanced date range in Data Studio

Creating Scorecards to match the Search Console display

Let’s create some scorecards to mimic those shown in Search Console.

Below is what is shown in Search Console.

Search Console Dashboard scorecards

And this is what we can create in Data Studio.

Search Console Dashboard scorecards in Data Studio

To do this we need to match the colours as close as we can. I used Image Colour Picker to do this.

Note that there are some differences, for example Average CTR vs Site CTR. They are the same thing but you can change how the metric is displayed in Data Studio if you want to.

Creating Line Charts to show Clicks, Impressions, Site CTR and Average Position

Let’s create a line chart to show Clicks and Impressions.

Line graph showing clicks and impressions

We can set it up as shown below, we our Time Dimension as Date and Clicks and Impressions as our Metrics.

Data tab for clicks and impressions in Data Studio

One important thing to do is to make sure Series no. 1 is on a Left Axis, while Series no. 2 is on a Right Axis.

We can also make things coherent by using custom colours to match our line charts to Search Console.

Adjusting colour in Data Studio

Next, we do the same thing for Site Click Through Rate (CTR) and Average Position.

We add Site CTR and Average Position as our metrics.

Next, we can build a table to look at each individual Query and its Clicks, Impressions, Site CTR and Average Position.

We can set up the data for the table as shown below.

Hope this was useful!

Michael

Author Michael

More posts by Michael

Join the discussion 4 Comments

  • Nicely explained, you should remove that iframe as it’s not working, which creates a long white space, leading to engagement breakdown.

    • Michael says:

      Hi Deepak, thanks – but perhaps you are using a Chrome extension that blocks out the iframe? That was happening to a friend of mine. The iframe shows the Data Studio report which is essential to include in the blog post!

  • Catalin says:

    Hi Michael! Do you know a way to import in Data Studio the Image Organic from Search Console? Thanks!

Leave a Reply