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

Google Data Studio

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

I'm trying to get some data to display after using a custom variable.

 

The Formula is parsing OK, despite my limited Regex knowledge, but so far I've had 3 system errors

 

CASE WHEN REGEXP_MATCH(Event Action, 'Buy Online') THEN 1 ELSE 0 END

 

ed61c361 - The server encountered an internal error and was unable to complete your request.

7a6e83f0 - The server encountered an internal error and was unable to complete your request.

05371a3a - The server encountered an internal error and was unable to complete your request.

 

Otherwise the graphs are loading ok. Very frustrating. Any help is much appreciated.

Google_Data_Studio.jpg

Google Data Studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Try this - CASE WHEN REGEXP_MATCH="Buy Online" THEN "1" ELSE "0" END

 

Gregg

Google Data Studio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I've got it to work, but st the moment it is only displaying as a Dimension and not a Metric. I'd like to have a double axis-ed graph with sessions on the left and buy online clicks per day on the right hand axis.