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.

6 metrics· Cited 0× in the knowledge base ·Open source ↗

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)