Resource · Worksheet
Cold DM Pipeline Forecast Worksheet
A pipeline forecast connects the activity you control, sends, to the revenue you hope for, through each stage. This worksheet makes every stage conversion explicit so you can see which assumption is doing the heavy lifting. Unlike a vague revenue hope, a stage-by-stage forecast shows you exactly where the money is supposed to come from and where it is most likely to leak out. That visibility is what turns revenue from a wish into a plan you can manage.
How to use this worksheet
Enter expected monthly sends and your stage rates. The sheet multiplies down the funnel to a revenue estimate. Update it monthly as real rates replace guesses, and you will gradually convert a forecast into a reliable planning instrument that your team can trust.
Use the forecast to set expectations with stakeholders. A number derived from visible stage rates is far easier to defend than a target pulled from thin air, and it invites useful challenge on the assumptions rather than the conclusion. People argue less with a number they can trace.
Pipeline forecasts are planning estimates, not booked revenue.
Stage rate table
Each stage rate converts the prior stage's count into the next. Fill the result column by hand or with a formula; the act of filling it forces you to confront whether your assumed rates are even plausible before you build a plan on top of them.
| Stage | Rate | Resulting count |
|---|---|---|
| Sends | 100% | 1000 |
| Replies | ___% | ___ |
| Meetings | ___% | ___ |
| Clients | ___% | ___ |
| Revenue | value | ___ |
Working the funnel
Multiply each stage by its rate to fill the result column. The final revenue line is clients times average value. The discipline is in doing each step separately so a weak rate cannot hide inside a confident total that looks finished but rests on one bad assumption.
Set sends
From your capacity or goal plan, not a wish.
Apply reply rate
Sends times reply rate for expected replies.
Apply meeting rate
Replies times meeting rate for meetings.
Apply close rate
Meetings times close rate for clients.
Reading the forecast
Compare the forecast to your pipeline tracker once real data exists; the gap shows which assumption was optimistic. A forecast that always beats reality is suspicious; one that is honestly wrong is a learning tool that tells you where your model needs adjustment.
- A big gap at replies suggests message issues to fix.
- A gap at meetings suggests qualification issues to address.
- A gap at clients suggests offer or fit issues to revisit.
Forecast drift and what to do
Forecasts drift because real prospects behave differently than assumptions. When drift appears, resist the urge to quietly nudge the rates to match results; instead, record both the assumption and the actual so you can see which step you systematically overestimate. That record is the asset.
The gap between forecast and actual is data, not embarrassment.
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-pipeline-forecast-worksheet-workflow.webp - Cold DM Pipeline Forecast Worksheet workflow diagram |
Quick checklist
- Expected sends entered from capacity.
- Three stage rates entered honestly.
- Result counts computed per stage.
- Revenue estimate calculated and labeled.
- Compared to tracker once live.
- Conservative unknowns flagged for update.
Related: KPI Tracker · ROI Forecast Worksheet · Volume Calculator · Revenue Forecast Worksheet · All Resources
Frequently asked questions
How is this different from the ROI worksheet?
This emphasizes stage-by-stage funnel conversion; the ROI worksheet centers on cost and profit, and the two complement each other.
What if a stage rate is unknown?
Use a conservative placeholder and mark it; replace it after real sends so you are not flying blind for long.
How often should I forecast?
Monthly is reasonable; weekly adds little unless volume changes fast enough to matter.
Can I forecast for a team?
Yes, sum sends across senders first, then run the funnel once on the total.
Does the forecast guarantee revenue?
No. It is a model of assumptions; actual pipeline will vary from the estimate.
Forecast your next cold DM campaign.
Run the free calculator — no signup required.
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.