Weekly Sales Pipeline Health Analysis

Track and analyze the sales pipeline health, focusing on opportunity progression, conversion rates, and overall pipeline value to support revenue forecasting and identify areas for sales optimization.

Report Objective

Monitor and analyze weekly changes in sales pipeline health metrics including total pipeline value, win rates, and stage progression to identify trends, risks, and opportunities for improving sales effectiveness and revenue predictability.

Pipeline Value and Win Rate Trends

Line chart showing weekly pipeline value and win rate trends

Questions to Consider:

2024-W402024-W442024-W48week$3,300,000$3,400,000$3,500,000$3,600,000$3,700,000$3,800,000total_pipeline_valueHow is Total Pipeline Value Trending?Pipeline value showing week-over-week movement with 13-week history
  • What is the week-over-week change in total pipeline value?

  • How does the current pipeline compare to the same period last quarter?

  • Is the pipeline value sufficient to meet quarterly targets?

  • Are win rates showing any concerning trends?

  • How do current win rates compare to historical benchmarks?

  • What factors might be influencing win rate changes?

2024-W402024-W442024-W48week22.0%24.0%26.0%win_rateHow are Win Rates Performing?Weekly win rate trends and variance analysis

Opportunity Stage Distribution

Bar chart showing opportunity distribution across stages

Questions to Consider:

DiscoveryProposalNegotiationClosed WonClosed Loststage_name05001,0001,500sum(opportunity_count)How are Opportunities Distributed Across Stages?Current distribution of opportunities by sales stage
  • Are there any concerning imbalances in the pipeline?

  • Which stages show the highest concentration of opportunities?

  • How does the current distribution compare to ideal ratios?

  • Which stages show the highest drop-off rates?

  • Are there any stages showing unusual conversion patterns?

  • How do conversion rates compare to historical benchmarks?

DiscoveryProposalNegotiationClosed WonClosed Loststage_name0.0%500.0%1000.0%sum(conversion_rate)What are the Stage-to-Stage Conversion Rates?Conversion rates between pipeline stages

Deal Size Analysis

Histogram of deal sizes with trend analysis

Questions to Consider:

2024-W402024-W442024-W48week$96,000$98,000$100,000$102,000$104,000$106,000average_deal_sizeHow is Average Deal Size Trending?Distribution of deal sizes across the pipeline
  • How is average deal size trending week-over-week?

  • Are there enough large deals to meet revenue targets?

  • What is causing changes in average deal size?