Sales Pipeline Reports and Dashboards: What to Track in HubSpot

A man standing near a window with a coffee mug, looking toward a wall mounted screen showing a bar chart dashboard, with a laptop open on the table in front of him

A HubSpot pipeline dashboard earns its keep when it tracks five things: deal stage conversion, time in stage, a forecast weighted by probability, win rate, and sales velocity. Everything else is decoration. Track those five and you can tell a healthy pipeline from one that only looks busy.

Most HubSpot portals already ship the reports you need. The problem is rarely a missing report. More often it's a dashboard built on deals nobody updated, stages with no exit criteria, or contacts enriched with nothing past a name and a guess. A report can only describe the data it's handed, and in most CRMs that data goes stale faster than anyone bothers to check.

The HubSpot Reports That Show Where Deals Stall

HubSpot's sales analytics suite ships several report types built specifically to show deal movement, and most teams only ever pin one of them to a dashboard.

  • Deal Funnel.
    Counts deals in each pipeline stage, including the skips when a deal jumps the normal order, plus conversion rate and time spent in a given stage.
  • Time in Deal Stage.
    Breaks out the average days a deal sits in a stage, by rep or by team, so a stall shows up before a forecast call does.
  • Deal Velocity.
    The average number of days deals take to close, by rep or team, the clearest single read on whether your sales cycle is actually getting shorter.

Every stage change also stamps a "Date entered stage" property on the deal automatically, which is what these reports run on behind the scenes. HubSpot's own documentation lists Deal Funnel, Deal Velocity, Time in Deal Stage, and a Weighted Pipeline Forecast report as the core of the suite. Pull the first three onto one dashboard, filtered to the same pipeline, and you can see not just how many deals sit where, but which ones have overstayed their welcome.

Turning a Deal Stage Into a Weighted Forecast

A stage count tells you volume. It doesn't tell you revenue, because not every deal in "negotiation" is equally likely to close. That's what HubSpot's Weighted Pipeline Forecast report solves, by multiplying each deal's amount by the win probability tied to its current stage, then summing the result across the pipeline.

Pair it with the Forecast Category report, which groups the same deals by how a rep has manually tagged them, commit, best case, or pipeline, and you get two independent reads on the same number. When the weighted total and the rep's own commit number disagree by a wide margin, that gap is usually the first thing worth asking about in a pipeline review, not the total itself.

Neither report fixes a bad input. Recent benchmarking puts consistent CRM field population at only 60 to 70 percent across B2B organizations, which means a probability weighted total is frequently built on deals missing the exact fields, confirmed budget, a named decision maker, a realistic close date, that the probability already assumes are true.

Sales Velocity: The Number That Ties the Dashboard Together

Deal Velocity in HubSpot answers one question: how many days a deal takes to close. Sales velocity, the broader metric most RevOps teams track alongside it, folds in three more variables so you can see what's actually driving that number up or down.

The formula multiplies the number of qualified opportunities by your win rate and average deal size, then divides by the average sales cycle length in days. The result is the dollar value your pipeline generates per day, and it moves if any one input changes, more qualified opportunities, a higher win rate, bigger deals, or a shorter cycle.

Benchmarks vary enough by industry that a single target number is close to useless. One widely cited benchmark set puts SaaS at a 67 day average cycle with a 22 percent win rate, financial services at 89 days with an 18 percent win rate, and enterprise deals above 50,000 dollars running 135 days or longer with win rates as low as 12 percent. Track velocity against your own last four quarters before you borrow someone else's number.

Win Rate and the Pipeline Waterfall Report

Win rate is simple to calculate and easy to read wrong. HubSpot's Deals Won & Lost report breaks it out by rep or team, but a rate alone doesn't say whether deals are being lost to a competitor, a budget freeze, or a champion who went quiet. A pipeline full of deals nobody has closed out inflates the denominator with opportunities that were never really live, which flatters the number for the wrong reason.

The Deal Pipeline Waterfall report fills that gap by tracking how pipeline value actually moved during a period, sorted into created, pushed, pulled forward, increased, decreased, lost, and won. A pipeline that looks flat on a stage count view can still be churning underneath, with deals getting pushed a quarter at the same rate new ones get created. That's the pattern a stage report alone never shows.

Add a required loss reason field to your HubSpot deal stages, and the Won & Lost report turns from a scoreboard into a diagnosis. Every lost deal now carries a reason instead of just a date, competitor, budget, timing, or no decision, so a sales manager can see which problem is actually costing deals this quarter.

Why the Same Dashboard Tells Two Different Stories

Two reps can look at the same pipeline dashboard and read it completely differently, and the reason is rarely the report itself. It's whether the deals behind it were logged the week they happened or reconstructed from memory two weeks later, after a demo, a LinkedIn message, and three follow ups already happened off the record.

A stage conversion rate built on deals added late is a rate built on whichever deals a rep remembered to log, not the ones that actually existed. The dashboard can look stable quarter to quarter while the underlying records quietly rot underneath it.

The fix starts earlier than the report, at the point a contact or a company first gets added to your CRM. LeadLx adds a prospect to your CRM in one click from their LinkedIn profile or company page, the moment a rep finds them, instead of leaving that record for an end of week batch of manual entries typed from memory. A dashboard built on records that were current the day they were created is a dashboard worth trusting the day you pull it.

Building Your First HubSpot Pipeline Dashboard

Start with three reports, not ten. Pin Deal Funnel for stage counts, Time in Deal Stage for stalls, and Weighted Pipeline Forecast for the revenue number leadership actually asks about. Add Deals Won & Lost once loss reasons are mandatory, and the Deal Pipeline Waterfall once you're reviewing pipeline weekly instead of once a quarter.

Before you trust any of it, check the thing none of these reports measure directly, how current the deal and contact data behind them actually is. A dashboard inherits every shortcut a rep took logging a deal, including the one where a contact got added a week after the conversation actually happened. LeadLx's free plan is a reasonable place to start if closing that one gap is what's holding your dashboard back.

None of this replaces the basic distinction between a pipeline and the demand that feeds it. See how a sales pipeline differs from a sales funnel if the dashboard you're building is starting to answer a different question than the one leadership is actually asking.

Keep reading.

Get the full picture
before your next call.