Home » The Data Studio Blog » Data Studio Funnel Chart – How to adapt your data model to fit with the chart setup

Data Studio Funnel Chart – How to adapt your data model to fit with the chart setup

Last week, the Data Studio team has released a new chart type: The funnel chart!

All the users community on the social networks was excited to discover this new welcomed feature, sharing examples. We were waiting for it for a while, we developed alternative solutions (custom configurations, community visualization…) and now a first native solution exists.

If you want to get an overview of this new native chart type, you can scan the official documentation and read the nice feature review written by Michele Kiss.

Beyond the excitement for the release of the funnel chart, I received also several questions about the required data to use this funnel chart, here 2 examples:

  • “Until now, I use a community visualization with a set of ordered metrics as input, how can I switch to this new chart?” 🤔
  • “My data source is a native connection to GA4 and I want to create an items funnel with the items views, items added to cart, items checked out, and items purchased. How can I do that?” 🤔


Indeed, the Data Studio funnel chart requires to set up 2 fields as incomes:

  • A dimension corresponding to the step identifiers
  • A unique metric for the measure of each step, and also used for the calculation of derived metrics, like the rates (percentage of max or percentage of previous)


So let’s tackle this situation with the tutorial below, adapting the data model to fit with the native Data Studio funnel chart.
As usual, an alternative would be to adapt the data source to be aligned with the requirements of the chart type. But at the same time, you will not prepare another set of reporting data for one single chart if the visualization layer can provide a quick-win solution.

Unlock free access to the full article

Access to this article written by Mehdi Oudjida, Data Studio Expert, is completely free: enter your email address to receive an access link to the full article.

Your email address is only used to send the link, and for the newsletter if you tick the box. It is not stored on this site.

About The Author

Scroll to Top