Goal:
Establish baseline performance metrics and overall conversion rates to provide context for deeper stage-by-stage analysis.
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:
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.
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:
Understand stage-to-stage progression efficiency and identify bottlenecks where opportunities stall or drop out of the pipeline most frequently.
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:
Transform analytical insights into actionable recommendations for sales process optimization, resource allocation, and targeted coaching to improve overall pipeline performance.
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:
Provide executive-level summary with complete pipeline health assessment and strategic recommendations for improving sales effectiveness across all opportunity stages.
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.
