This recipe produces a diagnosed revenue bottleneck with a deployed intervention and measurable before/after impact — within 14 weeks. It outputs an automated diagnostic dashboard tracking pipeline velocity, stage conversion, and coverage ratios, plus a documented intervention the RevOps team can repeat quarterly. Companies with sharp ICP discipline see 68% higher win rates, and pricing improvements yield 2-4x the impact of acquisition improvements — but only if you identify the right constraint first. [src1]
Which path?
├── Company is <$5M ARR AND budget = free/minimal
│ └── PATH A: Spreadsheet Diagnostic — HubSpot Free CRM + Google Sheets + manual analysis
├── Company is <$5M ARR AND budget > $500/mo
│ └── PATH B: Mid-Market Stack — HubSpot Pro/Pipedrive + Forecastio + Metabase
├── Company is $5M-$20M ARR
│ └── PATH C: Growth Stack — Salesforce/HubSpot Enterprise + Clari + Gong + Tableau
└── Company is $20M+ ARR
└── PATH D: Enterprise Stack — Salesforce + Clari + Gong + InsightSquared + custom BI
| Path | Tools | Cost/mo | Diagnostic Depth | Speed to Insight |
|---|---|---|---|---|
| A: Spreadsheet | HubSpot Free, Google Sheets | $0 | Basic — manual stage analysis | 3 weeks |
| B: Mid-Market | HubSpot Pro, Forecastio, Metabase | $200-$800 | Good — automated pipeline scoring | 2 weeks |
| C: Growth | Salesforce, Clari, Gong, Tableau | $2K-$8K | High — AI deal risk + conversation intelligence | 1-2 weeks |
| D: Enterprise | Full Salesforce + Clari + Gong + InsightSquared | $10K+ | Excellent — predictive forecasting + full analytics | 1 week |
Duration: 3-5 days · Tool: CRM + Google Sheets (Path A) or CRM + BI platform (Paths B-D)
Export 6+ months of pipeline data from CRM. Map stage-by-stage conversion rates against 2026 benchmarks: Visitor→Lead (2.9%), Lead→MQL (35-45%), MQL→SQL (15%), SQL→Opportunity (25-30%), Opportunity→Close (6-9%), Overall Lead→Customer (1.5-2.5%). [src4]
Funnel Baseline Template:
| Stage | Your Rate | Benchmark | Gap | Volume | Revenue Impact |
|------------------------|-----------|-------------|--------|---------|---------------|
| Visitor → Lead | | 2.9% | | | |
| Lead → MQL | | 35-45% | | | |
| MQL → SQL | | 15% | | | |
| SQL → Opportunity | | 25-30% | | | |
| Opportunity → Close | | 6-9% | | | |
Pipeline Velocity = (# Opportunities × Win Rate × Avg Deal Size) / Sales Cycle Days
Pipeline Coverage = Total Pipeline / Quarterly Target (target: 3-5x)
Use weighted pipeline coverage (deal value × stage probability) rather than raw totals — high-ICP accounts make up only 23% of typical pipeline. [src5] 97% of leads are not active buyers, so quality-adjusted metrics matter more than raw volume. [src6]
Verify: All funnel stages populated; pipeline velocity calculated as $/day; coverage ratio computed weighted and unweighted · If failed: If CRM data too incomplete, invest 2-4 weeks in CRM hygiene before proceeding
Duration: 3-5 days · Tool: Diagnostic spreadsheet or BI dashboard
Identify the stage with the largest gap between current performance and benchmark. Classify using the four-lever framework: [src1]
Bottleneck Classification:
├── VOLUME: Coverage < 3x — not enough pipeline entering funnel
├── CONVERSION: Any stage >30% below benchmark — pipeline not advancing
├── VELOCITY: Cycle > segment median — deals stalling in pipeline
└── VALUE: Avg deal size declining — winning but missing targets
Rank revenue impact: (gap to benchmark) × (volume at stage) × (downstream conversion). Select the single highest-impact bottleneck. Four in five companies lack clear ICP definitions. [src1] 63% of losses occur before needs assessment — discovery (35%) and qualification (28%) are the highest-leverage zones. [src3]
Verify: One bottleneck selected with quantified annual revenue impact · If failed: If tied, pick the bottleneck closest to revenue — downstream fixes convert existing pipeline faster
Duration: 5-7 days · Tool: CRM reports + Gong/Chorus (Paths C-D) or manual deal review (Paths A-B)
Run targeted analysis based on bottleneck type:
Volume: Analyze channel CAC — referral converts at 2.9%, organic at 2.6-2.7%, email at 2.4%. Average cost per lead is $200 ($75-$150 transactional, $300-$500 high-complexity). [src4]
Conversion: Segment win rates by deal size — SMB should hit 31%, mid-market 24%, enterprise 15%. Speed-to-lead within 5 minutes = 21% higher win rates; rates drop 60% after 24 hours. [src3]
Velocity: Map decision-maker involvement — 13 stakeholders average for enterprise. Optimal cycle: 67 days SaaS/tech, 89 days financial services. [src3]
Value: Expansion ARR = 40% of new ARR at median, 58% above $50M. Companies with dedicated CSMs see 98% NRR vs 90% without. [src1]
Interview 5-10 recent wins and 5-10 recent losses for qualitative signal.
Verify: Root cause documented with 3+ supporting data points · If failed: If unclear after one week, choose the most likely hypothesis and test — analysis paralysis is itself a growth blocker
Duration: 1 week design + 5 weeks execution · Tool: Varies by bottleneck type
Match intervention to root cause with expected quantified lift:
| Bottleneck | Intervention | Tool | Expected Lift |
|---|---|---|---|
| Volume — wrong channels | Shift spend to highest-converting channel | GA4, CRM attribution | 20-40% more MQLs |
| Volume — weak targeting | Refine ICP with intent data | Bombora, 6sense, LinkedIn SN | 68% higher win rates [src1] |
| Volume — no expansion | CSM program + usage triggers | Gainsight, ChurnZero | 8-point NRR lift [src1] |
| Conversion — poor qualification | Deploy MEDDIC/MEDDPICC framework | CRM custom fields, Gong | 40% higher close rates [src3] |
| Conversion — weak demos | Sales coaching + call scoring | Gong, Second Nature | 19-32% win rate lift [src7] |
| Conversion — slow response | Sub-5-minute lead response SLA | Outreach, Salesloft | 21% win rate improvement [src3] |
| Velocity — multi-stakeholder | Multi-threading + mutual action plans | Outreach, DealHub | 2.4-3.1x close rate [src3] |
| Velocity — approvals | Deal desk + pre-approved packages | CPQ (DealHub, Pandadoc) | 15-25% faster close |
| Value — discounting | Discount approval workflow | Salesforce CPQ, Pricefx | 10-20% ASP increase |
| Value — pricing | 5% price increase on renewals | Billing system | 2-4x impact vs acquisition [src1] |
Set leading indicators for weeks 1-4 and lagging indicators for weeks 5-12. AI-powered coaching tools deliver a 10-point win rate improvement on deals over $50K and reduce sales cycles by 11 days. [src3]
Verify: Intervention running 4+ weeks; team adoption >80% · If failed: If adoption <80% after 2 weeks, pause and invest in enablement first
Duration: 2-3 weeks · Tool: CRM reporting + BI dashboard
Compare pre- and post-intervention metrics using minimum 4-week windows. Require 20+ deals through the improved stage before declaring success. Validate that improvement is not seasonal — use YoY comparison if available. [src2]
Impact Report:
| Metric | Pre | Post | Change | Revenue Impact |
|--------------------------------|------|------|--------|---------------|
| Target stage conversion rate | | | | |
| Pipeline velocity ($/day) | | | | |
| Pipeline coverage ratio | | | | |
| Win rate (by segment) | | | | |
| Average deal size | | | | |
| Average sales cycle (days) | | | | |
| Forecast accuracy | | | | |
ROI = incremental revenue / intervention cost
Re-run the full funnel audit. Fixing one bottleneck often reveals the next constraint. Queue the next intervention for the following quarter.
Verify: 10%+ improvement in target metric with 20+ deals through stage · If failed: If 5-10%, continue 4 more weeks. If no improvement after 8 weeks, revisit root cause in Step 3
Duration: 1-2 weeks · Tool: Looker/Tableau (Paths C-D) or Google Sheets (Paths A-B)
Build a live dashboard for three audiences: executives (strategic signals), managers (performance analytics), reps (daily accountability). [src8] Set alerts for metric degradation: trigger when any conversion rate drops 5+ points or coverage falls below 3x. Declining coverage predicts missed targets one quarter out. [src5]
Quarterly Cadence:
Week 1-2: Re-baseline funnel against updated benchmarks
Week 3: Identify next bottleneck by revenue impact
Week 4-8: Design and deploy intervention
Week 9-12: Measure and document impact
Week 13: Review and queue next cycle
Output files:
bottleneck-diagnosis.md — Primary bottleneck with root cause and revenue impactintervention-plan.md — Targeted fix with owner, timeline, metrics, go/no-go gatesimpact-report.md — Before/after comparison with revenue attribution and ROIdiagnostic-dashboard — Live BI dashboard or spreadsheet with alertsVerify: Dashboard operational with real-time data; quarterly cadence documented · If failed: Start with 3 metrics: pipeline velocity, bottleneck conversion rate, weighted coverage ratio
{
"output_type": "revenue_diagnostic_package",
"format": "document collection + dashboard",
"columns": [
{"name": "bottleneck_type", "type": "string", "description": "Volume, Conversion, Velocity, or Value"},
{"name": "bottleneck_stage", "type": "string", "description": "Specific funnel stage (e.g., MQL→SQL)"},
{"name": "gap_to_benchmark", "type": "number", "description": "Percentage points below segment benchmark"},
{"name": "estimated_revenue_impact", "type": "number", "description": "Annual revenue impact ($)"},
{"name": "root_cause", "type": "string", "description": "Primary root cause from data + interviews"},
{"name": "intervention_deployed", "type": "string", "description": "Specific intervention executed"},
{"name": "pre_intervention_metric", "type": "number", "description": "Baseline metric before fix"},
{"name": "post_intervention_metric", "type": "number", "description": "Metric after 4+ weeks"},
{"name": "improvement_pct", "type": "number", "description": "Percentage improvement achieved"},
{"name": "intervention_roi", "type": "number", "description": "Incremental revenue / cost"}
]
}
| Quality Metric | Minimum Acceptable | Good | Excellent |
|---|---|---|---|
| Target stage conversion improvement | 10%+ from baseline | 20%+ from baseline | 30%+ from baseline |
| Pipeline velocity improvement | 10%+ improvement | 20%+ improvement | 30%+ improvement |
| Win rate (segment-adjusted) | >20% SMB / >15% Enterprise | >25% SMB / >18% Enterprise | >31% SMB / >24% Enterprise |
| Pipeline coverage (weighted) | 3x quarterly target | 4x quarterly target | 5x quarterly target |
| Forecast accuracy | >70% | >80% | >87% |
| Time to bottleneck identification | <3 weeks | <2 weeks | <1 week |
| Deals through improved stage | 20+ | 40+ | 60+ |
If below minimum: Re-run Steps 2-3 with broader data window (12 months). If win rate below 15% at any segment, prioritize qualification framework deployment. [src3]
| Error | Likely Cause | Recovery Action |
|---|---|---|
| CRM data too incomplete for stage mapping | Inconsistent stage usage by reps | Invest 2-4 weeks in CRM hygiene: define stage entry/exit criteria tied to buyer actions, train team, backfill |
| Pipeline velocity returns $0 | Win rate or opp count is zero | Extend window to 6-12 months; if still zero, company may be pre-PMF — route to validation |
| Multiple bottlenecks equally critical | Revenue impact scoring not granular enough | Pick bottleneck closest to revenue (Opp→Close > MQL→SQL) — downstream fixes convert existing pipeline |
| No improvement after 8 weeks | Root cause wrong or intervention not adopted | Re-interview 5 recent losses; check adoption rate; if <80%, fix enablement first |
| Dashboard doesn't match CRM | ETL or filter mismatch | Audit queries against raw CRM export; reconcile field mappings and date filters |
| Seasonal effects distort comparison | Comparing Q4 peak to Q1 trough | Use YoY same-period comparison; normalize for seasonal patterns; require 20+ deal sample |
| Team resists qualification framework | Reps see it as admin overhead | Start with top 3 reps as champions; show win rate data proving value; simplify to 3 must-have fields |
| Component | Free (Path A) | Mid-Market (Path B) | Growth (Path C) | Enterprise (Path D) |
|---|---|---|---|---|
| CRM | HubSpot Free ($0) | HubSpot Pro ($90/mo) | Salesforce ($150/user/mo) | SF Enterprise ($300/user/mo) |
| Pipeline analytics | Google Sheets ($0) | Forecastio ($50/user/mo) | Clari ($80/user/mo) | Clari + InsightSquared ($150/user/mo) |
| Conversation intelligence | Manual review ($0) | Fireflies.ai ($19/mo) | Gong ($100/user/mo) | Gong ($100/user/mo) |
| BI / dashboards | Google Sheets ($0) | Metabase free ($0) | Tableau ($70/user/mo) | Tableau + Looker ($140/user/mo) |
| Intervention execution | Internal ($0-$5K) | Coaching ($5K-$15K) | Coaching + tools ($15K-$50K) | Full program ($50K-$150K) |
| Total per cycle | $0-$5K | $5K-$25K | $25K-$80K | $80K-$250K |
Attempting to optimize lead generation, conversion, velocity, and deal size simultaneously guarantees no single initiative gets enough focus. Companies that attempt parallel optimization rarely attribute any improvement to a specific change. [src1]
Identify the single biggest bottleneck by revenue impact, fix it, measure, then move to the next. Serial focus compounds faster than parallel dilution. Companies with sharp ICP discipline see 68% higher win rates. [src1]
Adding headcount to a broken process scales the problem. The median B2B SaaS company now spends $2 to acquire $1 of new ARR — adding reps without fixing the funnel worsens this ratio. [src1]
Improve win rate to segment benchmarks (31% SMB, 24% mid-market) before adding headcount. Deploy MEDDIC (40% higher close rates), sales coaching (19-32% win rate lift), or multi-threading (2.4-3.1x close rates). [src3] [src7]
A $10M pipeline with 5% win rate is far weaker than a $4M pipeline with 25% win rate. High-ICP accounts make up only 23% of typical pipeline — total value without quality scoring is a false signal. [src5]
Pipeline velocity (opportunities × win rate × deal size / cycle days) is the single best predictor of future revenue. Weighted coverage reveals true forecast accuracy. Track both weekly. [src6]
Use when a company has established revenue but growth has stalled, decelerated, or become unpredictable — and the RevOps team needs to actually diagnose and fix the specific constraint, not produce a strategy document. Requires CRM data as input; produces a diagnosed bottleneck, deployed intervention, and measurable impact report as output. Essential for companies that have tried "doing more of everything" without identifying which specific funnel stage is the actual constraint.