Google Analytics

Annelieke's Analytics:
How to create a Google Search Console dashboard

Annelieke’s Analytics: How to create a Google Search Console dashboard

Dashboards. There are a lot of people out there that absolutely love dashboards. And I agree, creating a good dashboard can save you a lot of time as an analyst. It’s very useful for monitoring data and reporting back to your colleagues. And dashboards can make clear when something’s off the charts, the moment for you to show the rest of your company what kind of analyst you are. In this post, I want to show you how you can create a Google Search Console dashboard in just a couple of steps using Google Data Studio.

Optimize your site for search & social media and keep it optimized with Yoast SEO Premium »

Yoast SEO: the #1 WordPress SEO plugin Info

What’s Google Data Studio?

Google Data Studio is part of Google’s marketing platform. It’s a free tool you can use to create dashboards and reports. It helps you with visualizing your data and lets you share it with whomever you want to share it with. For instance, you can connect Google Data Studio easily with Google Analytics, or Google Sheets. You can import a lot of types of data and play with it in Google Data Studio. This tool can make your data come to life. Not just for you but also for the people you want to share your data with. It’s highly customizable and has a lot of cool features. So if you haven’t looked at it yet, you’re missing out.

Create a Google Search Console dashboard

Connect Google Search Console and Google Data Studio

Google Data Studio is part of the Google suite and because of that, connecting with other Google tools is very easy. This means that connecting Google Search Console and Google Data Studio is very, very simple. There are a couple of things you need though, a Google Search Console account with your site verified and a Google Data Studio account obviously.

There are a couple of ways to connect Google Search Console with Google Data Studio. The screenshot below shows you the homepage of Google Data Studio.

Default Google Data Studio page

I’ve highlighted a couple of features that you can use to add Google Search Console to the data studio tool. Since you want to import data from Google Search Console, you can do so by clicking on ‘Data Sources’ or ‘Connect to Data’. But Data Studio will also ask for a data source when you want to create a new report, or dashboard if you will. You can do so by clicking on the ‘plus’ sign at the top or at the bottom.

I’m going to show you how to connect Google Search Console with Google Data Studio through the ‘Connect to Data’ option. If you click on that, you get the following screen:

Data Studio Connect to Data

Here you can see all types of data you can connect with for free, there are paid options as well, allowing you to connect Data Studio with Facebook Insights for instance. But in this post, I’m going to focus on just Google Search Console. If you click on that item, it’ll connect with Google Search Console and you can select the website you want to create a dashboard for.

connect Google Search Console with Google Data Studio

You then need to choose between Site Impression and Url Impression. You can actually add both to one report, but this means adding two Google Search Console data sources. One for Site Impression and one for Url Impression. Select one and click on the blue Connect button at the top. You’ll then see an overview of all Google Search Console variables it’s making a connection with:

overview of Google Search Console variables

You can then click on ‘Create report’ or ‘Explore’. If you click on the ‘Create report’ you’ll be asked to add the data to the report. Click on the blue button and voila, you’re good to go!

Use a Google Search Console template

I can understand that the first time you create a dashboard with this tool, it can be a bit hard to understand. Because just like Google Analytics, there are so many options here. Read posts or watch video tutorials about Google Data Studio, that really helps.

You can also choose an existing template Google Data Studio is offering. I really like these because you can see how they did it, and then repeat it yourself. Or adjust the existing template to your likings of course.

use Google Search Console template in Google Data Studio

At the top of the Google Data Studio homepage is a template section, including a Google Search Console template. If you click on that, you see an example of the report. And you can use this template and connect it to your own Google Search Console data.

Want to bump your SEO to a higher level? Become a technical SEO expert with our Technical SEO training! »

Technical SEO training Info

Use Search Console Report template

If you click on the ‘Use template’ button, you’ll be asked to select a new data source. In this case, you want to select your own Google Search Console data source, the Site impression as well as Url impression.

Connect your own site to the Search Console Report

Once you’ve added the correct Google Search Console data sources, click on ‘Create Report’ and you should see a Google Search Console dashboard with data about your site.

In this dashboard, you can find impressions, clicks, CTR, and position in a more understandable way than in Google Search Console itself. It also lets you compare date periods. And you can filter the data by country or device. You can see how your site’s SEO is doing in just one place. No need to click around in Google Search Console a lot. And you can share this dashboard with others, no need to add people to Google Search Console itself anymore!

Conclusion

Google Data Studio is a very neat data visualizing tool that lets you create dashboards and reports for Google Analytics, Google Search Console, Google sheets and so on. It’s very convenient to have this kind of information in one place. With all the options available, you can choose the best visualizations for your type of data. You don’t have to add accounts to Google Search Console anymore to let others see that data; you can create a dashboard in Google Data Studio and share it with them. No hassle, no fuss!

Read more: The beginner’s guide to Google Search Console »


Leave a reply

You have to agree to the comment policy.

10 Responses to Annelieke’s Analytics: How to create a Google Search Console dashboard

  1. Debbie
    Debbie  • 7 days ago

    Hi Annelieke, i completed all the steps but I get the message ‘Configuratie onvolledig. Ongeldige dimensie, statistic of filter’ in 4 of the graphs. It looks like there is no data to work with?

  2. lulljdto
    lulljdto  • 1 week ago

    it below. if i am not mistaken.. as it is unattainable by the way.

  3. lulljdto
    lulljdto  • 1 week ago

    i express gratitude for the help in this query. dismiss me from it.

  4. REINALDO OLIVEIRA
    REINALDO OLIVEIRA  • 1 week ago

    Very good, I’ll try to learn more.

  5. Halloween Ideas
    Halloween Ideas  • 1 week ago

    I’ve searched a lot for this information. Finally, I reached the right place. For the aspect of analysis, dashboard gives instant monitoring system and accommodate your data one place. So, it’s beneficial for the user. By the way thanks for sharing this article.

  6. Stephen Hamill
    Stephen Hamill  • 2 weeks ago

    A very nice article, can see the benefits for clients!

  7. Fabian
    Fabian  • 2 weeks ago

    Is there a possibility to export Google Data Studio reports as PDF?

  8. Kamal Edkent
    Kamal Edkent  • 2 weeks ago

    Tre it’s very convenient to have this kind of information in one place. With all the options available, you can choose the best visualizations for your type of data. Really like the blog and enhances my knowlege

    • Annelieke van den Berg

      Thank you Kamal!

      • John Givens
        John Givens  • 2 weeks ago

        Admittedly, I’m a lightweight when it comes to Google’s complex tools, but what I would like to have seen here is more examples of ‘why” and less of ‘how’ to ‘Create a Google Search Console Dashboard’.
        This (Date Studio + Search Console) undoubtedly is a great tool…but after walking through the steps to join Search Console with Data Studio, my first reaction was…”Why am I doing this? What data or trends or feedback can I get on this dashboard that I could not get without it?
        When showing these techniques, please show some examples of useful features and benefits which would justify using this technique, rather than just tools for tools sake.
        Thanks,
        john


Check out our must read articles about Analytics