Revenue operations leaders, Sales operations managers, Sales leaders, Founders, RevOps analysts
Prepare the Required Inputs listed in the Workflow Prompt. Use as much detail as necessary.
1. Copy the Workflow Prompt.
2. Paste it into your AI tool.
3. Replace the "Required Inputs"
4. Run the prompt.
Get access to this workflow and 1000+ others designed to save hours and get better results with AI.
You are a revenue operations analyst. Your task is to analyse pipeline velocity and identify the specific changes needed to improve deal progression and revenue predictability.
### Required Input
- Sales Motion: [Describe the sales model. Example: mid-market SaaS with inbound demo requests and outbound enterprise prospecting]
- Pipeline Period: [Timeframe being analysed. Example: last two quarters]
- Pipeline Stages: [List each stage in order with definitions if available]
- Opportunity Data: [Provide stage counts, value, age, win rates, conversion rates, or a CRM export summary]
- Average Deal Size: [Example: $18,000 annual contract value]
- Average Sales Cycle: [Example: 62 days from qualified opportunity to closed won]
- Segment Breakdown: [Example: SMB, mid-market, enterprise, region, product line]
- Current Concerns: [Example: deals stall after demo, late-stage slippage, low proposal-to-close rate]
- Revenue Goal: [Example: increase monthly closed-won revenue by 20%]
### Input Validation
Review every required input before producing the analysis. If opportunity data is incomplete, continue only if the user provides enough directional information to compare stages, timing, and value. If not, ask for the missing figures and pause.
### Instructions
Analyse velocity as a combination of opportunity volume, conversion rate, deal value, and time in stage. Do not treat speed alone as the goal; distinguish between healthy progression and rushed, low-quality pipeline movement.
Map the pipeline stage by stage. Identify where opportunities slow down, where value accumulates without movement, where conversion drops, and where sales cycle time becomes commercially harmful. Compare segments separately when data allows, because an enterprise bottleneck may require a different response than an SMB bottleneck.
Look for operational causes behind slow movement: unclear exit criteria, weak qualification, poor next-step discipline, stakeholder gaps, pricing delays, legal review delays, missing mutual action plans, low rep activity, or low buyer urgency. Connect every finding to likely revenue impact.
Avoid vague recommendations such as "improve follow-up." Recommend specific changes to stage definitions, process rules, inspection cadence, enablement, handoffs, or manager coaching. Where numbers are missing, label assumptions clearly and explain what data should be captured next.
### Output
- Executive Summary: concise assessment of overall velocity health and the biggest constraint
- Pipeline Velocity Snapshot: opportunity volume, conversion, deal value, sales cycle, and stage ageing observations
- Stage-by-Stage Bottleneck Analysis: what is slowing movement, why it matters, and evidence from the input
- Segment Differences: where velocity differs by segment, source, region, product, or deal size
- Revenue Impact Assessment: how current velocity issues affect forecast, capacity, and goal attainment
- Root Cause Diagnosis: process, data, rep behaviour, buyer behaviour, and operational contributors
- Priority Fixes: 5-8 specific recommendations ranked by impact and difficulty
- Manager Inspection Points: what sales managers should review weekly
- Data Gaps To Close: missing CRM or reporting fields needed for better future analysis
- 30-Day Action Plan: practical actions with owner type, expected outcome, and success measure
Add a simple before-and-after velocity model showing the likely effect of improving one bottleneck stage.
| Velocity Velocity Metric | Mid-Market Cross-Sell Segment | Enterprise New-Logo Segment | Combined Portfolio Average |
|---|---|---|---|
| Active Opportunity Volume | 28 Deals ($1.8M total value) | 14 Deals ($3.4M total value) | 42 Active Opportunities |
| Average Deal Size (ARR) | $65,000 | $242,000 | $124,000 Combined |
| Average Sales Cycle | 54 Days | 105 Days | 75 Days Total Runway |
| Stage Ageing Baseline | Avg. 18 days in current stage | Avg. 48 days in current stage | 33 Days Average Age |
| Win Rate from Creation | 26% | 12% | 19% Baseline Average |
The Cost of Delayed Velocity:
The current 42-day bottleneck in Stage 2 creates an unpredictable forecasting environment. Because deals stall out mid-funnel, the sales team must rely heavily on low-probability, late-stage pushes to hit their targets. This stagnation locks up an estimated **$1.2M in pipeline value** each quarter. If we reduce the average Stage 2 duration by just 10 days, we can unlock enough pipeline velocity to hit our 20% closed-won growth target without needing to generate any additional top-of-funnel leads.
Get access to all workflows, across every sector, with structured systems built for better results.