You're running cold email campaigns, replies are coming in, but every Friday you stare at a blank spreadsheet trying to figure out what to report. You know you need data, but you're not sure what metrics actually tell you if a campaign is working or dying.
Most people report on vanity metrics. Opens, clicks, total emails sent. These feel good to track but they don't tell you if you're making money.
Here's a practical weekly reporting template that focuses on the three metrics that matter - and how to build it so it takes 15 minutes instead of two hours.
Every cold email campaign lives or dies on these three numbers:
Everything else is noise. Open rate doesn't matter if no one replies. Click rate doesn't matter if clicks don't lead to replies. You need to measure the funnel that actually converts to revenue.
Set up a simple Google Sheet or Excel file with these columns:
Each row is one active campaign. At the bottom, add a totals row that sums everything across all campaigns.
Here's what the math looks like:
Let's say you ran two campaigns this week:
Campaign A: Software Implementation for Logistics
Campaign B: Fractional CFO Services for E-commerce
Weekly Total
Immediately you can see Campaign A is outperforming Campaign B. The positive reply rate is 5.3% vs 3%, and it's converting to meetings better. That's actionable intelligence. You know where to focus next week.
Different industries will have different benchmarks, but here's what healthy campaigns typically look like:
If your positive reply rate is below 2%, your email copy or targeting needs work. If replies are coming in but meetings aren't scheduling, you have a follow-up or qualification problem.
This is where you diagnose why numbers are moving. Examples:
These notes become your experiment log. Six months from now, you'll look back and see exactly what caused a lift.
Don't manually count replies each week. Export from your email tool (Gmail, Outlook, Apollo, Lemlist, whatever you're using) into a spreadsheet. Most platforms have built-in reporting that gets you halfway there - you just need to organize it into this format.
If you're using multiple sequences across different campaigns, export each one separately, calculate metrics per campaign, then aggregate.
Time investment: 10-15 minutes if you automate the export. 45 minutes if you're doing it manually.
Every Friday afternoon, fill in that week's numbers. Then ask these three questions:
1. Which campaign performed best on positive reply rate? That's your winner. What made it work? Was it the targeting, the copy, the subject line? Replicate it.
2. Which campaign is below benchmark? What's broken? Usually it's one of three things: targeting is too broad, copy isn't resonating, or follow-up isn't happening. Fix one variable next week and re-measure.
3. Is your meeting rate staying consistent week to week? If positive replies are up but meetings are down, you have a conversation quality issue. If both are down, you have a campaign issue.
Create a Google Sheet with these headers and start filling it in this Friday:
Week | Campaign | Emails Sent | Total Replies | Positive Replies | Meetings | Reply % | Positive % | Meeting % | Notes
That's it. You don't need anything fancy. The value isn't in the spreadsheet - it's in the discipline of measuring the same three numbers every single week and adjusting based on what you see.
Most teams either don't track anything or track 15 metrics and get analysis paralysis. This template gives you the middle ground - specific enough to be useful, simple enough to actually maintain.
If you're managing multiple campaigns across different email tools, or you have team members running campaigns in parallel, this template becomes harder to maintain consistently. Exports happen at different times, data gets duplicated, someone forgets to fill in notes, and by month two you're staring at an incomplete spreadsheet and guessing at what actually happened.
That's the gap where most agencies either hire someone full-time to manage reporting (expensive and still error-prone) or stop measuring altogether (which means flying blind). At BEC Growth, we handle campaign management, follow-up, reply sorting, and reporting all as one system - so the numbers feed into your weekly report automatically, and we're already optimizing each campaign based on exactly these metrics. If you reach a point where the template above is taking more time to maintain than it's worth, that's usually the sign that scaling the operation needs a different approach.
Ready to Sign Clients On-Demand?
BEC Growth builds and manages your entire cold email system from infrastructure to reply handling.
Book a Call →