Prompt: Analyze My Sales Conversion Rates

This prompt analyze sales conversion rates by stage shows you exactly where deals are dying and what to fix. Most sales teams know their close rate. Few know their conversion rate between each stage. That is where the problems hide.

The Prompt

You are a sales operations analyst. Analyze my sales conversion rates.

Sales process stages and data (paste your pipeline data):

| Stage | Name | Leads Entering | Leads Converting | Conversion Rate | Average Time in Stage |
| 1 | [e.g., New Lead] | [number] | [number] | [%] | [days] |
| 2 | [e.g., Qualified] | [number] | [number] | [%] | [days] |
| 3 | [e.g., Meeting Booked] | [number] | [number] | [%] | [days] |
| 4 | [e.g., Proposal Sent] | [number] | [number] | [%] | [days] |
| 5 | [e.g., Won/Lost] | [number] | [number] | [%] | [days] |

Additional context:
- Average deal value: [amount]
- Sales cycle length: [average days from lead to close]
- Main lead source: [where leads come from]
- Sales team: [number of reps, or just you]
- Time period of this data: [months]
- Industry: [your industry]

Analyze:

1. STAGE-BY-STAGE ANALYSIS:
For each stage:
- Is the conversion rate healthy vs industry norms?
- Is the time in stage appropriate or too long?
- What typically causes drop-off at this stage?

2. THE BOTTLENECK:
Which stage is the biggest bottleneck? Show the math:
- Revenue impact of a 10% improvement at each stage
- The stage where a 10% improvement has the largest revenue impact is the priority

3. PIPELINE VELOCITY:
- Current velocity: deals x win rate x avg value / sales cycle
- What is slowing velocity the most: volume, conversion, deal size, or cycle time?
- Which lever to pull first and why

4. LEAD QUALITY ASSESSMENT:
Based on the stage 1 to stage 2 conversion rate:
- Are we generating the right leads?
- What percentage of leads are truly qualified?
- Estimated wasted spend on unqualified leads

5. DEAL TIMING ANALYSIS:
- Are deals that stay too long in any stage less likely to close?
- What is the "stale deal" threshold for each stage?
- Recommendation for when to de-prioritize a stagnant deal

6. IMPROVEMENT PLAN:
3 specific actions ranked by expected revenue impact. For each:
- What to change
- Which stage it affects
- Expected improvement (realistic %)
- Revenue impact of that improvement
- How to measure if it worked

Show all math so I can verify and update the analysis next month.

The Revenue Impact Calculation

Section 2's math is the key output. If improving stage 3 by 10% adds $15,000/month but improving stage 1 by 10% adds $4,000/month, the priority is obvious. Most teams guess at this. The math removes the guesswork.

Monthly Tracking

Run this analysis monthly. Plot stage conversion rates over time. Improving one stage per quarter compounds into significant revenue growth over a year.

Build These Systems

Ready to implement? These step-by-step tutorials show you exactly how:

• How to Build an AI-Powered Win/Loss Analysis System - Analyze won and lost deals with AI to find patterns and improve close rates.
• How to Build an AI Deal Stage Predictor - Predict which deals will close using AI analysis of pipeline data.
• How to Create an Automated Free Trial to Paid Conversion System - Convert free trial users to paid customers with automated nurture sequences.