Skip to content
Tutorials Center
My learning

Topics

Lesson 30 of 37 ยท Reporting and Dashboards

Funnels, Conversion Rates and Sales Forecasting

Learn HubSpot funnel reports, stage-to-stage conversion, sales velocity and weighted deal forecasts, and how to calculate each metric yourself with runnable Python examples.

Two questions drive most sales reporting: how well do we convert? and what will we close this quarter? HubSpot answers them with funnel reports (conversion between lifecycle or deal stages) and the forecast tool (a projection from open deals). Understanding the arithmetic behind both lets you question numbers that look too good.

HubSpot cannot run on this site. The Python snippets are stand-ins that compute the metrics from sample data. Forecast tools are included in Sales Hub Professional and above; check your plan.

Funnel reports

A funnel report counts how many records reached each stage in a sequence and the percent that moved to the next. You can build funnels from lifecycle stages (Lead, MQL, SQL, Opportunity, Customer) or from deal stages, filtered by a time window and, for contact funnels, by creation date cohort.

Two details change the answer:

  • Cohort versus period: a cohort funnel follows records created in a given period; a period funnel counts stage entries that happened in the period regardless of when records were created.
  • Skipped stages: a deal that jumps from stage 1 to stage 4 may or may not count as having passed stages 2 and 3, depending on the report's logic.

Funnel metrics

Stage conversion Next stage divided by this stage
Overall conversion Won divided by first stage
Time in stage Where deals wait
Forecast Amount times probability

Know the cohort rule

1 / 2

Stage conversion

Python Stage-to-stage and overall conversion

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Look for the stage with the lowest conversion: that is your biggest leak, and the best place to experiment.

Sales velocity

A well-known summary metric combines four numbers:

velocity = (open opportunities x win rate x average deal size) / sales cycle length (days)

It estimates revenue per day. Improving any factor improves velocity.

Python Sales velocity and what-if

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Deal stage probability and weighted forecast

Each deal stage has a deal probability property (for example Qualified 20%, Proposal 60%, Contract sent 80%). A weighted amount is amount x probability, and the sum across open deals closing in a period is a weighted pipeline forecast. HubSpot's forecast tool also lets reps set a forecast category (Omitted, Pipeline, Best case, Commit, Closed won) and manager adjustments, which is often more accurate than probabilities because it reflects the rep's judgment.

Python Weighted forecast and forecast categories

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Quota attainment

Managers compare closed revenue (and the forecast) to quotas set per rep or team. A simple attainment is closed / quota; a projected attainment adds weighted open deals.

Python Attainment per rep

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Forecasting cautions

  • Probabilities are averages; a single big deal either happens or does not.
  • Stale close dates inflate forecasts; use a workflow that flags deals whose close date has passed.
  • Compare past forecasts with outcomes to measure accuracy, not just the current number.
  • Keep stage definitions strict, or stage-based probabilities mean nothing.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. If 380 of 1000 leads become MQLs, the Lead-to-MQL conversion is...

    380 / 1000 = 38%.
  2. 2. Which change raises sales velocity?

    Velocity grows with opportunities, win rate and deal size, and shrinks with cycle length.
  3. 3. Why might a weighted forecast mislead?

    Averages smooth over lumpy outcomes and stale data inflates them.

Summary

  • Funnel reports show stage conversion; know whether they use cohorts or periods.
  • Sales velocity combines opportunities, win rate, deal size and cycle length.
  • Weighted forecasts and forecast categories project revenue; verify them against history.

Next: Private Apps and Authentication