Funnel Visualization in Looker Studio

Рет қаралды 21,053

Күн бұрын

As well as GA4, Looker Studio is here to stay and it is something you need to start exploring if you are interested in getting the most out of your Google workspace. Looker Studio is the rebranding that Google did of Data Studio, the popular data visualization tool. Since this is one of those updates that need special consideration, we asked Andreea from KPI. Studio to create this video in which she goes over one of the first things you might need to master if you are interested in getting your data storytelling to the next level. Do you know what we are talking about? Yes, it is exactly that. Funnels.
So follow along while Andreea shows us how it is done and what you can do inside this new iteration of this data visualization tool.
🔗 Links:
Visualization library: lookerstudio.google.com/visua...
TrueMetrics Article: true-metrics.com/data-studio-...
Mehdi’s Article: www.wissi.fr/blog/analytics/2....
Formula: IF(Funnel step [CF] = Individual Funnel step [CF] - 1, (Total users by step - Total users)/Total users,null)
Are you a reader more than a video person? Check this out 👉measureschool.com/funnel-visu...
📚📚 Courses and Resources ⏬⏬
Join our premium membership for exclusive content: bit.ly/measuremasters
GTM, GA4, and GDS FREE Courses 💸 bit.ly/measureschool-courses
Need Personalized Help? Contact Us 📞 bit.ly/measureschool-services
👍 FOLLOW US 👍
LinkedIn: / measureschool
Twitter: / measureschool
Instagram: / measure.school
Facebook: / measureschool
OUTLINE
00:00 - Introduction
00:19 - Community Visualization Charts
03:49 - Funnel Chart With Drop-Off Rate
08:33 - Looker Studio Regular Table Chart
11:46 - More Valuable Information

Пікірлер: 8

@MeasureSchool Жыл бұрын

Want More GDS Free Content? Check This Out 👉bit.ly/free-gds-course

@stevengraff8687 Жыл бұрын

Fantastic! Thank you for sharing this with the community.

@ansonnn_ Жыл бұрын

Thank you for the useful content!! If possible, please consider making a tutorial on how to make a simple and elegant tooltip like the one shown in 7:39 ! Would really appreciate it! Thanks!

@rubka430 Жыл бұрын

Great video! I followed your method from 8:33 to make the blend, with cross join it didn't work, it will just give a sum of all total users for each event in the chart (the same total number for each event dimension). If I pick left outer, it works properly. Do you maybe know why does it work for you with cross join, and why doesn't it work for me? I would also like to know if you have a method to count new entries for each step, similarly as GA4 does with the "Make open funnel" function. I couldn't figure this out, I tried with filtering out previous step events without any luck. I think the problem is that the blend is based on event dimensions and total users are just values, while GA4 has each user as a dimension itself, with their own events.

@schleckel Ай бұрын

Seems like the Ayima visualization is no longer available...???

@TaitLawton Жыл бұрын

This got me most of the way! I got stuck with the funnel because some funnel stages are missing data. For example, in the sales funnel "meeting booked" has fewer entries than "meeting completed", but that's just because I forgot to put tasks in the "meeting booked" stage earlier. The % verse initial values still make sense though.

@TaitLawton Жыл бұрын

FYI, I was able to fix this with SQL code in calculated fields. E.g.: CASE WHEN [TIS] Qm booked IS NOT NULL THEN [TIS] Qm booked WHEN [TIS] Qm booked IS NULL AND [TIS] Qm completed IS NOT NULL THEN "QM completed but not booked" ELSE NULL END