DataHub · Revenue Operations

FY27-Q1 Pipeline Lookback

Full-quarter retrospective: January 26 – April 27, 2026. $21M target. 13 weeks. All figures sourced directly from HubSpot dashboard FY27-QL-Pipeline-Report.

Quarter FY27-Q1
Target $21,000,000
Actual $17,760,423
Attainment 84.6%
Source HubSpot portal 14552909
Generated May 4, 2026
🔴 Final — Closed Ended the quarter $3.24M short of target — 84.6% attainment
270 deals created · avg $105,717 · 103 closed won
Pipeline summary — FY27-Q1 final
QTD Pipeline Created
$17.76M
vs. $21M target — 84.6% attainment
Gap to Target
–$3.24M
Structural — not recoverable in final weeks
Weighted Pipeline
$4.22M
23.8% of unweighted — probability-adjusted
Deals Created
270
$105,717 avg deal size
Closed Won
103
38.1% of all deals created this quarter
Quarter weeks
13 of 13
Q1 complete April 27
Linear target
$21,000,000
100% of quarter
Actual vs. target
–$3,239,577
15.4% below target
Peak week
$2,886,200
Week of 3/9 — 4× avg run rate
Final 2-week avg
$772,500
vs. $1.62M/wk needed pace
Pipeline creation — weekly trend (Jan 26 – Apr 20, 2026)
$1.19M
1/26
$1.34M
2/9
$1.57M
2/23
$2.89M ▲ Peak
3/9
$1.02M
3/23
$1.13M
4/6
$845K ▼
4/20
$700K ▼
4/27

Bi-weekly aggregates from Pipeline Weekly by Source chart. The March 9 spike ($2.89M) was the quarter's outlier — roughly 4× the final-weeks run rate. Visible bars sum to ~$10.7M — the chart shows bi-weekly labeled bars, not all 13 weeks. Full QTD figure from Pipeline Stats: $17,760,423 across 270 deals.

