Sales Pipeline Concentration: How Much Depends on a Few Deals?

A pipeline can contain plenty of opportunities while most of its value sits in one buying decision. Before a review, calculate the share held by the largest deal and the largest few deals. Then repeat the calculation by customer group when several opportunities depend on the same buyer.

Pipeline concentration measures how much of the selected amount sits in a few opportunities or customer groups. Use the shares to choose which dependencies to discuss; assess the likelihood of closing separately. A large opportunity with a confirmed buying process and a large opportunity with an unknown next step can have the same concentration figure.

Define the pipeline you are measuring

Start with a saved list at a stated cutoff. For example, use open opportunities with an expected close date in the current quarter, as recorded at Friday's review. Save the opportunity IDs and amounts with that snapshot. Next week's current view may have different dates and values.

Choose one amount definition for the whole list. Annual recurring value and full contract value answer different questions. Don't add one deal's annual amount to another deal's three-year total. If the list contains several currencies, use a consistent reporting currency and keep the conversion basis with the snapshot. An amount without a known basis needs checking before it belongs in the calculation.

The denominator is the total amount of the eligible opportunities. Include the smaller deals as well as the ones you intend to discuss. Computing a large-deal share from an export already filtered to large deals would describe that subset, not the full pipeline.

Keep the scope beside the result: open opportunities, quarter, amount definition, currency and cutoff. If your question concerns the Commit forecast category, calculate that category separately and label it. A share of all open pipeline and a share of Commit may differ even when both are correct.

Calculate the largest-deal shares

Sort eligible opportunities by amount, from largest to smallest. Divide the largest amount by the total to get the largest-deal share. For a top-three share, add the three largest amounts and divide their sum by the same total.

Here is a fictional quarter-end pipeline. Amounts are in thousands of one reporting currency and use the same contract-value definition. All five opportunities are open at the cutoff.

The largest opportunity holds 240 ÷ 600 = 40% of the amount. The three largest hold (240 + 120 + 90) ÷ 600 = 75%. C and D tie for third place. Either produces the same top-three amount; show the tie if you list the deal names so the choice doesn't look like a judgment about which one is more likely to close.

One opportunity holds 40% of this pipeline, and three hold 75%. Neither percentage is a forecast probability. The top-three share doesn't mean those opportunities have a 75% chance of closing, and the largest deal's share doesn't say it needs 40% of the team's calling time.

Choose how many deals to show based on the review's question. A manager discussing the next three buying decisions can use top three. Keep that number consistent when comparing snapshots. If only two opportunities are eligible, label the result “both opportunities” rather than hiding the small count behind a top-three heading.

Group deals that share a buying decision

Opportunity A and E in the example belong to North. Looking only at opportunity size understates how much of the quarter depends on that customer group. Add the amounts within each group before sorting them:

North holds 300 ÷ 600 = 50% of the amount. The three largest groups hold (300 + 120 + 90) ÷ 600 = 85%. South and West tie at the boundary again. Grouping didn't create more pipeline: the total is still 600. It changed the unit you ranked.

Decide what the group means before combining records. A shared parent account may be a useful starting point, but two subsidiaries could have independent budgets and decisions. Conversely, two account records may belong to one purchasing process. Confirm the relationship with the account owner. Don't merge records simply because their names look similar.

Record both opportunity and group results when each answers a real question. The unit-of-analysis guide explains why a report changes when its row represents a different thing. In this example, five opportunity rows become four customer-group rows without changing their total value.

Show one delay scenario beside the shares

Suppose opportunity A moves out of the quarter while every other amount and close date stays fixed. The quarter's open pipeline would fall from 600 to 360, a reduction of 240. That is a stated scenario for the saved list, not a prediction that A will move.

If both North opportunities move, the remaining amount would be 300. Keep those scenarios separate. The second assumes a shared change affecting A and E; it isn't a second independent risk to add to the first. Adding their reductions would count A twice.

Use the scenario to ask about the actual dependency. Are A and E waiting for one budget decision? Does each have its own review date? What would the owner need to learn before the next meeting? A concentration percentage identifies where a delay would matter to the total. The account discussion establishes whether the assumed dependency is plausible.

Don't treat the remaining amount as expected revenue. The other opportunities still have their own buying decisions. If the review also uses pipeline coverage, keep the target and amount basis consistent and show coverage as a separate calculation. Concentration describes where the amount sits; coverage compares an amount with a target.

Check the rows before comparing weeks

A duplicate opportunity can inflate the total and change every share. Use the stable opportunity ID to check duplicates, then investigate rows whose amounts conflict. Several legitimate opportunities at one account can stay separate in the opportunity calculation and combine in the customer-group calculation.

Missing values deserve a visible note. A blank amount is unknown, not automatically zero. If you exclude it while someone checks the record, state how many opportunities are missing amounts and describe the reported shares as applying to known amounts only. A zero-value opportunity contributes no amount but may still belong in a separate count.

When the eligible total is zero, an amount share is undefined. Show the zero total and explain that no percentage was calculated. Negative adjustments or credits need a clearly defined treatment; don't quietly mix them with positive opportunity amounts and call the result ordinary open-pipeline concentration.

For a week-to-week comparison, hold the scope and calculation steady. A changed close date can move a deal out of the list without losing the deal. A newly split opportunity can change opportunity-level shares without changing customer-group exposure. The pipeline reconciliation guide helps explain additions, removals and amount changes before you interpret the new percentage.

Bring a short concentration note to the review

Download the blank concentration worksheet to keep the snapshot definitions, shares and one delay scenario together.

Copy this worksheet for a single snapshot:

Snapshot cutoff and reporting period:
Eligible opportunity rules:
Amount definition and reporting currency:
Eligible opportunity count and total amount:
Largest opportunity amount / share:
Top-N opportunity amount / share, with N stated:
Customer-group definition and unresolved relationships:
Largest group amount / share:
Top-N group amount / share:
Missing amounts, duplicates or exclusions:
One named delay scenario and remaining amount:
Dependency to confirm, owner and next update:

Keep the saved opportunity list with the note so another person can reproduce the numerator and denominator. Set any review threshold in the context of your own pipeline. The worksheet supplies the calculation; the team still needs to understand the buying decision behind each large share.

For the fictional pipeline, the review starts with North's two opportunities: 50% of the saved amount, one possible shared dependency to investigate, and separate outcomes still to confirm. Ask the account owner what would settle that dependency before the next review.