HubSpot Sales Reporting: Pipeline, Win Rate and Forecasts

Good HubSpot sales reporting answers four questions: is there enough pipeline, how much of it do we win, how long does it take, and what will we close this quarter. HubSpot stores the deals, stages, owners and dates you need. The work is in choosing the right cuts and making sure the underlying data is clean enough to trust. Here is how to build a pipeline, win rate and forecast report that sales managers actually use.

The four numbers every sales report needs

Together these give you sales velocity = (open deals × win rate × average deal size) ÷ sales cycle days, a rough measure of revenue generated per day. Say you have 60 qualified open deals, a 25% win rate, an average deal of R48,000 and a 45-day cycle: velocity is 60 × 0.25 × 48,000 ÷ 45 = R16,000 per day. You can raise it by improving any of the four inputs, which makes it a good conversation starter in a sales meeting.

Pipeline reports: coverage and movement

A single pipeline total is not very informative. Report pipeline by stage and add pipeline coverage = open pipeline due to close this quarter ÷ remaining quota. If you need R1.2 million more this quarter and only R2.4 million is in the pipeline for the quarter, coverage is 2×. Whether that is enough depends on your win rate: at 25% you expect to close about R600,000, so you have a gap.

Also show pipeline movement between two dates: deals created, deals moved forward, deals slipped (close date pushed out), won and lost. Slipped deals are the most honest signal of forecast risk, and most dashboards don't show them.

Win rate done properly

Win rate is easy to calculate badly. Use closed deals only (won and lost), not open ones. Then cut it by the things you can act on:

• By owner: coaching opportunities, but look at deal counts too; 3 of 4 is not the same as 30 of 40.
• By source: which lead sources produce deals you actually win.
• By deal size band: large deals often have lower win rates and longer cycles.
• By stage reached: stage-to-stage conversion shows exactly where deals die.

Record a closed-lost reason on every lost deal. Without it, the report can tell you that you lose, but not why. See the sales KPIs guide for more metrics you can add once the basics are in place.

Sales cycle: where the time goes

Average cycle length on its own hides where deals stall. Measure the median days deals spend in each stage, using won deals from the last two or three quarters. Say your median cycle is 45 days, but deals sit in ‘Proposal sent’ for 21 of them. That points to a specific fix: faster proposal follow-ups, clearer pricing or getting the decision-maker involved earlier. Report the median rather than the average, because a few deals that dragged on for a year will distort an average badly.

A simple weighted forecast

A weighted forecast multiplies each open deal's amount by a probability for its stage, then sums the result. Use your own historical stage conversion rates rather than guesses where you can.

Report the weighted forecast next to the reps' own commit number. When the two differ widely, the conversation that follows is usually more valuable than either number.

Data hygiene checks before you trust the report

• Open deals with a close date in the past.
• Deals with no amount or a placeholder amount.
• Deals sitting in one stage far longer than your average cycle.
• Closed-lost deals with no reason.
• Duplicate deals for the same company and opportunity.

Putting the report together

1. Summary: forecast versus target, pipeline coverage, biggest risk.
2. KPIs: pipeline, coverage, win rate, average deal size, cycle length, velocity.
3. Pipeline by stage and movement (created, advanced, slipped, won, lost).
4. Win rate by owner and source, with deal counts.
5. Weighted forecast table.
6. Data hygiene counts.

Summarix can connect HubSpot (and Pipedrive) as a data source and produce this kind of report with the numbers computed by code and a written summary of what changed. Schedule it weekly for the sales meeting, or send it to a Slack or Microsoft Teams channel; see sending reports to Slack and Teams.

Conclusion

Keep the definitions fixed, show deal counts next to percentages, and always compare with the previous period. A HubSpot report built on clean data and four core numbers will tell your team more than a dashboard with forty widgets.