Pipeline by source — QTD final
Source mix — $17,760,423 total
Inbound
$7,188,700
40.48% · marketing-sourced
Outbound
$5,505,000
31.0%
Events
$3,000,173
16.89%
Partner
$1,413,000
7.96%
Other
$653,550
3.68%
Source context
Inbound leads the mix at 40.48%
Marketing-sourced pipeline totaled $7,188,700 — the largest single source by dollar. Organic self-selection from 1K+ accounts and demo/product-tour conversions drove this. ICP report confirmed organic avg ACV at $119K — highest inbound channel.
Events contributed $3.0M — 16.89% of total pipeline
Events produced 16.89% of pipeline. The MQL/SAL audit found 99.4% of event MQLs auto-advanced to SAL with no intent gate, and only 7.8% had a deal attached. The Gartner Orlando batch drove the majority of event SAL volume in Q1.
Partner at 7.96% — underweighted for quality
Partner sourced $1.41M on just 15 deals with a 73% close rate and $180K avg ACV per ICP analysis — by far the highest-quality motion in the system. Warranting a dedicated BDR motion in Q2.
Marketing funnel — QTD final (from MQL/SAL audit + weekly stage charts)
Funnel stage volumes — QTD
MQL
~870est. from audit
est. from MQL/SAL audit
MQL → SAL: ~72% ✓ Well above 45% benchmark — but partly inflated by event/CS auto-acceptance (no qualification gate)
SAL
1,563gauge actual
QTD actuals per goal gauge
SAL → SQL: 15.4% ≈ 15% benchmark. 241 SQLs ÷ 1,563 SALs — at benchmark by quarter close, though mid-quarter snapshot (Apr 20) showed a much lower rate as BDR capacity was stretched. 838 high-fit SALs (fit ≥50) stalled with no deal created.
SQL
241
QTD actuals per goal gauge
SQL → SQO: ~79% ✓ Strong. Once meetings were booked, deal creation rate was healthy — the bottleneck is upstream.
SQO
129
QTD actuals per goal gauge
SAL→SQL: At benchmark by quarter close — but 838 high-fit SALs never progressed
SAL→SQL came in at 15.4% for the full quarter (241 SQLs ÷ 1,563 SALs) — essentially at the 15% benchmark. However, the mid-quarter snapshot at April 20 showed a significantly lower rate as BDR capacity was stretched by the Gartner Orlando batch. The more precise problem is not the overall conversion rate but what's underneath it: 838 high-fit SALs (fit ≥50) never got a deal created, and 262 high-intent SALs (demo/product tour) also stalled. BDR capacity was consumed by volume — events (309 stalled), Content Syndication (183), organic (138). At a 5% meeting rate on that stalled list alone, that's ~42 new SQLs — more than the quarter's total from new pipeline.
Funnel data source note: The Marketing Funnel Report widget on the dashboard returned "no data to show in this time frame." All funnel stage volumes above are sourced from the MQL/SAL audit (Apr 20) and goal gauge actuals from the weekly pipeline dashboard. The gauge actuals for SAL (1,563) and SQL (241) showed values equal to their gauge settings — verify these reflect true QTD actuals before citing to CMO.
Engagement signals — quarterly weekly trend summary
Demo & Product Tour Submissions
~350+
total across Q1 (est. from weekly chart)
Peak week: 63 (wk of 3/9) driven by Gartner events / paid search surge. Final weeks trended to 18–20/week. CTA change to demo-primary on homepage (late Apr) expected to sustain or increase volume in Q2. 82% of high-intent SALs stalled — submission volume alone is not the lever.
All Form Fills by Week
~2,600
total form submissions Q1 (est., excl. Content Syndication)
Using "All Forms by Lead Quality" figures which exclude CS leads. Peak: 657 in week of 3/9. Trended down to 244 in final week. The "All Form Fills by Week" chart inflates these totals by including CS contacts as form fills — those are counted separately under Content Syndication sourcing.
SALs Weekly — Fit Score
~1,563
QTD SALs entered (per gauge actual)
Peak week: 275 (wk of 3/16 — post-Gartner lag). Final weeks: 126–204. High-fit SAL volume was never the problem — 838 of those stalled without a deal. Full-quarter SAL→SQL came in at 15.4% (241 ÷ 1,563), at benchmark, though the mid-quarter rate was considerably lower as BDR capacity was stretched by event volume.
Critical findings — what drove the quarter
Finding 1 — SAL→SQL held at benchmark but 838 high-fit SALs stalled without a deal
15.4% SAL→SQL — 241 ÷ 1,563 — at benchmark 838 high-fit SALs stalled — no deal 262 high-intent SALs stalled Root cause verified by MQL/SAL audit
The full-quarter SAL→SQL rate of 15.4% lands at the 15% benchmark — the conversion rate itself held up. But 838 contacts with fit ≥50 never got a deal created, and another 262 had submitted a demo request or product tour (high intent = 100) and still stalled. The issue isn't the headline conversion rate — it's that BDR capacity was consumed by high-volume, low-quality event leads before high-fit contacts could be worked. No HubSpot stage-routing misconfiguration was involved — confirmed by the QTD audit.
Finding 2 — Events consumed BDR capacity without producing deals
464 event SALs Q1 99.4% auto-advanced — no qualification gate 7.8% deal attach rate 309 stalled high-fit event SALs
Events was the #1 SAL source at 35.6% of all SALs — but produced just 7.8% deal attachment. The Gartner Orlando cohort was mass-imported and mass-advanced to SAL in late February, creating the pipeline spike in 3/9 and then exhausting BDR capacity for the rest of the quarter. Without a qualification gate (fit ≥40 or high intent = 100), every attendee list import will repeat this pattern. Gartner London is Q2's first test of whether this has been fixed.
Finding 3 — The March 9 spike: most likely a paid search surge + Gartner Orlando actioning simultaneously
$2,886,200 pipeline wk of 3/9 — 4× run rate 657 form fills — quarter peak 63 demo/tour submissions — quarter peak 69 SQLs + 90 SQOs same window
The week of March 9 saw every funnel signal spike simultaneously — pipeline, form fills, demos, MQLs, SQLs, and SQOs all hit their quarter highs within a 2-week window. That pattern rules out a single-channel cause. The most likely explanation is two events compounding at the same time:

1. Paid search volume surge. The GUID c1d25565 PMax campaign was running without proper attribution throughout Q1. PMax campaigns can generate sudden bursts of form-fill volume when a new audience or creative starts performing — this would explain the 657 form fill peak and the demo submission spike. High form-fill volume translates to Path 2 MQL advancement, which would push the MQL and downstream SQL/SQO numbers up in the same window.

2. Gartner Orlando cohort being actioned by BDRs. The MQL/SAL audit confirmed a large Gartner Orlando batch was mass-imported and advanced to SAL in late February. The BDR team would have worked that list in early March — producing the SQL and SQO spike as meetings converted from the event cohort.

