TL;DR
- Six funnel stages, one template: Visitor → Lead → MQL → SQL → Opportunity → Closed-Won. Each stage has a metric, a formula, a benchmark, and a diagnostic signal for when conversion falls out of range.
- Conversion benchmarks that vary by segment: MQL-to-SQL averages 13–22% overall; SQL-to-Opportunity runs 30–50%; Opportunity-to-Close lands at 20–35% depending on ACV and sales motion.
- The bottleneck is almost always MQL-to-SQL: This stage is where the largest volume of pipeline is routinely lost. Improving it by five percentage points can lift revenue by up to 18% without adding a dollar of top-of-funnel spend.
- Pipeline velocity ties it together: Volume, deal size, win rate, and cycle length combine into one composite signal that diagnoses funnel health faster than any single stage metric.
- Dashboard structure matters as much as metric selection: The most useful funnel dashboards show stage-by-stage volume, conversion rate, and time-in-stage together — so you can see whether a problem is a volume issue, a quality issue, or a speed issue.
A marketing funnel metrics template answers two questions that most revenue teams cannot answer quickly: where exactly is pipeline being lost, and what is causing the loss. Without a consistent template — defined stages, standard formulas, agreed benchmarks — teams measure different things across different quarters and spend more time arguing about the data than acting on it.
This template covers the complete B2B marketing and sales funnel from anonymous website visitor to closed revenue. Each stage includes the metric definition, the calculation, 2026 benchmarks by company type, and the diagnostic action each metric should trigger when it moves outside range. The final section covers how to structure a working funnel dashboard and what to watch each week.
Benchmarks in this post draw on research from HubSpot, First Page Sage, Gradient Works, and SerpSculpt's B2B conversion rate dataset. All figures reflect B2B SaaS unless otherwise noted.
How to Use This Template
The template is organized into six funnel stages. For each stage, you will find:
- Stage definition — what qualifies a record for this stage
- Primary metric — the conversion rate that measures throughput into the next stage
- Formula — the exact calculation with no ambiguity
- Volume metric — the count of records at this stage in the measurement period
- Benchmark table — median, top-quartile, and warning thresholds
- Diagnostic signal — what a deviation from benchmark means and what to do
Measure every stage on a rolling 90-day basis for the conversion rate, and weekly for volume. A single anomalous week does not indicate a structural problem. A four-week trend does.
For teams building funnel reporting for the first time: start by instrumenting the two middle stages — MQL-to-SQL and SQL-to-Opportunity — before perfecting top-of-funnel visitor tracking. Middle-of-funnel is where the most recoverable revenue is lost, and it is the fastest place to create impact.
Stage 1: Visitor to Lead
Stage Definition
A visitor is any unique user session on your website or landing page in the measurement period, regardless of source. A lead is a visitor who has submitted identifying information — name, email address, company — through a form, chat, or direct inbound inquiry. The visitor-to-lead conversion does not imply any qualification; it measures whether website traffic is converting to identifiable contacts at all.
Primary metric: Visitor-to-Lead Conversion Rate
Formula: (New leads in period ÷ total unique visitors in period) × 100
Supporting metrics at this stage:
- Total unique visitors by channel (organic, paid, direct, referral)
- New leads created by source
- Cost per lead by channel
- Lead-to-MQL rate (signals form quality and ICP fit of inbound traffic)
| Segment | Median Rate | Top Quartile | Warning Below |
|---|---|---|---|
| B2B SaaS (all segments) | 1.5–2.5% | 3.5%+ | Below 1.0% |
| SMB-focused (self-serve) | 2.5–4.0% | 5.0%+ | Below 1.5% |
| Enterprise (demo-gated) | 0.8–1.5% | 2.0%+ | Below 0.5% |
| Organic / SEO traffic only | 2.0–3.0% | 4.5%+ | Below 1.2% |
Diagnostic signal: A low visitor-to-lead rate is almost always a conversion rate optimization (CRO) problem, not a traffic problem. Check form placement, CTA specificity, and landing page message-to-offer alignment before adding more spend. A high visitor-to-lead rate with a low lead-to-MQL rate downstream means the traffic is converting but is poorly qualified — revisit channel targeting or landing page copy that is attracting the wrong personas.
Stage 2: Lead to MQL
Stage Definition
A Marketing Qualified Lead (MQL) is a lead that meets two criteria simultaneously: it fits the Ideal Customer Profile (ICP) on firmographic dimensions — industry, company size, job title — and it has demonstrated sufficient engagement to warrant sales attention. Engagement signals vary by team but typically include two or more of: demo request, pricing page visit, email click sequence, content download, or repeat site visits within a short window.
The MQL definition should be documented, version-controlled, and reviewed quarterly. Undocumented MQL criteria is the single most common source of marketing-sales alignment failure.
Primary metric: Lead-to-MQL Conversion Rate
Formula: (MQLs created in period ÷ total leads created in period) × 100
Supporting metrics at this stage:
- MQL volume by source channel
- Cost per MQL by channel
- MQL scoring distribution (are leads barely clearing the threshold or well above it?)
- Time from lead creation to MQL designation
| Segment | Median Rate | Top Quartile | Warning Below |
|---|---|---|---|
| B2B SaaS (all segments) | 26–35% | 42%+ | Below 18% |
| Inbound-led (content, SEO) | 35–45% | 50%+ | Below 25% |
| Outbound / paid-led | 18–28% | 35%+ | Below 12% |
| Event / partner-sourced | 30–42% | 50%+ | Below 20% |
Diagnostic signal: A lead-to-MQL rate above 50% at scale typically means the scoring threshold is too loose — most of your leads are qualifying, which defeats the purpose of qualification. Below 18% usually means either the traffic mix is attracting off-ICP visitors or the scoring model is too strict and suppressing valid pipeline. Run a cohort analysis: compare the lead-to-MQL rate of each source channel. If one channel has 60% conversion and another has 8%, the problem is channel mix, not the scoring model itself.
Stage 3: MQL to SQL — The Critical Handoff
Stage Definition
A Sales Qualified Lead (SQL) is an MQL that sales has engaged directly and confirmed meets real opportunity criteria. The qualification typically uses a BANT framework (Budget, Authority, Need, Timeline) or a variant like MEDDIC or SPICED. The SQL designation signals that sales is committing to pursue this lead actively — it is a resource allocation decision, not a passive handoff.
Some teams insert a Sales Accepted Lead (SAL) stage between MQL and SQL. The SAL marks the moment sales has reviewed and accepted the lead from marketing before qualifying it. SAL rates reveal how often sales rejects marketing's judgment — and that number is diagnostic data that most teams avoid measuring.
Primary metric: MQL-to-SQL Conversion Rate
Formula: (SQLs created in period ÷ MQLs created in the same or prior period, adjusted for lag) × 100
Supporting metrics at this stage:
- SAL rate (if applicable): MQLs accepted by sales without rejection
- MQL rejection rate and rejection reason codes
- Time from MQL to first sales contact (SLA compliance)
- MQL-to-SQL rate by source channel (identifies which channels produce sales-ready leads)
- Cost per SQL by channel
| Segment | Median Rate | Top Quartile | Warning Below |
|---|---|---|---|
| B2B SaaS (all segments) | 13–22% | 30%+ | Below 10% |
| SMB-focused (<$10K ACV) | 18–25% | 35%+ | Below 12% |
| Mid-market ($10K–$100K ACV) | 13–20% | 28%+ | Below 10% |
| Enterprise ($100K+ ACV) | 10–18% | 25%+ | Below 8% |
| SEO-sourced MQLs | 25–40% | 50%+ | Below 18% |
Why this stage is the highest-leverage point in the funnel: MQL-to-SQL is the stage where marketing's work is evaluated by sales. A five-percentage-point improvement here — from 15% to 20% — increases SQL volume by 33% without a dollar of additional spend. Research suggests this improvement can translate to 15–18% more revenue at constant close rates. The inverse is equally important: a declining MQL-to-SQL rate is an early warning signal, visible months before it shows up in revenue shortfalls.
Diagnostic signal: If MQL-to-SQL falls below 10%, the most common causes are misaligned ICP definitions between marketing and sales, lead scoring that weights engagement over fit, or excessive SLA lag where hot leads cool before first contact. Run a sample audit: have sales review 20 to 30 recent MQLs that were rejected and classify the rejection reason. If more than 60% are rejected for company size or industry fit, the scoring model needs a fit-weighting increase. If rejection is primarily for "no need" or "wrong timing," the engagement signals are firing on informational intent rather than buying intent.
Stage 4: SQL to Opportunity
Stage Definition
An Opportunity is an SQL that has been developed into an active deal — meaning a decision-maker has been identified, a business need has been confirmed, and the deal has been assigned a value and an expected close date. An opportunity represents a genuine revenue event, not just a sales conversation. Converting an SQL to an opportunity requires a successful discovery call or initial meeting that confirms real purchase potential.
Primary metric: SQL-to-Opportunity Conversion Rate
Formula: (New opportunities created in period ÷ SQLs created in the same or prior period, adjusted for conversion lag) × 100
Supporting metrics at this stage:
- Average deal size of new opportunities (is the pipeline representative of target ACV?)
- Time from SQL to opportunity creation (discovery efficiency)
- Pipeline created by sales rep (identifies rep-level conversion variance)
- Opportunity creation rate by lead source (which channels produce deals, not just leads)
| Segment | Median Rate | Top Quartile | Warning Below |
|---|---|---|---|
| B2B SaaS (all segments) | 30–50% | 55%+ | Below 25% |
| SDR-sourced SQLs | 40–55% | 60%+ | Below 30% |
| Inbound-sourced SQLs | 35–50% | 58%+ | Below 28% |
| Enterprise (>$100K ACV) | 28–42% | 50%+ | Below 22% |
Diagnostic signal: SQL-to-opportunity rates below 25% typically indicate that SQLs are being created too liberally — sales is accepting contacts that have not confirmed real intent, inflating the SQL count and masking the real problem. Alternatively, reps are conducting poor discovery calls and failing to surface latent need. Identify whether the problem is a definition issue (SQLs should be harder to create) or an execution issue (reps need discovery coaching). A strong signal for the latter is high SQL volume but low average deal size on resulting opportunities.
Stage 5: Opportunity to Closed-Won
Stage Definition
The win rate measures the percentage of active opportunities that result in a signed contract and recognized revenue. It is the final conversion stage and the most visible number in most sales teams — but it is the wrong stage to optimize first. Win rate is downstream of every upstream qualification decision. Improving it by five points through better late-stage deal management is harder and more expensive than improving it by improving SQL quality earlier in the funnel.
Primary metric: Opportunity-to-Closed-Won Rate (Win Rate)
Formula: (Closed-won opportunities in period ÷ total opportunities closed in period — won and lost) × 100
Supporting metrics at this stage:
- Average sales cycle length from opportunity creation to close
- Win/loss reason codes (standardized and CRM-required)
- Closed-lost rate by competitive displacement vs. no decision vs. budget freeze
- Average deal size: closed-won vs. closed-lost (are you winning the right deals?)
- Win rate by sales rep (identifies coaching opportunities and attribution accuracy)
| Segment | Median Rate | Top Quartile | Warning Below |
|---|---|---|---|
| B2B SaaS (all segments) | 20–35% | 40%+ | Below 18% |
| SMB-focused (<$10K ACV) | 32–45% | 50%+ | Below 25% |
| Mid-market ($10K–$100K ACV) | 22–32% | 38%+ | Below 18% |
| Enterprise ($100K+ ACV) | 18–31% | 35%+ | Below 15% |
| Event-sourced opportunities | 35–45% | 50%+ | Below 28% |
Diagnostic signal: Win rates below 18% across B2B SaaS signal a qualification problem more often than a closing problem. If opportunities are being created with incomplete discovery — deals without a confirmed champion, a defined use case, or a realistic budget — the win rate will reflect that sloppiness. Require mandatory win/loss reason codes on every closed opportunity, without exception. Review the top three loss reasons monthly. If "no budget" and "no decision" together account for more than 50% of losses, the opportunity stage qualification criteria need tightening. If "competitive loss" dominates, the product narrative or differentiation story requires attention.
Full Funnel Benchmark Summary Table
The table below consolidates the conversion rate benchmarks for every stage. Use this as the reference view when conducting quarterly funnel audits or presenting pipeline health to leadership.
| Funnel Stage | Metric | Median (B2B SaaS) | Top Quartile | Warning |
|---|---|---|---|---|
| Visitor → Lead | Visitor-to-Lead Rate | 1.5–2.5% | 3.5%+ | <1.0% |
| Lead → MQL | Lead-to-MQL Rate | 26–35% | 42%+ | <18% |
| MQL → SQL | MQL-to-SQL Rate | 13–22% | 30%+ | <10% |
| SQL → Opportunity | SQL-to-Opp Rate | 30–50% | 55%+ | <25% |
| Opportunity → Closed-Won | Win Rate | 20–35% | 40%+ | <18% |
| Visitor → Closed-Won | End-to-End Rate | 0.02–0.08% | 0.12%+ | <0.01% |
The end-to-end visitor-to-customer rate looks vanishingly small because it compounds all five conversion stages. At median performance across every stage, roughly 2 out of every 10,000 website visitors become paying customers. Improving any single stage's conversion rate by even a few points compounds materially through the rest of the funnel.
Pipeline Velocity: The Composite Funnel Health Metric
Stage-by-stage conversion rates tell you where the funnel is leaking. Pipeline velocity tells you how efficiently the funnel is generating revenue as a whole. It is the single most useful metric for marketing and sales alignment because it captures all four inputs — volume, quality, win rate, and speed — in one number.
Formula:
Example: 60 active opportunities × $35,000 average deal size × 26% win rate ÷ 85-day cycle = $7,200 revenue per day.
Pipeline velocity improves when any of the four inputs improves. The most efficient improvements:
- Increasing opportunity count — requires upstream funnel improvement (MQL volume, MQL-to-SQL rate)
- Increasing average deal size — requires better ICP targeting upstream and better discovery execution at SQL stage
- Improving win rate — requires better qualification (upstream) and stronger deal execution (downstream)
- Shortening sales cycle — requires faster SLA at MQL-to-SQL handoff, cleaner discovery, and better champion development in active deals
Track pipeline velocity weekly. A declining velocity number almost always leads a revenue shortfall by four to six weeks — early enough to course-correct before it hits the income statement.
Building Your Funnel Metrics Dashboard
What Belongs in the Dashboard
A working funnel dashboard has three layers: a headline view, a stage-detail view, and a channel-breakout view. Each layer serves a different audience and a different question.
Headline view (for leadership review — weekly):
- Pipeline velocity vs. prior period
- MQL volume vs. plan
- MQL-to-SQL conversion rate
- Open pipeline value vs. coverage target
- Closed-won revenue vs. plan
Stage-detail view (for marketing ops and demand gen — weekly):
- Stage-by-stage volume counts (waterfall view)
- Conversion rate at each stage vs. prior period and benchmark
- Time-in-stage average (is anything slowing down?)
- Stage conversion trend over rolling 12 weeks
Channel-breakout view (for demand gen — biweekly):
- Leads, MQLs, SQLs, and opportunities by source channel
- Cost per MQL and cost per SQL by channel
- MQL-to-SQL rate by channel (identifies highest-quality sources)
- Marketing-sourced pipeline value by channel
Common Dashboard Failures to Avoid
Tracking volume without conversion rates. Reporting that MQL volume increased 20% month-over-month is incomplete without the corresponding MQL-to-SQL rate. Volume improvement that degrades conversion quality is not progress — it is cost inefficiency disguised as growth.
Using the wrong time basis for conversion rates. MQL-to-SQL rates should be calculated on a lag-adjusted cohort basis — MQLs created in month N compared to SQLs created from that cohort in months N through N+2, depending on your sales cycle. Using simple period-over-period conversion (MQLs created this month vs. SQLs created this month) introduces timing noise that makes the metric meaningless.
Reporting without benchmarks. A 16% MQL-to-SQL rate looks different depending on your segment, ACV, and sales motion. Every metric on the dashboard should have a benchmark range attached so the number can be immediately contextualized as healthy, at risk, or critical.
Building the dashboard for reporting rather than decisions. The most common failure is a dashboard that answers the question "what happened?" rather than "what do we do?" Every metric should have a stated decision threshold — the value at which the metric triggers a specific action. Without that threshold, the dashboard is a history report, not an operating tool.
For the broader data infrastructure context — how funnel data connects to a complete operating system — see the framework in The Revenue Operations Framework: A Complete Guide.