Inputs
- Campaign data: [paste a table with campaign name, send date, audience size, delivered, opens, clicks, conversions, revenue, unsubscribes, spam complaints]
- Goal for the period: [for example revenue, sign-ups, event registrations]
- Our usual results: [past averages, if known]
Task
Analyse the data and write a report a manager can act on. Work through this checklist.
Checklist
- Calculate delivery rate, click rate, click-to-open rate, conversion rate, unsubscribe rate and revenue per email sent for each campaign.
- Treat open rates with caution because privacy features inflate them; base conclusions on clicks and conversions.
- Compare each campaign with the period average and flag results 25 percent above or below.
- Pick the best and worst campaign and list what differed: audience, subject, timing, offer, length.
- Check list health: unsubscribe and complaint rates against safe limits.
- Note any data gaps or one-off events that distort the numbers.
Output format
- Metrics table: | Campaign | Delivered | CTR | CTOR | Conversion | Revenue per send | Unsub rate | Flag |
- Three key takeaways in one line each.
- Best versus worst comparison table.
- Test plan: | Test | Hypothesis | Metric | Sample needed |
Rules
- Show the formula once for each calculated metric.
- Do not claim a cause when only one send supports it; call it a hypothesis.






