HubSpot funnel report: the complete guide

If you don't know where your pipeline is leaking, you're guessing. HubSpot funnel reports show you exactly where contacts drop off, what percentage moves forward at each stage, and where to focus your time. This guide covers how to build one, read the numbers, and act on what you find.

What is a HubSpot funnel report?

A funnel report in HubSpot is a visualization that shows how many contacts, deals, or companies pass through a defined series of stages, along with the conversion rate between each stage.

Think of it as a measurement tool for your pipeline. You define the stages (e.g., Lead → MQL → SQL → Opportunity → Customer), HubSpot counts how many records reach each stage, and it calculates the drop-off between them.

The result is a bar chart showing:

• Volume: how many records reached each stage

• Conversion rates: what percentage moved from one stage to the next

• Drop-off: the absolute and relative number of records lost at each transition

Funnel reports vs. pipeline reports

These are often confused. Here's the difference:

A pipeline report shows where your current deals are sitting right now across deal stages. It's a snapshot of your active pipeline.

A funnel report shows how deals (or contacts) have moved over time. It shows what percentage made it through each transition. That makes it a process efficiency report.

Both are useful. But if you want to understand why you're winning or losing, the funnel report gives you more actionable data.

Who can use HubSpot funnel reports?

Funnel reports are available on:

• Marketing Hub Professional and Enterprise: contact and lifecycle stage funnels

• Sales Hub Professional and Enterprise: deal stage funnels

• CRM Suite Professional and Enterprise: both

They're not available on Free or Starter plans. If you're on Starter, you'll need to upgrade or build a manual approximation with other report types.

The two types of HubSpot funnel reports

Before you build anything, understand the difference between the two funnel report modes. This is where most people get confused.

"All stages" mode

A contact or deal is counted at each stage only if it passed through all previous stages in order.

Example: If your funnel is Lead → MQL → SQL, a contact who went directly from Lead to SQL (skipping MQL) would not appear in the MQL bar.

Use this when your process is strictly linear and you want to measure how well your full sequence works.

"Any stage" mode

A contact or deal is counted at each stage if it has ever reached that stage, regardless of whether it went through previous stages.

Example: That same contact who skipped MQL would appear in both the Lead and SQL bars.

Use this for a more complete picture of total reach at each stage, regardless of how they got there.

Neither is inherently better. They answer different questions. Most teams should start with "All stages" to find actual process leaks, then use "Any stages" to understand total throughput.

How to create a funnel report in HubSpot

Here's how to build a funnel report from scratch.

Step 1: Go to Reports

Navigate to Reports in the top navigation. Click Create report in the top right.

Step 2: Choose funnel report

In the report library, scroll to Funnel or search for it. Select Funnel from the templates. You'll see options for contacts, deals, or companies. Choose the one that matches your goal.

Step 3: Define your stages

This is the most important part. Add the stages you want to track in sequence.

For a contact lifecycle funnel, your stages might be:

• Subscriber → Lead → Marketing Qualified Lead → Sales Qualified Lead → Opportunity → Customer

For a deal stage funnel, you'd use your actual deal pipeline stages:

• Discovery call scheduled → Demo completed → Proposal sent → Contract sent → Closed Won

You can add up to 10 stages per funnel report.

Important: HubSpot only counts a contact or deal in a stage if they have a timestamp for that stage. Make sure your lifecycle stages and deal stages are actually being stamped in your CRM. Otherwise your funnel data will be inaccurate.

Step 4: Set the date range

Specify the time period you want to analyze. I recommend starting with last 90 days to get enough volume. If your sales cycle is long, go to 6 or 12 months.

The date range applies to when contacts entered the first stage. You're looking at cohorts, not all-time totals.

Step 5: Choose your mode

Select "All stages" or "Any stages" as described above.

Step 6: Apply filters (optional)

You can filter the funnel by any contact or deal property. Common ones: lead source (to compare channel performance), contact owner (to compare reps), industry or company size (to see which segments convert better), and date of creation (to track cohorts over time).

Step 7: Save and add to dashboard

Give the report a descriptive name (e.g., "Contact lifecycle funnel - Q1 2025") and save it. Add it to your main sales or marketing dashboard so it's visible at a glance.

How to read a HubSpot funnel report

Once you've built the report, here's what to look at.

The bar chart

Each bar represents a stage. The height shows the count. The number inside or below the bar shows both the count and the conversion rate from the previous stage.

A healthy funnel gets progressively smaller from left to right. That's normal. What you're looking for are dramatic drops.

Conversion rates between stages

HubSpot shows the percentage conversion between adjacent stages. If you're converting 60% of leads to MQLs, that's a fact. Whether that's good or bad depends on your industry, business model, and historical baseline.

That said, here are rough benchmarks to calibrate against. Lead to MQL: 20-40% is common for inbound-heavy businesses. MQL to SQL: 30-50% is healthy. SQL to Opportunity: 40-70% (a big drop here usually means sales qualification is off). Opportunity to Closed Won: 20-40% is typical for B2B SaaS.

Drop-off analysis

The most valuable data isn't the conversion rate. It's the drop-off count. If you lose 500 leads at the MQL stage, that's a $X problem. Calculate the revenue impact of fixing that stage. That gives you a prioritized roadmap.

How to break down a funnel report by property

One of the most useful features of HubSpot's funnel reports is breakdown by property. It lets you visualize your funnel segmented by a specific contact or deal property, all in a single view.

Instead of building five separate filtered funnels to compare channels, you can add a breakdown and see all channels side by side in the same chart.

What breakdown by property does

When you apply a breakdown, HubSpot splits each funnel stage into segments based on the property values you choose. For example, if you break down by Lead source, each bar gets split into organic search, paid ads, direct, email, social media, and so on.

