Sync Opportunity Stage Progression Win/Loss Analysis

Analyzes opportunity stage progression patterns to identify win/loss trends and conversion rates at each sales stage. Provides insights into pipeline efficiency, stage-specific performance, and recommendations for improving overall conversion rates through better qualification and stage advancement strategies.

QUERY:

For [PRODUCT_NAME] opportunities (opened since [START_DATE] and) currently closed, calculate the overall win rate and total volume. Show me total opportunities, won count, lost count, and overall win percentage.

Goal: Establish baseline performance metrics and overall conversion rates to provide context for deeper stage-by-stage analysis.

QUERY:

Analyze stage progression for [PRODUCT_NAME] opportunities by examining OpportunityFieldHistory records. For each sales stage ([STAGE_LIST]), show how many opportunities reached that stage and their subsequent win/loss rates. Include stage-specific conversion percentages.

Goal: Identify conversion patterns at each pipeline stage to pinpoint where opportunities are most likely to succeed or fail, revealing critical inflection points in the sales process.

QUERY:

Create a funnel analysis showing opportunity flow between sales stages for [PRODUCT_NAME] deals. Calculate conversion rates from [STAGE_A] to [STAGE_B] (e.g., Qualifying to Evaluating, Evaluating to Proposing) and identify the biggest drop-off points in the pipeline.

Goal: Understand stage-to-stage progression efficiency and identify bottlenecks where opportunities stall or drop out of the pipeline most frequently.

QUERY:

Based on the stage progression data for [PRODUCT_NAME] opportunities, identify strategic recommendations for improving conversion rates. Focus on stages with [WIN_RATE_THRESHOLD]% or lower win rates and suggest process improvements for advancing prospects to higher-converting stages.

Goal: Transform analytical insights into actionable recommendations for sales process optimization, resource allocation, and targeted coaching to improve overall pipeline performance.

QUERY:

Generate a comprehensive report combining all stage progression metrics, including trend analysis over [TIME_PERIOD], stage-specific performance benchmarks, and recommended action items for sales leadership.

Goal: Provide executive-level summary with complete pipeline health assessment and strategic recommendations for improving sales effectiveness across all opportunity stages.

Teams:

Business Analytics Business Intelligence Marketing Operations Product Marketing Revenue Operations Sales Management Sales Operations

Sources:

Dynamics 365 HubSpot Pipedrive Salesforce Zoho CRM

Ready to get started?

Download an MCP Server
Related Prompts:

Customer Journey Analysis for Deal Wins

View Prompt

Competitive Win/Loss Analysis by Quarter

View Prompt

Conference Speaker Candidate Research and Qualification

View Prompt