Library/Sales Operations, CRM & Productivity/Reporting & Performance Analytics/Sales Funnel Analysis Report Conversion Optimization
TestedSales Operations, CRM & ProductivityDeep Work (30+ min)

Sales Funnel Analysis Report Conversion Optimization

Generate a structured funnel analysis report that surfaces conversion gaps and stage-level performance trends for pipeline reviews.

About this prompt

This prompt produces a structured sales funnel analysis report for Sales Managers, Directors, and RevOps teams reviewing pipeline health and conversion performance. It surfaces drop-off points, stage conversion rates, and optimization recommendations based on the data inputs you provide. Use it ahead of pipeline reviews, QBRs, or when diagnosing a sudden change in funnel performance.A sales funnel that looks healthy from the top can hide severe bottlenecks in the middle — this prompt surfaces them from your own data. It takes your funnel stages, what counts as entering each one, and stage data for a stated date window (stage counts, a pipeline export or a CSV), then states its metric definitions and calculates stage-to-stage conversion, drop-off and, where stage dates exist, time in stage before it interprets anything. Bottlenecks are ranked by how many extra closed-won deals a lift at that stage would produce, likely causes such as messaging gaps, qualification issues, process friction or competitive losses come back as labeled hypotheses tied to a number, and every recommendation is framed as a test with an owner and a review date. Use this for quarterly pipeline reviews, RevOps planning cycles, or when your forecast keeps missing in a way that suggests a conversion problem rather than a coverage problem. For managers doing funnel analysis for the first time, the framework is as valuable as the specific numbers — it installs a systematic way of thinking about sales process health. For best output, provide stage data over at least two quarters so trends are visible; set the depth to quick when you only need the conversion table.

The prompt

Act as a revenue operations analyst and produce a Sales Funnel Analysis Report for the company below: calculate stage-to-stage conversion from the data supplied, find where the funnel loses the most d
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 — $12/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

COMPANY DETAILS | FUNNEL STAGES AND DEFINITIONS | SALES DATA | DATE WINDOW | COMPARISON OR TARGETS | FULL OR QUICK

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 valueDeep Work (30+ min)
Works withAI-Agnostic
CategorySales Operations, CRM & Productivity
Promptifi ProFull text of all 2,900+ prompts, every workflow, unlimited saves.Start Pro — $12/month$89/year · cancel anytime
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 — $12/month