I need to calculate an Order Conversion Rate in Looker Studio by dividing the number of CO_FINALIZE_SUCCESS events (order successfully submitted) by WO_CHECKOUT_CTA events (# of times someone initiated the ‘Continue to Checkout’) and then multiplying by 100. This data has been imported from my GA4 environment. However, I’m running into issues with the data not allowing a straightforward calculation. What ends up happening is I continue to get 100 every single time. Below is my formula I use. I’ve looked at the event counts in a table and they are different (CO_FINALIZE_SUCCESS = 12K and the WO_CHECKOUT_CTA = 20k) - the date filter applied is auto (last 28 days).
I’ve also noticed when I try and make two separate scorecards for the above event counts, it will force the other scorecard to switch to the other event though I have applied a chart level filter on it (both scorecards will be the same as a result). Hoping someone can help me, I’ve tried asking Gemini and looking at message boards and youtube but to no avail.
(
SUM(
CASE
WHEN Event name = “CO_FINALIZE_SUCCESS” THEN 1
ELSE 0
END
)
/
SUM(
CASE
WHEN Event name = “WO_CHECKOUT_CTA” THEN 1
ELSE 0
END
)
) * 100