Sales template
Ad Campaign Performance Tracker Template
Compare ad campaigns on what matters. Cost per click, cost per acquisition and return on ad spend are calculated.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Campaign | Spend | Clicks | Conversions | Revenue | CPC | CPA | ROAS |
| 2 | Search | 12,000 | 2,400 | 96 | 48,000 | =B2/C2 | =B2/D2 | =E2/B2 |
| 3 | Social | 8,000 | 3,100 | 40 | 18,000 | =B3/C3 | =B3/D3 | =E3/B3 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
F2 =B2/C2
Cost per click.
G2 =B2/D2
Cost per conversion.
H2 =E2/B2
Revenue per unit of ad spend.
Make it yours by asking
Try a request like this in Tabstra:
"Create an ad campaign tracker with campaign, spend, clicks, conversions, revenue, CPC, CPA and ROAS"