How to Add Conversion Rate in Looker Studio Reports

► 👩‍💻 Work with me: bit.ly/3WH6BDt
► 🚀 101 Training: bit.ly/4be6vrs
► 👨‍🏫 Team Training: bit.ly/3YRuV4O
► 🗂️ Resources Hub: bit.ly/45Sc9fN
► 📨 Join my Newsletter: bit.ly/3UTrvOu
---
How to Add Conversion Rate in Looker Studio Reports:
1️⃣ Insert a new Scorecard and select the Metric "Event Count" or "Conversions"
2️⃣ Select your Event Count or Conversions scorecard, scroll down under the SET-UP Column on the right-hand-side and click on ADD A FILTER
3️⃣ Filter based on your Event or Conversion Name
4️⃣ Select the Event Count or Conversion Scorecard, hold down the CTRL or Command button (for Mac users), and select Sessions (or Users if you would like to calculate the conversion rate based on users)
5️⃣ Right Click and select "Blend Data"
6️⃣ The formula should be SUM (Event Count) / Sum (Sessions)
⏩ You can follow the above steps to calculate the completion rates in each step in your customer journey
That's it!

[@ebbddl]

As someone else here already noted: this is not the way you can get the session conversion rate for purchase from GA4 to Looker Studio. That is because you can have more than one purchase in one session, so the method used here will give a higher session conversion rate?

[@adriavalexander]

His videos are on point. I always look forward to seeing more videos from XYZ Lab :)

[@georgekarakitsios8058]

So, how can you create a time-serie chart based on the User CR based on 1 specific event?
Thank you / Euxaristw :)

[@rhysrobinson1826]

did you ever figure this out?

[@ellenannis7969]

@@rhysrobinson1826 I am wondering the same, have you figured it out? Thanks!

[@sarahalice6321]

Thank you so much!

[@panchomarquez]

This was so useful. Thanks a lot.
Question, if I want to use this but in a table and not in a Scorecard I can just do it by using the Blended Data we just created?

[@xyzl]

Yes you can!

[@ItsClicked]

This is useful however this is not the conversion rate that GA4 uses, this is the UA way of calculating conversion rate. Been looking for a way to calculate the session conversion rate, via a calculate field in Looker, for ages and I don't think it is possible.

[@vitalikuzmin3263]

Thank you so much! Your video did help me as i've spent hours of trying to set up the funnel with parameters only !

[@nb_pt]

This is great. Thank you!
Why are you using event counts and not sessions for the conversion?

[@BrunoJanches]

I love you! Finally I found what I needed! Yo are the beeeeeesstt

[@RodrigoFerreira-rv2by]

Very good information. Thanks a lot!

[@JorgeTorres-v8j]

This is gold