Make a Compact Data Studio Report using Optional Metrics and Drill Downs
Recently Google Data Studio introduced Optional Metrics. These allow you to pick and choose what metrics to display on each chart.
Optional Metrics means you can easily switch between different metrics in a chart. For example you could compare Users with Sessions. You can also switch between Users and Bounce Rate.
In practical terms this means that while previously if you had wanted to show Bounce Rate, Avg Time on Page and Sessions over the past month you might have needed to have three separate tables. Now, you can have just one table – with several optional metrics.
Drill down dimensions lets us add multiple types of dimensions to a single chart or table.
Combining multiple Metrics with Drill Down dimensions gives us the option to fit a lot of data into only a few charts.
So in this Data Studio report below, you’ll see each chart has multiple dimensions and multiple metrics in them.
Optional Metrics in a Scorecard
Let’s start off by creating a scorecard with multiple metrics.

We can add Sessions as our default metric, and Users, Page Views, Bounce Rate and Avg. Time on Page as our optional metrics.

A Compact Time Series Chart
So let’s try and squeeze in some date data and metrics into a time series chart.

And this allows us to see page views, users, bounce rate, and average time on page by month, week and date.

A Table with drill downs and optional metrics
Let’s squeeze four different dimensions and five different metrics into one table.

This gives us a lot of different ways to look at a variety of data!

A Page / Page Title table with lots of data
In our final chart we are going to look at five different metrics by Page and Page Title. We had those as Dimensions and make sure ‘Drill down’ is selected.

The table allows us to see several different metrics. In the example below, you can change the dimension from Page Title to Page and then choose to look at sessions, page views, and avg. time on page from the optional metrics.

Together, Dimension drill downs and optional metrics open up a lot of possibilities for Data Studio reports.
My Other Blog Posts
If you liked this article you might like my other blog posts.
Hi Michael,
Nice tutorial!
Just curious if you have run into the issue that the optional metrics are only follow the left y-axis scale in the time series charts. So if I have pageviews on the left and bounce rate in the optional metrics, the bounce rate will be too small to show.
Please let me know if you have any thoughts on this. Thanks!
Hi Chelsea. Good point. Just played around with sessions / bounce rate as an optional metric and there’s no way to set it as a right axis default. Unfortunately I’m not sure there’s a solution for that – that I can figure out at least. Let me know if you manage to find a way to solve it.
Hi Michael – I assume there is still no solution to scaling metrics on a different axis?
[…] For an excellent in-depth article on this topic, read Michael Howe-Ely’s blog post available here. […]
can we have more than 10 optional metrics per chart ? please tell me. thanks
Hi Dante. No you can’t. 10 seems to be the maximum number of optional metrics you can have in a chart or table.