← All templatesReporting
ROI Tracking Spreadsheet Template
Campaign-by-campaign ROI tracker that calculates true return — including labor, software, and opportunity cost.
What's inside
- Campaign-level ROI calculator
- True-cost columns (labor, tools, ad spend)
- Attribution model selector
- Payback period formula
- Cumulative ROI tracker
- Best/worst campaign ranking
- Quarterly portfolio review template
How to use it
- 1Log every campaign before launching — name, hypothesis, expected ROI. Reviewing without baselines is meaningless.
- 2Track actual spend and revenue weekly. Don't wait until 'the end' — most campaigns drift mid-flight.
- 3Quarterly, kill the bottom 20% of campaigns by ROI. Reinvest in the top 20%.
Why this template works
Most ROI tracking ignores labor and tool costs — making campaigns look profitable when they're not. This template forces true-cost accounting. The result: you'll discover that some of your 'best' campaigns are actually losing money once you count the 12 hours of work behind them.
Related templates
More in Reporting.
Reporting
Monthly Marketing Report Template
One-page monthly marketing report that gets read by busy founders and leadership — KPIs, wins, misses, next steps.
Get template →ReportingSocial Media Analytics Dashboard Template
Weekly social media dashboard tracking the 6 metrics that actually matter — across Instagram, TikTok, LinkedIn, and Facebook.
Get template →ReportingCustomer Acquisition Tracker Template
Track every new customer by source, cohort, and CAC — and see exactly which channels are scalable.
Get template →