Library/Sales Operations, CRM & Productivity/Call & Email Performance Review/Analyze Closed Deal Pipeline Velocity and Stage Bottlenecks
TestedSales Operations, CRM & ProductivityQuick Win (under 10 min)

Analyze Closed Deal Pipeline Velocity and Stage Bottlenecks

Calculate average stage dwell times, drop-off rates, and full-cycle length from closed deal data, with bottleneck fixes.

About this prompt

This prompt analyzes a batch of closed deal records to surface pipeline velocity metrics — average days per stage, highest drop-off stage, full sales cycle length, and velocity differences by company size, deal size, and source. It is designed for AEs, sales managers, and RevOps teams doing post-period pipeline reviews. Use it after a quarter close or when building a pipeline health baseline before a planning cycle.When you have a dataset of closed deals with stage-transition dates, this prompt converts raw CRM history into an actionable velocity analysis. It calculates average dwell time for each stage from Discovery through Close, identifies which stage leaks the most deals, and segments velocity by company size, deal size, and lead source. For each identified bottleneck stage, it recommends one process change targeting a 20% reduction in time-in-stage. Paste your deal history with stage dates into the [PASTE DEAL HISTORY WITH STAGE DATES] placeholder — the richer the dataset (50+ deals is a reasonable floor), the more reliable the segmentation. This prompt is best run by RevOps or a sales manager preparing for a pipeline review or territory planning session, not by an individual AE doing deal-by-deal inspection. For best output, include stage-entry and stage-exit timestamps rather than just close dates, and flag whether losses were competitive, no-decision, or unqualified so the bottleneck analysis stays meaningful.

The prompt

Analyze the following closed deals and calculate deal velocity metrics: 1. Average days in each pipeline stage (Discovery → Demo → Proposal → Close) 2. Which stage has the longest dwell time on averag
The rest of this prompt is Pro.Copying the full text is Pro. Browsing stays free, and 100 prompts are free in full.
Start Pro — $4.99/monthSee the free prompts
Copy prompt
☆ Save to library
Send to a teammate
Email it
Link copied — paste it in Slack
Open in
ClaudeChatGPTCopilotGemini
Copying the full text is Pro.

Variables to replace

PASTE DEAL HISTORY WITH STAGE DATES

How to run it

  1. Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot — it's tuned to run in any of them.
  2. Replace the variables — swap each bracketed token for your deal's specifics. The variables list above explains every field.
  3. Make it yours — run it, keep what's strong, and tighten your inputs on the next pass. The prompt improves with your context.

What good output looks like

Make it yours

StagePipeline Management
SeatAE, Sales Manager, RevOps / Sales Ops
DifficultyAdvanced
Time to valueQuick Win (under 10 min)
Works withAI-Agnostic
CategorySales Operations, CRM & Productivity
Promptifi ProFull text of all 2,900+ prompts, every workflow, unlimited saves.Start Pro — $4.99/moor $99 once, lifetime
You're ProFull library open. Copy, save, and chain anything.
More from the library

Reps who ran this also ran.

Evaluation
PRO

Write Live-Call Rebuttals for Three Common Objections

This prompt produces natural-sounding spoken rebuttals for up to three sales objections, each under 50 words and built for use in a live call rather than a written response. It is built for AEs, inside sales reps, sales managers preparing coaching material, and founder-led sellers who need to handle recurring objections consistently. Use it when you have identified the specific objections your deals run into and want structured, ready-to-speak responses.

AE, Inside Sales, Sales Manager, Founder-Led SellerAI-Agnostic
Open →
Discovery
PRO

Extract Deal Intelligence from Call Transcript

This prompt helps AEs and Sales Engineers extract structured deal intelligence from a discovery or qualification call transcript. It produces a stakeholder map, key intelligence summary, current-state environment snapshot, red and green flags, MEDPICC scoring with rationale, and prioritized next steps. Use it immediately after any prospect call where you need to update your CRM, align internally, or prepare for the next conversation.

AE, Sales EngineerAI-Agnostic
Open →
Prospecting
PRO

Generate 10 Angle-Diverse Cold Email Variants Under 75 Words

This prompt generates ten cold email variants — one per named angle — each under 75 words, built around a no-oriented question and an easy out. It is designed for SDRs, BDRs, and AEs who need a full A/B test suite for a specific persona and industry without duplicating approach or question type. Use it when you are launching a new sequence and want to cover the full angle spectrum before committing to a primary message.

SDR,BDR,AEAI-Agnostic
Open →

Stop rewriting. Start closing.

Browse the librarySee pricing
Copy prompt
Start Pro — $4.99/mo