Building a funnel with more than 5 steps

[Mingis]

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]

Hi @Mingis 

what kind of data sources are you using? The solution is more related to the data preparation you can do, because of the limitations you mentioned with blending. Can you just tell us more about the 8 steps and how you need to filter them and with what kind of data source please.

[Mingis]

Hey @Mehdi_Oudjida thanks for your response.

No problem, I'm just using a single Google analytics property. Each stage of the funnel is a different page on the site so I have built the blends out as follows:

Then I can create the conversion rates with a calculated field:

SUM(Active users (Step 2) / SUM(Active users (Step 1)) * 100

I wondered if I might be able to use conditionals in the calculated field to target the steps rather than having to blend and filter.

Happy to provide any other details if helpful.

Cheers.

[Mingis]

Hey @All does anyone have any ideas? Thanks.

[Mehdi_Oudjida · Accepted solution]

@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

[Mingis]

Hey @Mehdi_Oudjida this is a great resource really appreciated, thanks!