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.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