Data Studio
3.8K members online now
3.8K members online now
Ask questions about Data Studio
Guide Me

help me plz.

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I would like to adjust the AdWords cost of Google Analytics as follows:

However, the function does not know what went wrong.


If the value of "source / medium" is "google / cpc", add 15% to the cost of Google analytics and calculate "ga: adCost / 1000000"; otherwise, return "ga: adCost / 1000000" I want to do it.
=========================== ( it is wrong function right?)
CASE WHEN REGEXP_MATCH(source, google) THEN ga:adCost/ 1000000 * 1.15 ELSE ga:adCost/ 1000000 END