Most HubSpot instances deliver what the platform makes easy to build: deal count and deal value by stage. Sales leaders need something different. They need to know which deals will close this quarter, which reps are converting at each stage, which deals have been stagnant for three weeks, and where new pipeline is coming from. Here is how to build those reports.
What Sales Leaders Actually Need vs. What HubSpot Delivers by Default
Default HubSpot pipeline reporting shows you a Kanban board or a summary table of deals by stage with total value. That tells you how much pipeline exists. It does not tell you whether that pipeline is real.
A pipeline review conversation requires five things: forecast accuracy (what will actually close), stage conversion rates (where deals are getting stuck), deal velocity (how long deals sit in each stage), new pipeline creation versus target, and loss analysis (why deals are being lost). HubSpot can produce all five. The reports are not pre-built, but the data is there if you configure it correctly.
Report 1: Pipeline by Stage With Weighted Forecast
The standard pipeline view shows nominal deal value by stage. A weighted forecast applies your historical close rate at each stage to produce a probability-adjusted revenue number.
How to Build Weighted Forecast in HubSpot
First, confirm your deal stages have deal probability percentages assigned. In HubSpot: Settings > CRM > Deals > Deal Stages. Each stage should have a percentage reflecting your historical close rate at that stage. HubSpot's defaults (10% at Appointment Scheduled, 20% at Qualified to Buy, etc.) are placeholders. Replace them with your actual historical conversion rates.
If you do not have historical data yet, start with the defaults and update them quarterly as you accumulate actual close rates per stage.
To build the report: go to Reports > Create Report > Sales > Pipeline. Select "Weighted deal amount" as the metric rather than "Deal amount." This applies the stage probability to each deal. Group by deal stage. Add a filter for close date within current quarter.
The resulting report shows probability-adjusted revenue by stage. Add to your sales leadership dashboard and review weekly. The gap between nominal pipeline and weighted forecast is your real risk exposure.
Adding AI Forecasting (Sales Hub Enterprise)
HubSpot's AI forecasting, available in Sales Hub Enterprise, uses machine learning to analyze historical deal patterns and produce a forecast separate from your stage probability percentages. It considers factors like how long a deal has been in a stage, the rep's historical close rate, deal size relative to typical deal size, and engagement signals.
The AI forecast appears in the Forecast section of HubSpot alongside the stage-probability forecast. Use both: if the AI forecast is significantly lower than your weighted stage forecast, that discrepancy is worth investigating at the deal level.
Report 2: Stage Conversion Rate by Sales Rep
Stage conversion rate shows what percentage of deals move from one stage to the next, by individual rep. This is the most actionable pipeline report for sales managers because it shows exactly where each rep loses deals.
Building the Funnel Report by Rep
In HubSpot: Reports > Create Report > Sales > Funnel. Select deal stages as the funnel steps. Add "Deal Owner" as the group-by dimension. Set the date range to the last 90 days (short enough to be actionable, long enough to have statistically useful data).
The resulting report shows, for each rep, what percentage of deals move from stage 1 to stage 2, stage 2 to stage 3, and so on. Compare across reps to find where conversion rates diverge.
Common patterns:
Rep A converts 70% of Qualified deals to Demo, but only 25% of Demos to Proposal. The demo is not landing. This is a product-market messaging problem or a qualification problem (bringing in the wrong buyers). Address with demo coaching or tighter qualification criteria.
Rep B converts 60% of Proposals to close, but only 30% of Qualified deals to Demo. The rep closes well but has trouble getting meetings. The pipeline entry point is the constraint. Address with outreach coaching or SDR support.
These insights are invisible in aggregate pipeline reports. They only appear when you look at conversion by rep.
"Your weakest pipeline report tells you how much you have. Your best pipeline report tells you which deals will actually close and which rep needs coaching on which stage."
Report 3: Average Days in Stage With Stale Deal Alerts
Deal velocity is the leading indicator of forecast risk. A deal that has been in "Proposal Sent" for 45 days when your average is 10 days is not a pipeline number. It is a problem you have not addressed yet.
Building the Average Days in Stage Report
In HubSpot: Reports > Create Report > Custom Report Builder. Use the Deals object. Add a calculated field for "Days in current deal stage" using HubSpot's date difference function between "Date entered [stage]" properties and today. Group by deal stage. Display as average.
HubSpot creates "Date entered [Stage Name]" properties automatically for each deal stage you configure. These are the foundation of velocity reporting. If your deal stages changed at any point, earlier deals may be missing some stage entry date data.
Automating Stale Deal Alerts
Build a HubSpot workflow that fires when a deal has been in a stage for longer than your defined threshold.
Example: Deal is in "Demo Scheduled" for more than 14 days with no activity logged. Workflow fires, creates a task for the deal owner ("Follow up on stalled demo"), and optionally notifies the sales manager via email or Slack.
Set thresholds based on your actual average days per stage, not arbitrary round numbers. If your average time in Proposal Sent is 8 days, set the stale alert at 16 days (2x average). Alerts set too early create noise. Alerts set too late surface problems after they become losses.
Report 4: New Pipeline Created This Month vs. Target
Sales leaders need to know if the team is building enough pipeline to hit future quarter targets. This requires a report on pipeline creation rate, not existing pipeline balance.
Building the New Pipeline Report
In HubSpot: Reports > Create Report > Deals. Filter by "Deal create date" within the current month. Group by "Deal owner." Show total deal amount and deal count.
Set a static target line if your dashboards support it (available in HubSpot dashboards using Report goals). If not, add the target number as a reference in the dashboard description and update it monthly.
This report answers the question: "Are we building the pipeline we need for next quarter?" A company that needs $2M in closed revenue next quarter with a 25% close rate needs to create $8M in new pipeline this quarter. If the new pipeline report shows $3M created month-to-date against a $4M monthly target, the team is behind and the gap compounds.
Breaking Out Pipeline by Source
Add a secondary dimension to this report: "Original source" or "Latest source." This shows which channels are generating new pipeline. When sales and marketing leaders review this weekly, it connects marketing's channel investment to actual pipeline creation rather than MQL volume.
Report 5: Closed Lost Analysis by Reason
Every lost deal is data. If the data is never analyzed, you are paying full price for a lesson you do not learn.
Setting Up Closed Lost Reasons
In HubSpot: Settings > CRM > Deals > Add a required field for "Closed Lost Reason." Make it a dropdown with specific options, not a free text field. Specific options produce reportable data. Free text produces anecdotes.
Common Closed Lost Reason options for B2B:
- Chose a competitor (specify which in a notes field)
- No budget approved this cycle
- Project delayed or cancelled
- Champion left the company
- Product gap (specify missing feature)
- Pricing not approved
- Lost to status quo / no decision
Building the Closed Lost Analysis Report
Filter deals by Deal Stage = Closed Lost AND Close Date within the last 90 days. Group by Closed Lost Reason. Show deal count and total deal value lost per reason.
Review this report monthly with both sales and product. If "Product gap" appears more than 20% of the time, that is a product roadmap conversation. If "Chose a competitor" is the top reason, you need competitive intelligence on why you are losing and to whom. If "No decision" is the top reason, your qualification process is bringing in deals that were never real.
Setting Up HubSpot's Deal Forecasting Feature
HubSpot's Forecast tool (available in Sales Hub Professional and above) is separate from pipeline reporting but complements it. Find it in Sales > Forecast. It shows a rollup of deals by expected close date, stage probability, and rep. Sales reps can submit manual forecasts that override the probability-based calculation, which is useful for deals where the rep has context the algorithm does not.
Review the forecast weekly with sales leadership alongside the weighted pipeline report. When the rep forecast and the probability-weighted forecast diverge significantly on a specific deal, ask why. The answer is usually informative.
Pipeline Reporting Quick Reference
Build these five reports, put them on a sales leadership dashboard, and review weekly: (1) Pipeline by stage with weighted forecast. (2) Stage conversion rate by rep. (3) Average days in stage with stale deal workflow alerts. (4) New pipeline created vs. monthly target. (5) Closed lost analysis by reason. If you only have time to build three, start with weighted forecast, stage conversion by rep, and closed lost analysis. Those three will change more conversations than all other pipeline reports combined.
Frequently Asked Questions
What deal stages should I configure in HubSpot to get accurate pipeline reporting? Your deal stages should match the stages your sales team actually uses in their process, not HubSpot's defaults. The key criteria: each stage should have a clear definition of what it means for a deal to be there, each stage transition should require a specific action (a discovery call booked, a proposal sent, a verbal agreement received), and the number of stages should be small enough that reps actually update them (5-8 stages maximum). More stages create more data entry friction and less compliant stage tracking.
How do I get sales reps to update deal stages consistently in HubSpot? Make stage updates required at transition points rather than optional at any time. HubSpot allows you to make specific properties required when a deal moves to a new stage (Settings > CRM > Deals > Deal Stages). Require "Close Date" to be set when a deal reaches Proposal Sent. Require "Closed Lost Reason" when a deal moves to Closed Lost. Required fields at key transition points improve data quality without requiring separate admin reminders.
How accurate is HubSpot's AI forecasting? AI forecasting accuracy improves with more historical deal data. TPG's experience: companies with 200+ closed deals in HubSpot see AI forecast accuracy within 10-15% of actual close. Companies with fewer than 100 closed deals see more variance. The AI model looks at deal age in stage, rep close rate history, deal amount compared to rep average, and engagement signals. It is most useful as a sanity check against your rep-submitted forecasts, not as a replacement for deal-level review.
Can I report on pipeline that was created by marketing vs. by sales in HubSpot? Yes, using the "Original Source" deal property and the deal-to-contact association with attribution data. Deals associated with contacts whose original source is organic search, content, or campaign-attributed channels can be tagged as marketing-sourced. Deals created directly by a sales rep via manual prospecting can be tagged as sales-sourced. This requires consistent UTM tracking and HubSpot attribution setup, but once in place, source-of-pipeline is one of the most valuable reports for marketing and sales alignment conversations.
What is a healthy pipeline coverage ratio? Most B2B companies target 3-4x pipeline coverage (pipeline value is 3-4 times revenue target). Conservative coverage for a team with a 25% win rate and short sales cycles might be 3x. A team with longer sales cycles and more deal volatility should target 4-5x. If weighted forecast is the metric instead of nominal pipeline, 1.5-2x weighted pipeline against target is a reasonable threshold. Coverage below 2x nominal pipeline is a risk flag that warrants a pipeline build sprint.
The Pedowitz Group | pedowitzgroup.com | Revenue Marketing Experts Since 2007