Assume there there are three different marketing campaigns with unique values for revenue and costs and that each campaign has a unique ROAS (Revenue/Costs).What would be the influence of each campaign to the overall ROAS of the three combined campaigns?
% of Influence
- Thread starter wkanaday
- Start date
HallsofIvy
Elite Member
- Joined
- Jan 27, 2012
- Messages
- 7,763
That depends, of course, on the precise relation of each campaign to the overall ROAS. Surely you have more information than just that there are three campaigns.
@HallsofIvy
What other information would be helpful? In this example, there would only be these three campaigns, so the weights would be dependent on the revenue and expenses they are contributing. For the sake of an example:
Is that what you'd need?
Thanks.
What other information would be helpful? In this example, there would only be these three campaigns, so the weights would be dependent on the revenue and expenses they are contributing. For the sake of an example:
- Campaign 1 - Revenue = 200; Cost = 100; ROAS = 2.0
- Campaign 2 - Revenue = 500; Cost = 50; ROAS = 10.0
- Campaign 3 - Revenue = 1,000; Cost = 1000; ROAS = 1.0
- Total Account = Revenue = 1,700; Cost = 1150; ROAS = 1.48
Is that what you'd need?
Thanks.
mmm4444bot
Super Moderator
- Joined
- Oct 6, 2005
- Messages
- 10,902
Are we supposed to assume the unique values, as well, or do you expect to report a symbolic answer?