Report · 2019-11-02
· 2405d
Using Opportunity Histograms to Identify Pipeline Distribution Problems
This article argues that while opportunities-per-sales-rep is a useful pipeline metric, it can be misleading because averages hide uneven distributions across the team. The author uses histogram visualization to reveal pipeline gaps and proposes three solutions: generating more opportunities, reducing rep headcount, or reallocating opportunities from overloaded to underutilized reps.
Metrics in this report
All Quarters Pipeline - Mean
16.6opportunities
mean
Illustrative example company across all reps
Current Quarter Pipeline - Mean
7.1opportunities
mean
Illustrative example company across all reps
Reps Meeting All Quarters Target
8 out of 15reps
count
In illustrative example
Reps Meeting Current Quarter Target
4 out of 15reps
count
In illustrative example despite healthy average
Target Opportunities Per Rep (All Quarters)
16opportunities
minimum threshold
For successful salesrep performance (illustrative example)
Target Opportunities Per Rep (Current Quarter)
7opportunities
minimum threshold
For successful salesrep performance (illustrative example)