🚀 Early Access: FREE full access to All Workflows and AI Prompt Systems! No credit card required.

Pipeline Velocity Analysis

Analyse sales pipeline speed, stage movement, bottlenecks, and revenue impact to improve deal progression.
Sales - Revenue Operations - Pipeline Velocity Analysis

Who it's for

Revenue operations leaders, Sales operations managers, Sales leaders, Founders, RevOps analysts

Get Ready

Prepare the Required Inputs listed in the Workflow Prompt. Use as much detail as necessary.

How to use this prompt

1. Copy the Workflow Prompt.
2. Paste it into your AI tool.
3. Replace the "Required Inputs"
4. Run the prompt.

🔒

Unlock the Full Workflow

Get access to this workflow and 1000+ others designed to save hours and get better results with AI.

Workflow Prompt

				
					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
				
			

Optional advanced instructions

				
					Add a simple before-and-after velocity model showing the likely effect of improving one bottleneck stage.
				
			

Example output

 

1. Executive Summary

  • Overall Velocity Health: RESTRICTED. While top-of-funnel generation is healthy, the pipeline suffers from a severe structural deceleration in mid-funnel stages, causing the average sales cycle to stretch well beyond historical benchmarks.
  • The Biggest Constraint: The Stage 2 “Demo-to-Evaluation” Friction Point. Opportunities are languishing for an average of 42 days in the solution demonstration phase. This is driven by a lack of buyer-verified exit criteria and a failure to engage technical stakeholders early, resulting in a low 22% conversion rate into active technical evaluations.
  • Target Objective: Accelerate overall velocity to support a 20% increase in quarterly closed-won ARR for the Cross-Border Customs API Hub.

2. Pipeline Velocity Snapshot

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

3. Stage-by-Stage Bottleneck Analysis

Stage 1: Pain Discovery (Volume: 15 Deals | Avg. Age: 12 Days)

  • What is Slowing Movement: High rep talk-time (averaging 68%) leads to superficial qualification. Reps are rushing to book a product demo rather than isolating and verifying deep financial or operational pain.
  • Why It Matters: Weak qualification at this initial gate causes a massive drop-off and stagnation in the next phase of the sales cycle.
  • Evidence: 58% of open opportunities currently sitting in Stage 1 completely lack documented baseline operational metrics or financial fine exposures in the CRM text logs.

Stage 2: Solution Demonstration (Volume: 16 Deals | Avg. Age: 42 Days)

  • What is Slowing Movement: The “Feature-Dump” bottleneck. Reps present generic product tours to low-level operational users without involving the technical or economic decision-makers who hold buying authority.
  • Why It Matters: Deals pile up here indefinitely because the low-level champion lacks the internal authority or technical context to move the evaluation forward.
  • Evidence: Stage 2 to Stage 3 conversion drops to a low 22%, and the average age in this single stage is higher than the entire remaining sales cycle combined.

Stage 3: Technical Sandbox Evaluation (Volume: 8 Deals | Avg. Age: 18 Days)

  • What is Slowing Movement: Internal IT resource constraints and security compliance bottlenecks on the buyer’s side.
  • Why It Matters: Extends sales cycles and introduces risk, as our engineering resources are tied up in sandboxes for accounts that haven’t cleared security parameters.
  • Evidence: 4 active enterprise accounts have logged notes explicitly referencing “Internal legacy database migrations causing technology resource constraints.”

Stage 4: Proposal & Negotiation (Volume: 3 Deals | Avg. Age: 3 Days)

  • What is Slowing Movement: Procurement delays and late-stage budget freezes.
  • Why It Matters: Threatens final forecast predictability, as single-deal delays completely wipe out the quarter’s revenue foundation.
  • Evidence: Historical win rates from this stage are high (80%), but 45% of deals routinely slide past their original forecasted close month due to procurement bottlenecks.

4. Segment Differences

  • The Mid-Market Cross-Sell Motion: Features a much healthier velocity profile (54-day sales cycle). Because a commercial relationship already exists, reps easily bypass early discovery hurdles. The primary bottleneck here is purely operational capacity: a single AE is handling 140 accounts, causing delays in follow-ups.
  • The Enterprise New-Logo Motion: Velocity is exceptionally sluggish (105-day sales cycle). Deals move smoothly into Stage 2 but stall out entirely due to extreme deal concentration risk. 65% of the total enterprise pipeline value is tied up in just two massive accounts, creating unpredictable revenue swings.

5. Revenue Impact Assessment

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.


6. Root Cause Diagnosis

  • Process Flaw: Stage transitions are built around seller activities (“Demo Sent”) instead of objective, buyer-verified actions (“Buyer introduces IT Lead”).
  • Data Issue: The CRM doesn’t track time-in-stage or velocity exceptions, meaning stale deals look identical to fast-moving opportunities on sales dashboards.
  • Rep Behavior: AEs rely on verbal confirmation (“The demo went great”) rather than securing a firm, calendar-locked commitment for the next step.
  • Buyer Behavior: Low urgency…

When to reuse this workflow

You may also like...

🔒

Unlock the Full Workflow

Get access to this workflow and 1000+ others designed to save hours and get better results with AI.

No guesswork. Just proven systems.

  • Copy & paste ready prompts
  • Step-by-step instructions
  • Works with ChatGPT instantly

Forecast Risk Assessment

Assess forecast risk across pipeline quality, deal confidence, timing, rep judgement, and data reliability.

Revenue Growth Constraint Analysis

Identify the main operational constraints preventing sales growth and create a focused action plan.

Sales Activity Effectiveness Analysis

Assess which sales activities create pipeline progress, meetings, opportunities, and closed revenue.

Unlock the full library.

Get access to all workflows, across every sector, with structured systems built for better results.