Google is launching a new series of blog posts dedicated to helping people do more with Data Studio when it comes to analyzing Search Console reports.
Throughout the series, Google will help users learn how to connect, visualize, and analyze Search Console data using Google Data Studio.
In the first article, published today, Google search advocate Daniel Waisberg explains how to connect and enhance data with geographic regions.
Here are some highlights from the first article in Google’s new series.
Why connect Google Search Console to Google Data Studio?
If Data Studio isn’t connected to Search Console, Google starts out by pointing out what you can get out of it.
“Google Search Console gives you insight into how your website is performing 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 can help to make better, data-backed decisions.”
In other words, Data Studio can visualize Search Console data in a way that can help you better understand what it means in the larger context of your website.
Connecting the two services together does not give you access to more data. It allows you to analyze existing data in a more intuitive interface.
How to connect Google Search Console to Google Data Studio
There are two ways to connect Search Console and Data Studio:
- Data connector: Go to the connectors gallery in Data Studio, select Search Console, then find the property you want to connect.
- Data export: Export data from Search Console via the web interface and import it into Data Studio.
Manually exporting and importing your Search Console data provides the most flexibility when it comes to enhancing it in Data Studio.
Google’s blog post focuses strictly on the manual option as it requires the most steps to explain.
Step One: Export Search Console Data
You can export your data to Search Console from the Performance Report screen. Simply choose a date range and click the big Export button.
Step Two: Improve Search Console Data
As an optional step, you can enhance the exported spreadsheet before importing it into Data Studio.
Google’s blog post explains how to use a Google Sheets function to group countries into regions, which is one of many examples of possible improvements.
Step Three: Connect Google Sheets to Data Studio
Import data by connecting Google Sheets to Data Studio. Visit the connector gallery and choose Google Sheets, then select your Search Console spreadsheet.
Data Studio will then begin visualizing the data.
To be continued in the new Google series
The next articles in this new blog series from Google will teach you how to create different types of dashboards with step-by-step instructions.
Source: Google Search Powerhouse Blog
Featured Image: PixieMe/Shutterstock