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! One of the new features launched for Data Studio include a Hierarchy feature.

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

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.

A geo-map in Google Data Studio

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

A data tab with only country in Google Data Studio

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

Setting up the Data tab to use the new hierarchy feature in Data Studio to drill down into data.

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

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

Setting up the style of a geo-map in Data Studio

Then we can left click to select only South Africa.

Drilled down into specific countries using the Hierarchy feature in Data Studio

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

Drilling down from country to region in data studio geo map

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

Drilled down into cities using the Hierarchy feature in Data Studio

As a result of clicking Drill Down, it shows us a regional map of South Africa, showing which provinces our users are from.

A map of South Africa showing some provinces highlighted.

Next, 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.

Drilled down into cities using the Hierarchy feature in Data Studio

Finally, 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.

My Other Blog Posts

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

I’m Michael


I’m a South African digital analyst living in Toronto, Canada. I blog about digital marketing, web analytics and data visualization.

Get in touch with me!
LinkedIn
Twitter
Email

Michael Howe-Ely