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

Having issues adding custom metric to GDS table

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I created a custom metric to calculate event actions:

SUM(CASE WHEN REGEXP_MATCH(Event Action, "Enquiry Submit") THEN 1 ELSE 0 END)

and it seems reporting properly. However when I add it, all other standard metrics in the table go 0 (bounce rate, entrances) and pageviews show much higher numbers. When I remove this custom metrics from the table, all other metrics start displaying properly. I feel like I am missing something, since all I am asking is to display pageviews, entrances, bounce rate and total events with specific action.. Any ideas? Thank you.