Data Studio
3.7K members online now
3.7K 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?