How to Create Legacy Funnel Reports in HubSpot

How to Create Legacy Funnel Reports in HubSpot

If you’ve ever tried to pinpoint exactly where deals stall out in your HubSpot sales pipeline, you know how tough it can be. Vague metrics and disconnected reports make it nearly impossible to tell whether reps are struggling with qualification, proposals, or closing, and that lack of clarity doesn’t just slow you down; it undermines your ability to forecast and coach effectively.

That’s where HubSpot’s legacy funnel reports come in. They provide a clear, step-by-step view of how contacts or deals move through your funnel, so you can spot drop-offs, track conversion rates, and optimize handoffs among marketing, sales, and customer success. For lean RevOps teams juggling multiple pipelines, these reports offer a practical and consistent way to measure funnel health over time.

In this guide, you’ll learn what legacy funnel reports are, how they work behind the scenes, how to build one in your HubSpot portal, and how to use them to track performance across teams. We’ll also flag common setup mistakes that undermine reporting accuracy and show you how INSIDEA helps teams get it right from day one.

 

Master Legacy Funnel Reports to Analyze Historic Conversion Data

Legacy funnel reports are HubSpot’s original tool for visualizing how records move through stages in your CRM. Rather than a real-time dashboard, they offer a historical record of how many contacts or deals progress and where drop-offs occur. The format is simple but powerful: it shows conversions between each stage, both in absolute numbers and as percentages.

You’ll find legacy funnels under the Custom Reports Library, in the “Funnels” section. While HubSpot’s newer funnel builder offers more customization options, the legacy version still holds its own. Especially if your team relies on tried-and-true lifecycle stages or standard deal pipelines, these reports often deliver more consistent results because they preserve older field logic and familiar filters.

There are two primary types of legacy funnel reports:

  • Contact-based funnels: Track how contacts move through stages like Subscriber → Lead → MQL → SQL → Customer.
  • Deal-based funnels: Focus on deal pipeline movement, such as Appointment Scheduled → Qualified to Buy → Contract Sent → Closed Won.

Both rely on your CRM’s built-in timestamp data; they just report on different object types. To choose the right one, consider whether you’re tracking individuals or revenue motions.

 

How It Works Under the Hood

At a technical level, legacy funnel reports scan historical CRM data to see when a record first entered each stage. Using that timeline of stage entry dates, the report calculates how many records moved from one stage to the next during your selected time window.

To function correctly, your report needs the following input:

  • The object (Contacts or Deals).
  • A defined sequence of funnel stages.
  • A start and end date, generally based on when the record was created or when it changed stage.
  • Segmenting filters like sales pipeline, owner, geography, or customer type.

In return, the report gives you:

  • Volume per stage: How many made it to each step.
  • Conversion rates: Percentage of visitors who move to the next stage.
  • A cumulative funnel: Visual representation of progression and drop-offs.

One key caveat: legacy funnels only track the first time a deal or contact reaches a stage. That means if a deal bounces backward and regains progress later, that restart won’t show up. Also, for the data to be reliable, your records must follow a clear and linear stage order. Missing timestamps or skipped stages will throw off results.

You can customize these reports further by:

  • Adjusting conversion requirements, strict sequence vs. any path.
  • Setting time windows to historical or within a time period.
  • Including closed stages if you’re analyzing late-funnel performance.

 

Main Uses Inside HubSpot

Tracking Sales Pipeline Conversion

One of the most direct uses for legacy funnels is tracking how deals move through your sales pipeline. It’s invaluable when you need to unpack which stages are most prone to stalling, and why.

Let’s say you’re analyzing Q1 performance in the “New Business” pipeline. You filter by Create Date and see 400 deals started at “Appointment Scheduled,” but just 180 made it to “Closed Won.” That gives you a 45% overall conversion, and a clear case for dialing in rep coaching, tightening qualification criteria, or diagnosing delays in follow-up routines.

Monitoring Marketing-to-Sales Handoff

For marketers and RevOps, one of the hardest metrics to measure is the conversion rate from MQLs to customers. Legacy contact-based funnels are ideal for this because they rely on lifecycle stage timestamps, not pipeline entries.

Imagine filtering your funnel by source to compare paid vs. organic leads. If paid leads are converting from MQL to SQL at 5%, while organic’s at 12%, you’ve just uncovered an actionable insight for where to shift your budget.

Measuring Onboarding or Service Progression

Legacy funnels work just as well outside of sales. Many Customer Success teams use them to monitor how smoothly clients move through onboarding or implementation milestones.

Let’s say your funnel looks like Kickoff → Implementation → Go-Live. Your report shows 60 customers reached Implementation, but 20 never progressed after 30 days. That delay could point to gaps in training or capacity constraints, helping you flag risks and deploy resources where they’re most needed.

 

Common Setup Errors and Wrong Assumptions