This makes it immediately obvious whether organic leads convert better than paid leads. You don't have to leave the report.

How to add a breakdown in HubSpot

In the funnel report builder (the new journey funnel builder):

1. Build your funnel stages as normal 2. In the right panel, look for the Breakdown or Group by option 3. Select the property you want to break down by (e.g., Lead source, Deal owner, Industry, Pipeline) 4. Run the report. Each stage bar will now be segmented by property value

Good properties to break down by: lead source (end-to-end channel performance), deal owner (which reps close at higher rates), industry or company size (which segments convert better), and pipeline (if you run multiple pipelines).

Breakdown vs. filter: what's the difference?

These are easy to confuse. A filter restricts the data to records matching a condition (e.g., only contacts where Lead source = Organic). A breakdown shows all records but segments them visually by property value (e.g., all contacts, with each bar split by Lead source). Use a filter to isolate one segment. Use a breakdown to compare multiple segments at once.

What to do with your funnel data

Here's how to actually use what you find.

High drop-off at Lead → MQL

This usually means you're attracting the wrong traffic, or your MQL definition is too strict. Check whether your leads are coming from channels that match your ICP, whether your MQL scoring is cutting good leads too aggressively, and whether your nurture sequences are moving people forward fast enough. Fixes: tighten paid campaign targeting, improve nurture emails, revisit your lead scoring setup in HubSpot.

High drop-off at MQL → SQL

This is a sales-marketing handoff problem. Either marketing is sending over leads that sales doesn't think are ready, or sales isn't following up fast enough.

Fixes: agree on the SQL definition in a written SLA, check how quickly sales is responding to MQL handoffs (HubSpot task due dates help here), and review what MQLs are doing before the handoff happens.

High drop-off at Opportunity → Closed Won

This is a sales execution problem. The lead got far enough to be considered serious, but something broke down in the sales process.

Fixes: run deal stage duration reports to see where deals stall, listen to call recordings from lost deals, and do a win/loss analysis on deal properties.

Funnel reports for deal stages vs. lifecycle stages

You can build funnel reports for both deal stages and lifecycle stages. Here's when to use each:

Lifecycle stage funnels are best for tracking the full marketing and sales process from awareness to customer. They span the entire revenue cycle and give you a marketing-to-revenue view.

Deal stage funnels are best for analyzing sales process efficiency. They're more granular and tied to specific pipeline performance.

Most mature revenue operations teams use both: a lifecycle funnel for executive reporting and channel analysis, and a deal stage funnel for sales team coaching and process improvement.

Common mistakes with HubSpot funnel reports

Using funnel reports with dirty data

Funnel reports are only as good as your stage timestamps. If your team is manually updating lifecycle stages or deal stages without a reliable process, your funnel will be full of holes.

Before building funnel reports, audit your data. Check what percentage of your contacts have lifecycle stage dates populated. If it's under 70%, fix the data hygiene issue first.

Ignoring the time dimension

A snapshot funnel is useful, but comparing funnels over time is where it gets powerful. Build the same funnel for Q1 vs. Q2 and look at how conversion rates changed. That's how you measure whether your improvements are actually working.

Treating the funnel as a linear process

Most customers don't follow a clean A→B→C path. They loop back, re-engage, skip stages. "All stages" mode will show a cleaner picture that may be misleading for complex buying cycles. Use "Any stages" to account for this.

Not segmenting

An aggregate funnel hides more than it reveals. Always break your funnel down by at least one or two dimensions: lead source, rep, industry, deal size. The aggregate conversion rate is an average of very different performances underneath.

Integrating funnel reports into your regular process

A funnel report you look at once is decoration. Make it a regular habit. Every week, check your deal stage funnel during the sales team meeting and flag any stage dropping week-over-week. Every month, review the full lifecycle funnel by channel with marketing and reallocate budget toward what converts best. Every quarter, compare funnel performance to the previous quarter and set conversion rate targets per stage. Add your most important reports to a shared dashboard so both teams are always working from the same numbers.

HubSpot funnel reports and Hublead

If you're using Hublead to capture leads from LinkedIn directly into HubSpot, funnel reports become even more useful. You can filter your funnel specifically by contacts that came in through LinkedIn prospecting and see exactly how they convert compared to other sources.

This kind of channel-level funnel analysis is what helps you decide whether LinkedIn outreach is worth doubling down on. Or whether to shift effort elsewhere. See the full HubSpot LinkedIn integration guide to set this up.

Legacy funnel reports vs. the new journey funnel builder

HubSpot has two funnel report systems: the legacy funnel builder (older) and the new journey funnel builder (current). If you've been using HubSpot for a while, you may have reports built in the legacy system that work differently.

The legacy funnel builder

The legacy builder had two modes: "All stages" and "Any stages" (described earlier in this guide). Key characteristics:

Events only needed to occur within the date range, with no sequential ordering required. There were no date range limits. Contacts could complete stages out of order and still be counted at all stages.

The new journey funnel builder

The new builder (currently in beta, rolling out to all accounts) works differently:

• Stage completion must be sequential: if a contact skips stage 2 and goes directly to stage 3, they won't be counted in stage 2

• Maximum 5-year lookback period (may be shorter for high-volume accounts)

• Optional stages: you can mark any stage as optional, meaning contacts don't have to pass through it to continue

• AI-generated reports: use Breeze AI to describe the funnel you want in plain language and HubSpot will build it

Why your numbers might look different

If your account has migrated to the new builder, you may see lower counts at each stage. This is expected. The new builder requires sequential stage completion, so contacts who completed stages out of order will now be excluded from intermediate stages.

If your counts dropped significantly, look at how many contacts were completing stages out of order. Use the optional stages feature for stages that are commonly skipped. And adjust your date range since the new builder is more precise about when contacts entered each stage.