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
3.9K members online now
3.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Exclude a goal if previous step contains

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

I have this calculated field but the SUM is not working it just shows 1 or 0

 

SUM(CASE WHEN REGEXP_MATCH(Goal Previous Step - 1, '.*lp-.*') THEN 0 ELSE 1 END)