Short answer: A sales pipeline report shows how many open opportunities you have, which stage each one is in, what they are worth, and how they have moved since the last report. A good one fits on a single page. It tells you where deals are stuck and whether enough new opportunities are coming in to reach your target.
- What it shows: open deals by stage, their value, how they moved, and how old they are.
- How often: weekly for the people working the deals, monthly for trends.
- From a provider: a monthly report should tie activity to replies, meetings and opportunities, not only to emails sent.
What is a sales pipeline report?
A sales pipeline report is a snapshot of every open deal, grouped by the stage it has reached. It answers three questions an owner or sales leader asks most often: what do we have, where is it, and is it moving.
It is not the same thing as a forecast. A forecast is a prediction of what will close in a set period. A pipeline report is the raw picture the forecast is built from. If the pipeline report is wrong or out of date, the forecast will be wrong too.
The report only works if your stages are clearly defined, so that everyone moves a deal forward for the same reason. If your stages are loose, start with our guide to B2B sales pipeline stages before you build the report.
What should a sales pipeline report show?
Most useful pipeline reports cover the same handful of things. You do not need more than this to run a small or mid-size sales team.
- Open deals by stage. The count of opportunities sitting in each stage right now.
- Value by stage. The total expected value of those deals. Count and value together show whether you have many small deals or a few large ones.
- New opportunities added. How many deals entered the pipeline since the last report, and where they came from.
- Movement. Which deals moved forward, which moved backward, and which closed as won or lost.
- Deal age. How long each deal has sat in its current stage. Old deals that have not moved are usually dead deals nobody has closed out.
- Next step and date. Every open deal should have a next action with a date. A deal without one is a warning sign.
- Source. Whether the deal came from referrals, inbound, outbound or another channel. This tells you which channels produce real opportunities and not only leads.
Notice what is missing: call counts, emails sent and other activity numbers. Those belong in an activity report. A pipeline report is about deals.
What do pipeline report examples look like?
Pipeline report examples vary by CRM, but the core is a simple stage table. Here is an example layout. The numbers are made up to show the format.
| Stage | Open deals | Total value |
|---|---|---|
| Meeting booked | 12 | $96,000 |
| Qualified | 7 | $63,000 |
| Proposal sent | 4 | $40,000 |
| Negotiation | 2 | $22,000 |
| Total open | 25 | $221,000 |
Below the stage table, add a short movement summary for the period. It can be a few lines:
- Added: new opportunities this period, split by source.
- Advanced: deals that moved forward at least one stage.
- Won and lost: deals that closed, with the reason for each loss.
- Stalled: deals that have sat in one stage longer than your normal sales cycle allows.
That is the whole report. In the example above, a leader can see in seconds that the top of the pipeline is healthy and that few deals are reaching negotiation. The next question is why deals thin out after the proposal, and that is the conversation the report is meant to start.
How often should you review sales pipeline reporting?
Sales pipeline reporting works best on two rhythms.
- Weekly, deal by deal. The people working the deals review each open opportunity, confirm the next step, and close out anything that is dead. This keeps the data honest.
- Monthly, for trends. The owner or sales leader compares this month with the last few. Is the pipeline growing or shrinking? Are deals moving faster or slower? Which source is adding the most real opportunities?
If your sales cycle is long, a quarterly look at win rate and cycle length is also worth doing. Very short cycles may need a quick check more than once a week. The right rhythm is the one where a stalled deal gets noticed before it is too late to save.
What makes a pipeline report misleading?
- Dead deals left open. They make the pipeline look bigger than it is. Close them out.
- Vague stages. If two salespeople would put the same deal in different stages, the stage counts mean little.
- Value without evidence. A deal value that was never discussed with the buyer is a guess.
- No source field. Without it you cannot tell which channel is worth more budget.
- Counting leads as opportunities. A reply or a contact form is not a deal until it is qualified. See our guide to B2B lead qualification for where to draw that line.
What should an outbound provider’s monthly report include?
If you outsource lead generation, the provider’s monthly report feeds the top of your pipeline report. It should let you follow the path from people contacted to opportunities created. Sends alone tell you nothing about results.
| Section | What it should tell you |
|---|---|
| Audience | Who was contacted, by segment |
| Deliverability | Whether emails reached inboxes |
| Replies | Total replies and positive replies |
| Meetings | Meetings booked and held |
| What was tested | Lists, offers or copy compared |
| Next month | What changes and why |
Ask to see the replies themselves, not only the counts. Reading a sample of real replies is the fastest way to judge whether the provider is reaching the right people. Also ask how a positive reply is defined, because a loose definition makes every report look better. Our cold email statistics page gives context for judging the numbers, and what a cold email agency does explains the work behind them.
The provider can report on what happens up to the meeting. What happens after it lives in your CRM. To judge the channel fairly, tag every outbound meeting with its source so your own pipeline report shows how many became qualified opportunities and closed deals. The outbound ROI calculator shows what the channel needs to produce to pay for itself.
At Next Reply, monthly reporting is included in every plan. The Growth plan adds reply qualification, meeting booking and a monthly strategy call, where the report is reviewed with you.
Need more opportunities at the top of the report? Tell us who you sell to and we will tell you honestly whether cold email is a sensible way to fill that first stage. Get a straight answer →
Frequently asked questions
What is the difference between a pipeline report and a sales forecast?
A pipeline report shows all open deals and their stages today. A forecast estimates which of those deals will close in a given period. The forecast depends on the pipeline report being accurate.
How long should a pipeline report be?
One page is enough for most companies: a stage table, a movement summary, and a short list of stalled deals. If people stop reading it, it is too long.
Do I need special software for sales pipeline reporting?
No. Most CRMs produce a stage report without extra tools, and a small team can run one from a spreadsheet. What matters is that stages are defined and deals are updated every week.
Who should own the pipeline report?
One person, usually the sales leader or the owner in a small company. Salespeople update their own deals, but one person should be responsible for the report being current and for running the review.
How much pipeline do I need to hit my target?
It depends on your own win rate. As an example, if you win one in four qualified opportunities, you need about four times your revenue target in qualified pipeline. Use your own history, not someone else’s rule of thumb.
Want a fuller first stage in your pipeline report?
Next Reply runs done-for-you cold email for B2B companies, with monthly reporting on every plan. You approve every list before anything sends. Tell us who you want to reach.