The post-3/9 crash confirms BDR capacity exhaustion, not organic demand decline. Pipeline dropped from $2.89M to $1.02M the following two weeks (3/23) and never recovered. If it were purely a paid demand spike, form fills and MQLs would have declined first. Instead, the funnel-wide collapse — including SALs dropping from 275 to 151 and SQOs from 90 to 29 — is the signature of a BDR team that hit their ceiling after working a concentrated burst of leads and had nothing left for the remainder of the quarter.
Finding 4 — Content Syndication: highest fit, lowest deal rate of any channel
199 CS MQLs · avg fit 68.1 — highest of any channel 100% MQL → SAL conversion 0.5% deal attach rate — 1 deal of 199
CS leads have the best firmographic fit in the system but were worked before being nurtured. The high-intent flag never fires for CS interactions (CS events aren't scored), so these contacts appear in the BDR queue with engagement scores of 20–30 — deprioritized behind higher-volume, lower-quality leads. The Q2 fix is a nurture-first sequencing approach and a dedicated CS BDR view, not a sourcing change. The channel itself is not broken.
Finding 5 — Paid Search: intent was real, but fit was weak
400 paid search MQLs · 70.8% high intent 19.5% negative fit 50.5% fit below 20 PMax GUID c1d25565 = primary driver of disqualifications
Paid Search produced genuine intent — 70.8% of contacts submitted a real form — but half had fit scores below 20. 58% of all paid search disqualifications trace to one unmapped PMax campaign GUID (c1d25565). The attribution fix was confirmed implemented by GrowthSpree (Pratik) in late Q1. The $34K ACV gap between Paid Search ($85K avg) and Organic ($119K avg) is structural — SMB company names dominate paid traffic. PMax is a scaling priority for Q2 but only after confirming the attribution is fixed.
Finding 6 — Organic was the cleanest channel and should be protected
520 organic MQLs · ~51% MQL→SAL — real qualification gate $119K avg ACV Enterprise names: Wells Fargo, Figma, Capital Group, Postbank
Organic was the only channel where the SAL acceptance rate reflected a real qualification decision. Fit scores were stronger, enterprise company names self-selected, and downstream conversion was comparatively better. BDR time on organic leads converts at a disproportionately higher rate — this must be protected as Q2 budget is allocated. Any reduction in organic investment compounds the pipeline gap.
Finding 7 — ICP threshold is ACV-based, not win-rate-based
Close rates ~10–12% across all size bands 1K+ employee deals avg $60K more per won deal Validated across 456 SQO/Closed Won deals
The 1,000-employee floor is not justified by close rate differences — win rates are statistically equal across size bands. The argument for the 1K+ threshold is revenue-per-BDR-hour. A won deal with a 1K+ company produces ~$60K more in ACV than a 250–999 company deal. This is the number to use when explaining BDR prioritization to the team. The ICP validation series across 5 HubSpot reports confirmed this conclusively.
Finding 8 — Multi-threading was near-zero: 92% of Discovery deals single-threaded
92% of Discovery-stage deals — 1 contact only Multi-threaded Closed Won deals avg 2.5+ contacts Average associated companies per deal: 1.07
Deals with a champion + one secondary stakeholder close at significantly higher ACV and win rate. But 92% of Q1 Discovery deals were single-threaded — one contact, one shot at the deal. Multi-threading is an AE responsibility once a deal is created, and the data shows it isn't happening consistently. This is a process and coaching opportunity for the AE team, not a data change.
Q2 setup — what Q1 unlocks for May–July 2026
1
Re-engage the 838 stalled high-fit SALs before generating new top-of-funnel
These are the highest-ROI leads in the system. At a 5% meeting rate, they produce ~42 new SQLs. Q2 LinkedIn Conversation Ads (ReMotion budget) are already scoped to target this list. Events (309), Content Syndication (183), and Organic (138) are the re-engagement priority order. The IDC report and new case study are the re-engagement assets. Run this list before any new paid top-of-funnel investment — the math is clear.
2
Gate Gartner London before the attendee list is uploaded
Gartner London replicates the exact conditions that created the Gartner Orlando problem. Require Fit ≥40 OR High Intent = 100 before any event contact advances to SAL. Two-queue the import: ICP-tier to BDR queue, below-threshold to nurture. This single process change prevents another 300+ SAL entries that consume BDR capacity without producing deals. Implement before the list is actioned.
3
Build the dedicated Content Syndication BDR view and nurture-first sequence
CS contacts have avg fit 68.1 — the best firmographic signal in the system — but they're invisible in the BDR queue. Q2 plan already includes a nurture-first approach for CS contacts. The execution detail: create a HubSpot view filtered to CS source + fit ≥50, assign manual first-touch sequences (not automated cadences), and add a CS interaction event (+15 pts) to the engagement model so these contacts surface naturally alongside inbound leads.
4
Hold GrowthSpree and ReMotion to high-fit MQL quality, not CPL
Q2 budget: $390K (GrowthSpree: SEM, Display, YouTube, Bing) + $150K (ReMotion: Paid Social/LinkedIn). The Q1 lesson — a 70.8% high-intent rate on paid search means nothing if 50% of leads have fit below 20. Vendor accountability must shift from CPL optimization to high-fit MQL rate and BOFU activation rate. Require monthly reporting on fit score distribution across all paid leads, not just cost and volume metrics. The c1d25565 attribution fix is the baseline confirmation — if spend is scaling on PMax in Q2, confirm clean attribution first.
5
May 27 product launch: activate all Q1 pipeline learnings in the launch motion
The May 27 launch is Q2's highest-leverage pipeline moment. Activate the stalled SAL re-engagement list against the launch. Use the IDC report and new case study as launch-adjacent assets. Gate event SALs from any launch-week events immediately. Ensure BDR sequences are launch-message-aligned before launch day. The sales messaging workshop (May) should produce the updated outbound messaging matrix that BDRs use in the launch week sequences.
Q1 spend & ROI — demand gen + events
Demand Gen Spend
$454K
SEM/Display/YT, Paid Social, Content Syndication
Events Spend
$528K
Incl. Gartner Orlando $360.6K · net of postpone credits
Total Q1 Marketing Spend
$982K
$454K demand gen + $528K events (excl. $32K brand/LI follower)
Demand Gen Pipeline ROI
15.8×
$7,188,700 inbound pipeline ÷ $454,000 spend
Demand gen — cost per funnel stage

$454,000 demand gen spend · funnel volumes from MQL/SAL audit + gauge actuals

Cost per MQL $522
$454,000 ÷ 870 MQLs
Cost per SAL $290
$454,000 ÷ 1,563 SALs
Cost per SQL $1,884
$454,000 ÷ 241 SQLs
Cost per SQO $3,519
$454,000 ÷ 129 SQOs
Cost per inbound pipeline $ $0.063
$454,000 ÷ $7,188,700 inbound pipeline · 6.3¢ per dollar generated
Cost per MQL by channel

Spend allocated to channel · MQL volumes from MQL/SAL audit

SEM + Display + YouTube $750
$300,000 ÷ 400 paid search MQLs 400 MQLs · avg fit 25.0
⚠ 50.5% of MQLs had fit <20 · $34K ACV gap vs. organic
Paid Social (LinkedIn) $820
$105,000 ÷ 128 paid social MQLs 128 MQLs · avg fit ~55
Fit quality strong · 0% high intent · ~99% MQL→SAL with no gate
Content Syndication $246
$49,000 ÷ 199 CS MQLs 199 MQLs · avg fit 68.1 — highest of any channel
Cheapest CPM + best fit — but only 1 deal created. Structural fix needed in Q2.
Data quality notes
Marketing Funnel Report widget returned no data. The widget on the dashboard displayed "There is no data to show in this time frame. Try changing the date range." All funnel stage volumes in this report are sourced from the MQL/SAL audit and goal gauge actuals — not from a native funnel report. The funnel widget date range filter needs correction before it can be used for ongoing reporting.
Weekly pipeline chart shows bi-weekly labeled bars summing to ~$10.7M, while Pipeline Stats shows $17,760,423. The weekly chart appears to label bi-weekly aggregates at alternating week intervals. The Pipeline Stats widget is the authoritative QTD figure. Do not use weekly bar totals to reconstruct QTD pipeline.
Weekly stage entry charts (SAL, SQL, SQO) use hs_v2_date_entered_* fields which reset on stage exit. Per the data dictionary, these are directional only — not authoritative for historical period counts. The exception is SQO, which uses hs_v2_date_entered_opportunity (reliable). Use mql_date for MQL counts in any reconciliation.
Pipeline Stats filter shows "Filters (2)" — confirm these are Pipeline = 13666711 (SaaS New Deals) AND Deal Source = Inbound. If either filter is missing, the $17.76M figure overstates marketing-sourced pipeline. Cross-reference against the Pipeline by Source chart's "Inbound" segment ($7,188,700) for the marketing-only slice.
Average Number of Associated Companies = 1.07 confirms the multi-threading finding — almost every deal had only a single company association. The 92% single-threaded Discovery stat from the ICP report aligns precisely. Multi-threading is an AE responsibility post-deal creation.