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

Conversion rate using segment in calculation

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



How can I perform a calculation between segmented sessions and a number of goal conversions?


For example:


Sales Visits (segment) / Orders (GA registered goal) = Conversion rate (%)


I tried to create a calculated metric:


CASE WHEN REGEXP_MATCH (Page, Sign|Cart|Funnel|tv\-by\-internet|static|zip|phone|\/static.*ofertacombomulti\/) END


to be able to use it in the calculation formula to get the conversion rate. However, this "case when" is not working.

Could anyone help me get an idea how to get this conversion rate? or what I did wrong? 


Thanks in advance!