Conversion rate using segment in calculation
How can I perform a calculation between segmented sessions and a number of goal conversions?
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!