I need to calculate what ROAS (return on advertising spend) I should have on days e.g. 7, 14, 28 after the launch of a campaign to get 120% on day 365. I have the spend and the revenue numbers readily available. I would like to use spreadsheets only if possible. I would appreciate any tips on how to approach this.
1 Answers
Calculation
ROAS = Revenue attributable to ads / Cost of ads
Formula
=B9/B10
Example
Create Dropdown to pick the date.
And Use this formula to get ROAS in the chosen day you can type the day.
=INDEX(B12:12,1,MATCH(A14,B1:1,0))
Getting ROAS Launch to date
=AVERAGE(B12:12)
Related