AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Funnel eCom in Calculated field

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

I want to present my website funnel in DS.

How can i achieve this?

For example the shopping behavior report in GA:

Sessions with CHECKOUT:

(COUNT(gaSmiley FrustratedhoppingStage = 'CHECKOUT") / COUNT(gaSmiley FrustratedhoppingStage = 'ALL_VISITS")

OR

COUNT(CASE WHEN Shopping Stage  IN ("PRODUCT_VIEW") THEN 1 ELSE 0 END )

BUT

How do i get to count the sessions?

My desired outcome is a percentage. 

Thanks!