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
4.3K members online now
4.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Multiple campaigns and custom formula for each campaign in one table

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello there,

 

is it possible to have a table which would be used to calculate adwords budget difference (actual vs planned) for three campaigns in one table? Structure:

 

column(1): Campaign as dimension - in overall there is 3 campaigns;

  • campaign 1 planned budget: 300 dollars;
  • campaign 2 planned budget: 200 dollars;
  • campaign 3 planned budget 80 dollars;

column(2): cost on each campaign - exported via data studio/adwords sync;

column (3): campaign budget - cost

 

I can do one condition on one campaign by adding formula: 300 - cost, but how to do a formula, which could calculate difference in every row, depending on campaign planned budget? Is it with case statement? 

 

Could someone help me out?