Planning resource
Cold Email KPI Dashboard Template
A reusable cold email KPI dashboard template: the panels, formulas, and review cadence to track the full funnel and ROI.
Why this matters
This template gives you a ready structure for a cold email KPI dashboard — the panels to build, the formulas behind each metric, and a review cadence. Copy it into a spreadsheet or BI tool and replace benchmark ranges with your own verified rates.
Dashboard panels and formulas
Panel, metric, and formula for a cold email KPI dashboard
| Panel | Metric | Formula |
|---|---|---|
| Volume | Delivery rate | Delivered ÷ Sent × 100 |
| Volume | Bounce rate | Bounces ÷ Sent × 100 |
| Engagement | Open rate | Opened ÷ Delivered × 100 |
| Engagement | Reply rate | Replies ÷ Delivered × 100 |
| Engagement | Positive reply rate | Positive replies ÷ Delivered × 100 |
| Conversion | Meeting rate | Meetings ÷ Positive replies × 100 |
| Conversion | Close rate | Clients ÷ Meetings × 100 |
| Cost | Cost per meeting | Total cost ÷ Meetings |
| ROI | ROI | (Revenue − Cost) ÷ Cost × 100 |
| Risk | Complaint rate | Complaints ÷ Delivered × 100 |
How to build it in a spreadsheet
- Create one row per campaign wave with raw counts: sent, delivered, opened, clicked, replied, positive replies, meetings, clients, cost.
- Add calculated columns using the formulas above so rates update automatically.
- Add a 'forecast' column next to 'actual' to compare each wave against your calculator scenario.
- Freeze the header row and color-code stages that fall below your working target.
- Add a complaints and unsubscribes row as an early-warning panel.
Review cadence
- Weekly: delivery, reply, positive reply, and complaint trends.
- Monthly: cost per meeting, CAC, ROI, and close rate vs assumptions.
- Per campaign: actuals versus conservative/working/upside forecast.
- Quarterly: replace benchmark ranges with your own historical rates.
What to avoid
Don't headline vanity counts
Sent volume and raw opens are inputs and diagnostics. Headline positive reply rate, cost per meeting, and ROI so the dashboard drives decisions, not applause.
Dashboard build checklist
- One row per campaign wave with raw counts.
- Calculated rate columns using the formula table.
- Actual vs forecast column for each wave.
- Positive reply rate and cost per meeting as headline KPIs.
- Complaint and unsubscribe panel included.
- Named owner and weekly/monthly cadence set.
Frequently asked questions
Which KPIs belong on a cold email dashboard?
Delivery, open, click, reply, positive reply, meeting, close, cost per meeting, CAC, ROI, and a risk panel for complaints and unsubscribes.
How do I build a KPI dashboard in a spreadsheet?
One row per wave with raw counts, calculated rate columns from the formula table, an actual-vs-forecast column, and color-coded stages below target.
What is the review cadence?
Weekly for engagement and deliverability, monthly for economics and close rate, per-campaign versus forecast, and quarterly to replace benchmarks with your own data.
Related pages
Model your own numbers
Use the ColdMailCalculator to turn assumptions into a reviewable forecast instead of a guess.
Forecasts and metrics ranges are educational estimates based on user-provided assumptions. Results are not guaranteed. This content is not legal, financial, deliverability, or business advice.