Using Google Data Studio’s new Hierarchy feature to Drill Down into Regions and Cities

Using Google Data Studio’s new Hierarchy feature to Drill Down into Regions and Cities

There’s been lots of exciting new features added for Data Studio in the past few days!

Many of them have been launched at the Google Cloud Next conference in San Francisco.

One of the new features launched for Data Studio include a Hierarchy function.

This function allows you to Drill Down or Drill Up into various dimensions. Up until now, Data Studio’s geo-map features had been somewhat limited in terms of what they could do.

This latest features promises to make the geo-map function much more usable and sophisticated.

Using the new Hierarchy feature to Drill Down into Geo-Maps

In this blog post, I’ll give a practical example of how to use the new Hierarchy function for geo-maps.

Let’s say we want to take a closer look at which provinces and cities our users from South Africa are living in.

First we need to open the Data tab for our geo-map.

We need to turn on Hierarchy, and then choosing Country > Region > Town/City as our order.

Another new tool for Data Studio is the Chart Header feature.

In the Style tab for your geo map look for the ‘Chart Header’ document and select “Always show”.

We first left click to select only South Africa.

We can then click the down arrow on the Chart header to drill down into our selected country.

Alternatively, we can also right click on South Africa and select Drill Down.

It then shows us a regional map of South Africa, showing which provinces our users are from.

If we want to see exactly what cities are users are from, we can click the Drill Down arrow again and take a closer look at the data.

This gives us a map of cities in South Africa, and we can see that most our users are coming from Cape Town.

To return to our world map view, we can simply click the arrow in the top left hand corner of the chart header to return to our default view.

Below is the data studio report for you to play around with and test out the hierarchy function.

If you liked this article you might like my other blog posts.

Or you can follow me on Twitter!


Author Michael

More posts by Michael

Join the discussion 4 Comments

Leave a Reply