Data Studio
4.5K members online now
4.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Conversion rate using segment in calculation

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

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!