A template to build your media plan and arbitrate a budget before spending it. You enter the budget, target cost per lead, close rate and average order value per channel; the spreadsheet projects leads, customers, revenue, margin, net profit and ROAS, each against its break-even point, with a per-channel status. A dedicated block calculates the budget needed to reach your revenue target. Excel version with all formulas and dropdown menus, flat CSV version.
What's inside
- The budget split by channel, in dollars and as a percentage
- Projected leads, customers, revenue, margin and net profit per channel
- Estimated ROAS against the break-even point, with a per-channel status
- The budget needed to reach your revenue target, calculated
Preview
| Channel | Budget | Leads | Customers | Est. revenue | Net profit | ROAS | Status |
|---|---|---|---|---|---|---|---|
| Google Ads | $1,500 | 30 | 8 | $6,375 | $2,325 | 4.3x | Profitable |
| Meta Ads | $800 | 18 | 4 | $3,060 | $1,036 | 3.8x | Profitable |
| LinkedIn Ads | $600 | 7 | 2 | $1,848 | $509 | 3.1x | Profitable |