Hi team,
my google ads campaign’s name be like: XXX_EN_Search_US_XXXX. EN refers to English language.
I was creating a campaign report in data studio, using campaign as dimension and ctr as metrics. Then I made a drop-down list to filter the English campaign, the formula be like:
CASE
WHEN CONTAINS_TEXT(Campaign, ‘EN_’) THEN ‘EN’
WHEN CONTAINS_TEXT(Campaign, ‘JP’) THEN ‘JP’
ELSE ‘Others’
END
It should work but it didn’t. The report showed user configuration error. Later I tested the formula again using cost as a metric and surprisingly found that everything works perfectly.
This made me wonder—when using aggregated dimensions combined with metrics that require calculation, could this potentially cause issues? It just like a pivot table, does it? Cause later I created a new field using the formula [clicks/impressions] to calculate CTR, and it worked perfectly.
But then I encountered another issue: some metrics can be calculated if all the required data points for their formula are available, while others cannot. For example, Impr. (Abs. Top) = impressions on the absolute top / impressions. Since Looker Studio doesn’t have a built-in metric for impressions on the absolute top, Impr. (Abs. Top) cannot be calculated when using aggregated dimensions. And if I simply use the built-in Impr. (Abs. Top) as a metric, it just sums up the data, which isn’t accurate in this context. Do you know how to address this issue?
Thank you so much for your help again and looking forward for your advice.