Comparing Multiple GA Segments on a Chart in Data Studio

Comparing Multiple GA Segments on a Chart in Data Studio

Data Studio’s native Google Analytics connector makes it easy to build customized reports and dashboards using your GA data. In just a few clicks, you can get access to the wealth of dimensions, metrics, and segments from your GA property.

There are however some limitations to how you can use GA assets in Data Studio. One obstacle many people encounter is that only one GA segment can be applied to a single chart. If you are a power user of GA, you’ve likely become accustomed to having the ability to compare up to 4 segments at the same time. This isn’t possible with the native segment functionality in Data Studio, but we have a solution!

In this post we’ll show how you can use Data Studio’s Data Blending feature to compare multiple GA segments on the same chart!

Comparing Multiple GA Segments on a Chart

In this example, we’ll create a time series chart that compares the trends of organic sessions vs. total sessions. The data we’re using is from the Google Merchandise Store demo account.

1. Create a chart with All Sessions

  1. Insert a time series chart of Sessions.
  2. Rename the Sessions field in the chart to “All Sessions”. (For reference, see Edit fields in your reports).

2. Create a chart with Organic Sessions

  1. Insert a second time series chart of Sessions (as in step 1a above).
  2. Apply the Organic Sessions segment to the chart.
  3. Rename the Sessions field in the chart to “Organic Sessions”

3. Blend the charts together

  1. Select both charts, right click on the selection, and select Blend Data.
  2. Voila!

Data Studio allows you to blend up to 5 data sources in the same chart, so this method can be extended to include up to 5 GA segments. It also applies to any chart type, not just time series. Combined with chart-specific calculations, you can also calculate ratios between segments (e.g. organic % of total sessions).

Below is a Data Studio report we built to showcase some of what’s possible using data blending with segments. Let us know what else you’d like to do with your GA data in Data Studio!

Complete list of posts in our 2018 edition 12 Days of Data Studio series:
1. ClickInsight Data Viz Gallery
2. Comparing Multiple GA Segments on a Chart in Data Studio (this post)
3. Exporting to PDF from Data Studio
4. Using Bookmarks Links in Data Studio
5. Keyboard Shortcuts for Data Studio
6. Creating Heat Maps in Google Data Studio
7. Using Charts as Interactive Filters in Data Studio
8. Creating Diverging Bar Charts in Data Studio
9. Creating Thumbnail Images of Data Studio Reports
10. Embedding URLs in Data Studio
11. Open Source Community Connectors for Data Studio
12. Create Custom Charts with Data Studio Community Visualizations

By |2019-05-17T11:55:18-04:00December 4th, 2018|2 Comments
Categories: Data Studio

2 Comments

  1. Johan January 3, 2019 at 10:40 am - Reply

    Can you clarify how you managed to create the Scorecard chart with % of organic of total sessions?
    In other words, how can you combine 2 segments to calculate ratios between them, and show them in a single scorecard

    • Marc Soares January 3, 2019 at 11:51 am - Reply

      Hi Johan,

      The steps described in the post above will allow you to combine both segments onto the same chart using data blending. To calculate a ratio between the segments, you need to create a chart-specific calculated field in the blended chart. See this article in the help centre for instructions on creating a chart-specific calculation: Create a chart-specific calculated field.

      Marc

Leave A Comment