Tuesday, March 08, 2022
Google Search Console gives you insight into your website performance in Google Search, but understanding your data can be a challenge. If you set up a custom dashboard with data visualizations that work for you, it might help you make better decisions that are supported by data. This post is the first in a series of posts that will focus on exporting, enhancing, and visualizing Search Console data using Google Data Studio.
In today’s post, we’ll discuss how to bring your Search Console data into Google Data Studio. We’ll show an example where we download Search Console data into Google Sheets, enhance the data with geographical regions, and connect the spreadsheet to Data Studio.
In future posts, we’ll discuss how to create data visualizations to help you monitor and analyze your data.
In order to import Search Console data into Data Studio, there are two roads you can take:
In this post we’ll discuss the second option, since it requires more steps and offers more customization opportunities. There are three main steps you need to take:
In order to export your data, visit the Search Console Performance report, choose a date range, click Export, and choose Google Sheets. This will create a new spreadsheet, which we’ll enhance in the next step. You can also use the Search Analytics API for a more automated solution, but that’s out of scope for this post.
You can read more about the dimensions and metrics that will be available to you in the Performance report help documentation.
To show how to enhance your Search Console data, we’ll use a neat Google Sheets function, IMPORTDATA, which can import data from a URL. In our example, we’re importing the ISO 3166 countries by region table.
Add a new sheet to the data you exported from Search Console and enter the following code to the first cell:
In the Search Console sheet, create a column for Region and use the
VLOOKUP function to match the regions to the countries.
Here is a sample sheet showing how the final table would look.
Embedded: Table showing Search Console data enhanced with country regions
Even though we’re using an example to enhance the geographical data, you can use the same process to add any type of information. For example, if you have a query classification, you could use that to group queries into categories.
Finally, connect your Google Sheets to Data Studio. To do this, visit the connector gallery, choose Google Sheets, and find your newly created spreadsheet; but make sure to choose the right sheet.
Once the data is in Data Studio, the visualization work begins…
In the next post in this series, Monitoring Search traffic (and more!) with Data Studio, we’ll discuss different types of dashboards and provide step-by-step examples for you to follow along.
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 – stay tuned!