Google Data Studio Template: Search Console Countries and Queries

Google Data Studio Template Search Console Countries and Queries

So in this post I just wanted to share a Google Data Studio report template that lets you look at the connections between countries and search queries.

Purchase this Google Data Studio Template

This report template is available to purchase and download on the Data Studio Templates website.

Google-search-console-queries-by-country

Below is the report.

What can I do with this Search Console report?

So this report is set up to let you examine the top search queries by country. As well as seeing the top countries for various search queries.

So for example, below I’ve selected Canada using the table on the left. The table on the right now only shows queries relevant to Canada.

filtering by country in a google search console report

Using the report to see what countries rank highly for different keywords, I’ve selected the search term ‘Google Data Studio’ on the table on the right and now I get a list of impressions, clicks and CTR for each country just for that search query.

filtering by search query in a google search console data studio report

Use Metric Sliders to filter out values

A new feature that I’ve added to this report template is Metric Sliders. These allow you to filter out values you don’t want to see.

For example, below I’m filtering using the metric slider. I am adjusting the Query table to only show queries which have at least one click and at least a 1% click-through-rate.

I'm filtering using the metric slider. I am adjusting the Query table to only show queries which have at least one click and at least a 1% click-through-rate.

A Google Map showing Search Console Impressions and Clicks by Country

Another component of the report is a Google Map showing the number of Impressions and Clicks by Country.

The bubble size is the number of impressions and the colour is the number of clicks.

a google map showing search console data in data studio. for examining Countries and Queries

A Google Map in Data Studio is a great way to help you visualize geographic data.

You can also use the interactive map to focus in on a specific country and look at charts showing impressions, clicks, CTR and average position.

a map of vietnam and charts showing impressions clicks click through rate and average position

And that’s a wrap on the features in this Data Studio report.

Download Google Data Studio Templates

If you’d like to download one of my Google Data Studio reports as a template to use for your own data, you can visit Data Studio Templates and purchase one.

My Other Blog Posts

If you liked this post you might find some of my other posts interesting.

Michael

Author Michael

More posts by Michael

Leave a Reply