Sales AI Skill
Sales Velocity Bottleneck Analysis
Measure and optimize sales velocity by analyzing deal progression speed, identifying pipeline bottlenecks, and calculating the impact of process improvements on revenue. Use when analyzing pipeline velocity, finding deal bottlenecks, optimizing sales cycle...
Sales Velocity & Bottleneck Analysis
Diagnose and accelerate deal flow through data-driven pipeline velocity optimization.
Workflow
- Calculate sales velocity using the core formula: (Opportunities × AVG Deal Size × Win Rate) / Sales Cycle Length.
- Map deal stage progression times across the entire pipeline.
- Identify bottlenecks: stages where deals stagnate, drop off, or cycle backward.
- Root cause analysis on bottleneck stages (qualification gaps, process issues, resource constraints).
- Implement targeted interventions for each bottleneck.
- Measure impact of improvements on overall velocity and revenue.
- Generate weekly velocity reports for sales leadership.
Sales Velocity Calculation
SALES VELOCITY FORMULA
========================
Core Formula:
────────────
Sales Velocity = (Number of Opportunities × Average Deal Size × Win Rate) / Sales Cycle Length
Example:
Opportunities: 200 active deals
Average Deal Size: $50,000
Win Rate: 25%
Sales Cycle: 90 days
Velocity = (200 × $50,000 × 0.25) / 90
Velocity = $2,500,000 / 90
Velocity = $27,778/day
Monthly Revenue = $27,778 × 30 = $833,340/month
Annual Revenue = $27,778 × 365 = $10,138,970/year
FOUR LEVERS TO INCREASE VELOCITY:
───────────────────────────────
Lever 1: Increase Opportunities (+1 deal/day)
More leads, more pipeline, more deals in motion
Impact: Direct linear increase in velocity
Initiatives: Inbound marketing, outbound prospecting, referral programs
Lever 2: Increase Average Deal Size (+$1K per deal)
Better targeting, upselling, expanding scope
Impact: Direct linear increase in velocity
Initiatives: ICP refinement, value selling, competitive displacement
Lever 3: Increase Win Rate (+1% improvement)
Better qualification, better execution, better coaching
Impact: Compounding effect on all opportunities
Initiatives: BANT enforcement, MEDDIC training, competitive training
Lever 4: Decrease Sales Cycle (-1 day)
Faster progression, fewer bottlenecks, better process
Impact: Accelerates ALL deals in pipeline simultaneously
Initiatives: Stage criteria enforcement, MAP adoption, deal desk SLAs
VELOCITY BY SEGMENT:
──────────────────
Calculate velocity separately for:
- New Logo vs. Expansion deals
- SMB vs. Mid-Market vs. Enterprise
- Individual AEs and teams
- Product lines or offerings
- Geographic regions
- Channel vs. Direct
This reveals which segments are driving velocity and which are dragging it down.
Stage Progression Analysis
DEAL STAGE DURATION ANALYSIS
==============================
Average Time in Stage (Days):
╔═══════════════════════════════╦═════════╦═══════════╦══════════════════════╗
║ Stage ║ Avg Days ║ Median ║ % of Deals Stalled* ║
╠═══════════════════════════════╬═════════╬═══════════╬══════════════════════╣
║ Lead → Qualified ║ 5 ║ 3 ║ 12% ║
║ Qualified → Discovery ║ 4 ║ 3 ║ 8% ║
║ Discovery → Demo/Presentation ║ 7 ║ 5 ║ 15% ║
║ Demo → Proposal/Quote ║ 10 ║ 7 ║ 22% ← BOTTLENECK ║
║ Proposal → Negotiation ║ 14 ║ 10 ║ 28% ← BOTTLENECK ║
║ Negotiation → Closed Won ║ 11 ║ 8 ║ 18% ║
╚═══════════════════════════════╩═════════╩═══════════╩══════════════════════╝
* Stalled = no stage activity for 14+ days
Total Average Sales Cycle: 51 days
Target Sales Cycle: 40 days
Gap: 11 days (27% longer than target)
BOTTLENECK IDENTIFICATION:
───────────────────────
Top Bottlenecks:
1. Proposal → Negotiation (14 avg days, 28% stalled)
Root Causes:
- Slow internal approval process (deal desk backlog)
- Proposals sent without buyer readiness (no MAP alignment)
- Competitor evaluation delaying decision
- Buyer needs internal stakeholder alignment
Interventions:
- Deal desk SLA: 24-hour turnaround on proposals
- Pre-proposal readiness checklist (MAP must be approved first)
- Executive sponsor engagement before proposal
Expected Impact: -5 days in this stage
2. Demo → Proposal (10 avg days, 22% stalled)
Root Causes:
- Demo not tied to specific pain points (generic presentations)
- No clear next step agreed at end of demo
- Stakeholder alignment incomplete
- Champion not empowered to advance
Interventions:
- Post-demo checklist: pain confirmed, stakeholder mapped, next step set
- Automated follow-up within 2 hours with proposal timeline
- Champion activation playbook
Expected Impact: -4 days in this stage
3. Discovery → Demo (7 avg days, 15% stalled)
Root Causes:
- Discovery calls without clear demo commitment
- Scheduling friction (no automated booking)
- Prospect disengages post-discovery
Interventions:
- Discovery call must end with demo scheduled (or clear reason why not)
- Automated booking link sent within 30 minutes
- Engagement score tracking post-discovery
Expected Impact: -2 days in this stage
PROJECTED VELOCITY IMPROVEMENT:
─────────────────────────────
Current cycle: 51 days
After interventions: 40 days (22% faster)
Velocity increase: 51/40 - 1 = 27.5%
Monthly revenue impact: $833K → $1.06M (+$227K/month, +$2.7M/year)
Bottleneck Diagnostic Framework
BOTTLENECK ROOT CAUSE DIAGNOSTIC
==================================
For each identified bottleneck, analyze across 5 dimensions:
1. PROCESS ISSUE:
─────────────
- Stage entry/exit criteria unclear or not enforced
- No standardized playbook for stage progression
- Missing handoff protocol between stages
- Inconsistent deal qualification standards
Diagnostic: Stage criteria audit, process compliance rate [%]
2. PEOPLE/SKILLS ISSUE:
───────────────────
- Reps lack skills to advance deals past this stage
- Inadequate coaching on stage-specific competencies
- New reps disproportionately stuck at this stage
- SE/SM not available when needed for deal progression
Diagnostic: Rep performance comparison at this stage, ramp time analysis
3. TOOL/TECHNOLOGY ISSUE:
──────────────────────
- CRM not capturing stage activity accurately
- No automation to advance deals (reminders, nudges)
- Proposal generation tool slow or manual
- Lack of collaboration tools for multi-threaded deals
Diagnostic: Tool adoption rate, automation coverage, system latency
4. ORGANIZATIONAL ISSUE:
─────────────────────
- Deal desk creating delays (approval bottlenecks)
- Legal review slow on contract terms
- Finance not available for pricing decisions
- Product promises causing deal delays
Diagnostic: Cross-functional SLA compliance, escalation frequency
5. MARKET/BUYER ISSUE:
───────────────────
- ICP misalignment (wrong buyers for this offering)
- Market conditions slowing buying cycles
- Competitive landscape creating evaluation delays
- Budget cycles causing natural pauses
Diagnostic: Win/loss analysis, competitive intelligence, seasonality trends
BOTTLENECK SEVERITY SCORING:
╔═══════════════════════════════════╦══════════════════╗
║ Criteria ║ Score Weight ║
╠═══════════════════════════════════╬══════════════════╣
║ Avg days in stage vs. target ║ 30% ║
║ % of deals stalled at this stage ║ 25% ║
║ Revenue impact (deals × $ value) ║ 25% ║
║ Stage drop-off/churn rate ║ 20% ║
╚═══════════════════════════════════╩══════════════════╝
Severity Tiers:
80-100: CRITICAL — Immediate intervention required
60-79: HIGH — Intervention within 2 weeks
40-59: MEDIUM — Address in next process improvement cycle
<40: LOW — Monitor; no immediate action needed
Velocity Reporting & Alerts
WEEKLY VELOCITY REPORT
========================
Executive Summary:
Overall Sales Velocity: [$X/day] (↑↓ vs last week: [%])
Active Opportunities: [count] (↑↓ vs last week: [%])
Weighted Pipeline: [$ amount] (↑↓ vs last week: [%])
Forecasted Monthly Revenue: [$ amount] (vs. quota: [%])
Sales Cycle (avg): [X days] (vs. target: [Y days])
Velocity by Rep:
╔═══════════╦═════════════╦═════════════╦═══════════════╦═════════════╗
║ AE ║ Velocity ║ Opp Count ║ Cycle (days) ║ Win Rate ║
╠═══════════╬═════════════╬═════════════╬═══════════════╬═════════════╣
║ [Name] ║ $X/day ║ [count] ║ [X] ║ [%] ║
╚═══════════╩═════════════╩═════════════╩═══════════════╩═════════════╝
Bottleneck Alert:
⚠️ [Stage] — [X] deals stalled >14 days ($Y total value at risk)
Top stalled deals: [list with AE, company, last activity date]
Pipeline Age Analysis:
0-14 days: [count] deals — [% of pipeline]
15-30 days: [count] deals — [% of pipeline]
31-60 days: [count] deals — [% of pipeline]
61-90 days: [count] deals — [% of pipeline]
90+ days: [count] deals — [% of pipeline] ← concern if >20%
AUTO-ALERTS:
Deal stalled >14 days: Alert to AE
Deal stalled >21 days: Alert to AE + Manager
Deal stalled >30 days: Manager review required
Deal stalled >45 days: "Save or lose" decision — advance or recycle
Velocity drops >10% WoW: Team-wide alert to VP Sales
Edge Cases
- Seasonal velocity variation: Velocity naturally dips in summer/holidays
- Mitigation: Calculate velocity against same period last year (YoY) not rolling average
- Set seasonal velocity targets adjusted for historical patterns
- Use "catch-up" velocity targets post-season to recover lost ground
- Plan major initiatives during high-velocity periods
- Enterprise vs. SMB velocity mix change: Portfolio shift to more enterprise deals extends average cycle
- Mitigation: Calculate velocity by segment, not blended average
- Separate dashboards for SMB, Mid-Market, Enterprise velocity
- Weighted velocity metric accounting for deal mix
- Alert only when velocity drops within same segment
- New AE ramp impact: New reps with longer cycles drag down team velocity
- Mitigation: Exclude reps in first 90 days from team velocity average
- Track "ramp velocity" separately with adjusted expectations
- Pair new reps with mentors to accelerate stage progression
- Velocity target phased: Month 1 (50%), Month 2 (75%), Month 3 (100%)
Integration Points
- Salesforce/HubSpot: Stage data, deal values, opportunity aging
- Salesloft/Outreach: Activity data for stage progression triggers
- Gong: Call data for deal advancement evidence
- CPQ: Proposal generation and approval timeline data
- Tableau/Looker: Velocity dashboards and bottleneck visualization
- Slack: Bottleneck alerts and weekly velocity report distribution
- Asana/Jira: Process improvement task tracking from bottleneck analysis