Resource · Worksheet
Cold DM Monthly Metrics Worksheet
Daily numbers are noise; monthly numbers are signal. This worksheet gives you a rollup table and the analysis prompts that turn a month of outreach data into a decision for next month. The discipline of a monthly rollup is what separates teams that improve from teams that merely stay busy, because it forces a single, honest conversation about what the numbers mean.
How to use this metrics worksheet
At month end, fill the rollup from your tracker and calculators, then answer the analysis prompts in writing. The prompts are the point; a table without interpretation is just a record, and a record without a decision is wasted effort.
Write the analysis, do not just glance at it; the page exposes the hopes the numbers contradict.
Monthly rollup table
The rollup normalizes the month so you can compare it to last month regardless of volume swings. Rates, not raw counts, tell you whether efficiency improved or scale merely did the work.
| Metric | This month | Last month | Change |
|---|---|---|---|
| Sends | ___ | ___ | ___ |
| Replies | ___ | ___ | ___ |
| Reply rate | ___% | ___% | ___ |
| Meetings | ___ | ___ | ___ |
| Clients | ___ | ___ | ___ |
| Cost | $___ | $___ | ___ |
| Profit | $___ | $___ | ___ |
Analysis prompts
These prompts convert the table into action. Answer each in a sentence or two; brevity forces you to commit to a cause instead of listing possibilities and moving on.
- Which rate moved most and why might that be?
- Where did prospects drop out of the flow most?
- What change this month likely caused the shift?
- What is the single fix to attempt next month?
Trend vs noise
One month is still noisy, so compare to the prior two months before declaring a trend. A single dip is often nothing; a three-month slide is a signal you must act on, and the rollup makes that distinction visible.
Stack three months
Put this and the last two side by side.
Spot direction
Is the key rate rising, falling, or flat?
Attribute
Tie the direction to a change you made or a market shift.
Planning next month
End the worksheet by setting next month's primary target from the analysis. One target keeps the team focused; five fuzzy ones guarantee nothing improves, because no one can tell what was supposed to move.
- 1Pick one rate to improve next month.
- 2Choose the single change to attempt.
- 3Set the review date for the next rollup.
Sharing the rollup
If others fund or run the program, share the rollup with the analysis attached. A number with no interpretation invites everyone's personal theory; a number with your written reasoning invites useful challenge on the right point.
A shared rollup with analysis builds trust faster than a dashboard nobody reads.
Worked rollup example
Here is a completed rollup for a month where volume rose but efficiency held, the exact case where raw counts mislead and rates tell the truth. The change column is what you act on at the next planning session.
| Metric | This month | Last month | Change |
|---|---|---|---|
| Sends | 4,000 | 3,200 | +800 |
| Replies | 440 | 352 | +88 |
| Reply rate | 11.0% | 11.0% | 0 |
| Meetings | 120 | 96 | +24 |
| Clients | 22 | 18 | +4 |
| Cost | $5,200 | $4,400 | +$800 |
| Profit | $14,800 | $12,400 | +$2,400 |
Reply rate flat at 11% means growth came from volume, not improvement; next month should protect the rate while scaling.
Next-month plan table
Close the worksheet by committing one target and one change. A single focus beats a list of hopes; the table makes the commitment explicit and reviewable at the next rollup so the month is not spent reacting to noise.
| Item | Commitment |
|---|---|
| Primary target | Lift reply rate 11% to 12% |
| Single change | Test proof hook on 600 sends |
| Guard | Hold daily cap to protect accounts |
| Review date | Same day next month, no exception |
- 1State the one rate to move.
- 2Name the one change to attempt.
- 3Set the unmissable review date.
Running the review meeting
The rollup deserves a short meeting, not a silent doc. Walk the table and the written analysis with anyone who funds or runs the program so the decision is shared and the next target is owned, not just noted.
Show the table
This month vs last, rates first.
Read the analysis
The four prompts, answered in writing.
Set one target
The single rate to move next month.
Assign the change
Who tests what, by when.
Edge cases and caveats
Missing data is common and must be handled honestly. Estimating a gap is fine if you label it; faking a number poisons every decision built on the rollup, so the discipline is to mark what you do not know.
| Gap | Handling |
|---|---|
| A metric missing | Estimate, label clearly, fix the tracker |
| One odd month | Check it against the three-month trend |
| Target missed | Name the cause, reset honestly |
Do and don't quick list
- Do write the analysis, not just the table.
- Do compare to a three-month trend.
- Don't fake a missing number.
- Don't set five fuzzy targets.
Copy-this rollup
Paste this rollup into your monthly review and fill it from the tracker. Rates, not raw counts, tell you whether efficiency improved or scale merely did the work for you this month.
| Metric | This month | Last month | Change |
|---|---|---|---|
| Sends | ___ | ___ | ___ |
| Replies | ___ | ___ | ___ |
| Reply rate | ___% | ___% | ___ |
| Meetings | ___ | ___ | ___ |
| Clients | ___ | ___ | ___ |
| Profit | $___ | $___ | ___ |
What a useful rollup looks like
A useful rollup ends in a decision, not just a table. If the month closes with numbers filed and no change chosen, the rollup was a record, not a review, and next month will repeat this one by default.
A rollup with no next-month target is a diary; a rollup with one is a plan.
Troubleshooting the rollup
When the rollup changes nothing, it is usually a record without analysis. The four prompts are what turn the table into a decision; skip them and the month quietly repeats itself with the same weak spots.
| Symptom | Likely cause | Fix |
|---|---|---|
| No change made | Analysis skipped | Answer the four prompts |
| Surprised by a dip | No trend view | Compare three months |
| Vague plan | Five targets set | Commit to one target |
If the rollup is filed but nothing moved, it was a diary entry; the analysis is the difference between recording and managing.
Your first 15 minutes
Build the rollup template once so month-end is fill-in, not rebuild. A template reinvented each month is a template that drifts and stops being comparable to last month's numbers.
Copy the rollup
The seven-row table.
Link the tracker
So numbers flow in directly.
Add the prompts
The four analysis questions.
Before you launch: final check
Before month-end, confirm the rollup template is ready and the four prompts will be answered in writing. A rollup filed without analysis is a record, not a review, and next month repeats the same weak spots by default.
- Rollup table linked to the tracker.
- This and last month comparable.
- Four prompts answered in writing.
- One next-month target set.
Rate vs volume decomposition
The most useful monthly question is whether growth came from improvement or from scale. Decompose the change: if sends rose 25% and reply rate held, you scaled; if rate rose and sends held, you improved. The lever you pull next depends on which it was.
| Pattern | Meaning | Next move |
|---|---|---|
| Volume up, rate flat | Scaled, not improved | Protect rate, scale more |
| Volume flat, rate up | Improved | Lock the change |
| Both up | Best case | Sustain and study |
| Rate down | Efficiency lost | Find the broken step |
Worked three-month trend
Stacking three months exposes what one month hides. In this example the reply rate drifted from 12% to 11% to 10.5%; no single month looked alarming, but the three-month slide is a clear signal to act before it becomes a cliff.
| Month | Sends | Reply rate | Clients |
|---|---|---|---|
| April | 3,000 | 12.0% | 20 |
| May | 3,400 | 11.0% | 22 |
| June | 3,600 | 10.5% | 21 |
A three-month slide that no single month explains is exactly the quiet failure a monthly rollup exists to catch.
Rollup-to-action loop
Close the loop by feeding the chosen next-month target back into the brief and the SOP, so the rollup actually changes behavior rather than sitting in a doc. The metric is only useful if the program bends toward it.
- 1Take the one target from the rollup.
- 2Write it into next month's brief.
- 3Track it in the weekly review.
Suggested image brief
| Placement | Purpose | Filename and alt text |
|---|---|---|
| After the direct answer | Create an original AI-generated workflow graphic that summarizes the decision, metric, and next action for this topic without third-party logos. | cold-dm-monthly-metrics-worksheet-workflow.webp - Cold DM Monthly Metrics Worksheet workflow diagram |
Quick checklist
- Rollup table filled from tracker data.
- This and last month compared on rates.
- Four analysis prompts answered in writing.
- Three-month trend checked for direction.
- Next month's single target set.
- Review date scheduled for next rollup.
- Rollup shared with stakeholders if relevant.
Related: KPI Tracker · Metrics That Matter · Weekly Review Template · Campaign Scorecard · Cold DM Calculator
Frequently asked questions
How is this different from the KPI tracker?
The tracker is daily or weekly detail; this is the monthly rollup and the decision that follows from it.
What if a metric is missing?
Estimate it clearly as a gap and fix the tracker so next month is complete; do not fake the number.
Should I compare to a target or last month?
Both: last month shows movement, the target shows whether you are on plan.
How many prompts must I answer?
All four; skipping one usually hides the cause of the month's result.
Does the rollup guarantee improvement?
No, but it makes the needed change explicit, which is the first step to acting on it.
Close the loop from metrics to math
Model next month's targets from this month's data.
Forecasts are estimates based on user-provided assumptions. Results are not guaranteed.
Benchmarks, templates, and examples on this page are illustrative planning references, not guarantees of performance. Adjust your outreach to comply with platform terms and applicable regulations.