Marketing template
Marketing campaign tracker
Compare campaigns by spend, clicks, leads and revenue with click rate, cost per lead and return calculated for you. Channel totals feed a chart.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Campaigns
85 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 220 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Frozen headers
- 1 chart
- 5 conditional format rules
A look at the Campaigns sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Campaign performance | |||||||
| 2 | Enter results as they come in. Ratios and the channel summary update on their own. | |||||||
| 3 | SPEND | LEADS | COST PER LEAD | REVENUE | RETURN | |||
| 4 | $46,900 | 1,395 | $33.62 | $194,500 | 315% | |||
| 5 | ||||||||
| 6 | Campaign | Channel | Start | End | Budget | Spend | Impressions | Clicks |
| 7 | Fall search push | Search ads | Sep 1 | Oct 31 | $12,000 | $11,450 | 410,000 | 9,840 |
| 8 | Brand awareness video | Social ads | Sep 15 | Oct 15 | $8,000 | $8,320 | 960,000 | 7,120 |
| 9 | Retargeting | Social ads | Oct 1 | Nov 30 | $5,000 | $3,610 | 285,000 | 5,230 |
| 10 | Monthly newsletter | Sep 1 | Nov 30 | $1,500 | $1,180 | 64,000 | 4,410 | |
| 11 | Win back series | Oct 10 | Nov 20 | $800 | $640 | 18,000 | 1,350 | |
| 12 | Trade show booth | Events | Oct 21 | Oct 23 | $15,000 | $14,200 | 6,000 | 0 |
- marketing
- campaigns
- roi
- leads
- ads
More marketing templates
MarketingSocial media calendarSchedule posts by date, time and channel, then log likes, comments and shares once they go live. Today is highlighted and a summary ranks channels by engagement.
MarketingContent calendarRun your content pipeline from idea to published with owners, stages and deadlines. An Up next sheet lists what ships soonest.
MarketingEditorial calendarPlan magazine or newsletter issues with copy and design deadlines worked back from each publish date. Stories roll up into readiness per issue.
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
Start your marketing campaign tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.