Even power users trip up when building legacy funnel reports. These are a few of the pitfalls to watch for:

  • Mismatched stage order
    If your funnel doesn’t follow the actual pipeline or lifecycle sequence, your conversion data will be skewed. Double-check the stage order before building your report.
  • Wrong date range selection
    Using “Create Date” instead of “Stage Change Date” often overlooks long-cycle deals. For accurate conversion windows, choose “Entered stage date” as your filter.
  • Mixing pipelines in one report
    Don’t blend deals across pipelines with different stage definitions. That muddies the logic. Instead, create one report per pipeline and combine them on a dashboard.
  • Thinking re-entries are tracked
    Legacy funnels ignore repeat stage entries. If a deal circles back and re-enters a stage later, that second arrival won’t be counted. Use newer funnel tools or custom reports if this level of detail is essential.

 

Step-by-Step Setup or Use Guide

Before you dive in, confirm these requirements:

  • You’re using a Professional or Enterprise version of Marketing, Sales, or Service Hub.
  • All relevant contacts or deals use standard stages.
  • Stage change timestamps are reliably logged.

Step 1: Go to Reports
In your HubSpot main menu, head to Reports > Reports, then click “Create Report.”

Step 2: Select Legacy Funnels
Inside the custom report builder, scroll to the “Funnels” section and choose “Legacy funnel report.”

Step 3: Pick your object type
Select either “Contacts” or “Deals,” depending on what you’re analyzing.

Step 4: Define funnel flow logic
Choose whether to track “Contacts who converted in order” or those “who reached the final stage.” Use the strict setting when order matters.

Step 5: Add stages in sequence
Input your funnel or pipeline stages in the exact order they occur in HubSpot.

Step 6: Apply filters
Apply filters like Pipeline, Region, Deal Owner, or Time Range to focus your analysis.

Step 7: Set your date range
Choose your time window, such as “Last 90 Days” or “Q1”, based on reporting needs.

Step 8: Save and name your report
Give your report a name that’s easy to reference, like “North America Q2 Pipeline Funnel,” and save it to the appropriate dashboard.

Optional: You can toggle cumulative counts, filter for contacts who completed all stages, or modify logic for flexible summaries. If execs need a snapshot, using cumulative views often tells the clearest story.

 

Measuring Results in HubSpot

Once your report is up and running, schedule time each week to review it. Funnel data is rich with signals if you know where to look.

Here’s how to focus your analysis:

  • Stage-by-stage conversion rates reveal where friction happens: Are qualified leads stalling before demo? Are proposals converting?
  • Full funnel conversion helps track overall efficiency across the journey.
  • Stage volume trends show pipeline health by indicating whether lead flow is increasing or tapering.
  • Velocity tracking fills in crucial context. Pair your funnel report with velocity dashboards to measure time-in-stage.

Bring these into a shared dashboard so that sales leaders, RevOps, and marketing stakeholders stay aligned. Updating weekly keeps trends accurate and timely.

 

Short Example That Ties It Together

Say your sales team is preparing for a Q2 pipeline review. You pull a deal-based legacy funnel report for the “New Business” pipeline, selecting “Discovery Call,” “Contract Sent,” and “Closed Won.”

You filter the data by North America and set the date range to April 1 through June 30. Your funnel now shows:

  • 500 deals entered Discovery,
  • 300 made it to Contract Sent,
  • and 150 went Closed Won.

That breaks down to 60% conversion from Discovery to Contract, and 50% from Contract to Close, giving you a full-funnel conversion of 30%. A separate velocity report shows delays between Contract Sent and Close stretch past 10 days. So, you train reps to speed up follow-up and tighten proposal workflows. You’ll revisit the report next quarter to gauge the impact.

 

How INSIDEA Helps

If you’re unsure how to structure funnel stages, configure filters, or interpret conversion curves, you’re not alone. Legacy funnels are simple to build, but surprisingly easy to misread.

At INSIDEA, we help teams avoid common pitfalls by aligning reports with real-world processes. Whether you’re onboarding, auditing an existing instance, or building out RevOps infrastructure, we make sure your funnel logic, CRM data, and reporting layers speak the same language.

Our team supports:

  • Smooth HubSpot onboarding for Sales, Marketing, and Service.
  • Consistent reporting hygiene with clean data and stable automations.
  • Custom automations tailored to lifecycle and pipeline logic.
  • Dashboards that give leadership teams a unified, accurate view.

Need help getting your funnel reports right? Book a HubSpot strategy call or check out INSIDEA’s HubSpot consulting services

Jigar Thakker is a HubSpot Certified Expert and CBO at INSIDEA. With over 7 years of expertise in digital marketing and automation, Jigar specializes in optimizing RevOps strategies, helping businesses unlock their full potential. A HubSpot Community Champion, he is proficient in all HubSpot solutions, including Sales, Marketing, Service, CMS, and Operations Hubs. Jigar is dedicated to transforming your RevOps into a revenue-generating powerhouse, leveraging HubSpot’s unique capabilities to boost sales and marketing conversions.

The Award-Winning Team Is Ready.

Are You?

“At INSIDEA, it’s all about putting people first. Our top priority? You. Whether you’re part of our incredible team, a valued customer, or a trusted partner, your satisfaction always comes before anything else. We’re not just focused on meeting expectations; we’re here to exceed them and that’s what we take pride in!”

Pratik Thakker

Founder & CEO

Company-of-the-year

Featured In

Ready to take your marketing to the next level?

Book a demo and discovery call to get a look at:


By clicking next, you agree to receive communications from INSIDEA in accordance with our Privacy Policy.