Library/Sales Operations, CRM & Productivity/Reporting & Performance Analytics/Run a Sales Process Audit from CRM and Activity Data
TestedSales Operations, CRM & ProductivityQuick Win (under 10 min)

Run a Sales Process Audit from CRM and Activity Data

Analyze pipeline data to identify funnel leakage points, stage velocity, win rate patterns, and top process improvement

About this prompt

This prompt conducts a structured sales process audit from CRM and pipeline data, producing a one-page health report with prioritized action items. It's built for sales managers, directors, and RevOps. Use it ahead of a QBR, board review, or pipeline review when you need to move beyond gut feel and build a data-grounded diagnosis of where the team is losing deals.Most sales process reviews stay at the surface — win rate and pipeline coverage — without drilling into stage conversion, deal velocity, or rep-level patterns that would actually drive improvement. This prompt analyzes five dimensions: stage-by-stage conversion drop-off, average time in each stage and where deals stall, win rate broken down by source, company size, and industry, rep performance differences by stage and what can be learned from top performers, and three actionable process improvements ranked by projected impact on win rate or deal velocity. The key input is [PASTE PIPELINE/CRM SUMMARY]; export a stage-by-stage funnel summary with timestamps and deal attributes rather than a raw deal list for the clearest output. If your CRM data has rep-level breakdowns, include those — the prompt specifically looks for rep-stage patterns that point to coaching opportunities. The output is a structured one-page report suitable for presenting in a sales leadership QBR.

The prompt

Conduct a sales process audit for our team based on the following CRM and activity data. Identify: 1. Where in the funnel are we losing the most deals? (Stage conversion analysis) 2. What is our avera
The rest of this prompt is Pro.Copying the full text is Pro. Browsing stays free, and 100 prompts are free in full.
Copy prompt
☆ Save to library
Send to a teammate
Email it
Link copied — paste it in Slack
Copying the full text is Pro.

Variables to replace

PASTE PIPELINE/CRM SUMMARY

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
SeatSales Manager, Sales Director, 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.

Stop rewriting. Start closing.

Copy prompt
Start Pro — $4.99/mo