Google Search Console gives you insight into your website performance in Google Search,

But it can be a challenge to understand all your data. 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 talk about how you can 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 upcoming posts, I will tell you how to create data visualizations to help you monitor and analyze your data.

Prepare all of the data, and connect to the data studio.

When you want to import the data from the search console into Data Studio, there are two paths you can take:

  • If you want to view the same data that you see in Search Console, then you should use the Google Data Studio data connector. This option is straightforward:
    visit the connector gallery, choose Search Console, and find the property you’d like to connect.
    You can find a guide to the connector in the Data Studio Help Center.
  • If you’d like to enhance the data provided by Search Console (for example, clustering countries into regions), you should first export the data from the web
    interface or through the API. This makes it possible for you to manipulate the data with google sheets or bigquery, and you can connect that data to data studio.

In this post, I’ll discuss the second option, since it requires more steps, but also has more customization opportunities. There are three important steps that you need to take.

  1. Export the search console data.
  2. Add your own data to the top of it.
  3. Import the file into Data Studio.

Export the search console data.

In order to export your data, visit the Search Console Performance report,
choose a date range, click Export, and choose Google Sheets. You should create a new spreadsheet. We will improve it 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.

Search Console Performance report export options

You can read more about the dimensions and metrics that will be available to you in the Performance
report help documentation
.

Enhance the search console data.

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 to the data sheet all of the data that you exported from the search console. Enter the following code into the first cell:

IMPORTANTDATA(https://github.com/richjenks/15b75f1960bc3321e295/raw/62749882ed0e9dffa3edd7a9a4a7be59df

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.


Itemized table of the search console data enhanced with country regions.

Even if you use this example to enhance the geographical data, you can also use this process to add any other type of data. For example, if you have a query classification,
you could use that to group queries into categories.

You should connect Google Sheets to Data Studio.

Finally, connect all of 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 the data studio, the work of visualization starts.