Solved: Building a funnel with more than 5 steps - Page 2

Mingis · 05-26-2024 07:14 AM

Hi all,

I have a closed funnel on my website - I want to represent the conversion rate between each step in a table in Looker Studio.

This should be relatively straight-forward as, for example, you can take the number of users that reach stage 2 / number of users on stage 1 to get the conversion rate between steps.

However in order to get those custom metrics I have to blend the data and filter the number of users for each step as part of the blend - that wouldn't be a problem except the funnel is 8 steps long and Looker Studio only allows blends of up to 5 tables.

Does anyone know if there is a way around this e.g. can you filter active users per step as part of the custom metric calculation rather than having to do it as a blend?

Many thanks.

Mehdi_Oudjida

@Mingis

Except that you need to do it by path and not by event name, you should succeed creating your funnel with this tutorial or being inspired by the logic.

https://how.withlookerstudio.com/custom-reports/20220623-google-data-studio-funnel-report-with-a-sin...

Here another solution but interactive this time.

https://how.withlookerstudio.com/custom-reports/20230720-interactive-funnel-report-with-looker-studi...

I hope it helps.

Mehdi

View solution in original post