RevOps doc · Measuring Metrics

Weighted Pipeline

Weighted pipeline applies each stage's historical conversion rate to open opportunity value, producing a forecast that reflects real probability rather than deal count. Paired with a coverage ratio — pipeline divided by target — it answers both what the quarter is likely to deliver and whether enough pipeline exists to deliver it.

MethodWhat we prescribe. Our delivery standard for this motion.
3Min read

#Weighted Pipeline and Coverage

A clear understanding of your sales pipeline is crucial for accurate forecasting and goal setting. Traditional pipeline management involves simply adding up the values of all opportunities in your pipeline, which can give a misleading picture of your true sales potential. This is where the concept of weighted pipeline and coverage comes into play.

Weighted pipeline is a more sophisticated approach to pipeline management that takes into account the stage of an opportunity, historical conversion rates, and deal health. By incorporating these factors, you can gain insights into the likelihood of closing deals and make informed decisions about resource allocation and forecasting.

#Calculating Weighted Pipeline

To calculate your weighted pipeline, follow these steps:

1. Identify the key factors that influence deal conversion: First, let's pinpoint the factors that weigh most heavily on the likelihood of a successful close. These could be the stage of the opportunity, the size of the deal, the segment of the customer, and the performance of the sales representative.

2. Determine historical conversion rates: By analyzing past sales data, you can determine the historical conversion rates for each stage of your sales pipeline. This will give you a clear understanding of how likely an opportunity is to move forward.

3. Assign weights to each factor: Based on our analysis, we assign weights to each factor. For example, we might assign a higher weight to later stages of the pipeline since they have a higher probability of closing.

4. Calculate weighted pipeline: Multiply the value of each opportunity by its corresponding weight to calculate the weighted pipeline value.

#Calculating Coverage Ratio

The coverage ratio is a simple calculation that compares your weighted pipeline to your sales quota. It’s a great way to see if you have enough pipeline to hit your revenue goals. To calculate the coverage ratio, divide your weighted pipeline by your sales quota.

#Using Weighted Pipeline and Coverage for Planning and Forecasting

Weighted pipeline and coverage metrics are essential for effective planning and forecasting. Here are a few ways you can use these metrics:

1. Assess pipeline health: Weighted pipeline and coverage ratios give us a clear picture of the strength of our sales pipeline. By keeping a close eye on these metrics, we can spot potential gaps and take proactive steps to keep our pipeline healthy.

2. Set realistic sales targets: Weighted pipeline helps us set realistic sales targets based on our historical conversion rates and deal health. This ensures that our sales team is focused on pursuing high-quality opportunities that have a greater chance of closing.

3. Allocate resources effectively: Weighted pipeline allows us to distribute our resources, like our sales reps and marketing efforts, in a more effective manner. This way, we can concentrate on opportunities with the greatest potential for success.

4. Improve forecasting accuracy: Weighted pipeline and coverage metrics are invaluable for sales forecasting. They allow us to consider factors such as stage, conversion rates, and deal health, leading to more precise forecasts and better-informed business decisions.

Weighted pipeline and coverage are powerful metrics that can significantly improve the effectiveness of your RevOps team. By incorporating these metrics into your sales pipeline management process, you can gain a deeper understanding of your sales potential, set realistic goals, and make data-driven decisions for success.

Connected

In the knowledge graph

Every entity below has its own page, aggregating what we measured, what we recommend and what guests said.

Related

More on these topics

Method Revenue Systems

Executive GTM Reporting

Every Executive GTM Reporting project moves through the same four phases. This is a project you win in the Blueprint — by the time you're building cha…

22 sections · 18 min read
Proof Reporting, Forecasting & Board Metrics

Rebuilding board-ready pipeline reporting when the numbers on the deck were never the same twice

A PE-backed technology company ran leadership and board reporting out of spreadsheets and a bolt-on forecasting tool while nobody trusted the underlyi…

3 sections · 6 min read
Proof Reporting, Forecasting & Board Metrics

Making renewals tell the truth: committed volume, overage and net ARR change on the account

A B2B software company priced on a mix of fixed and consumption components across multi-year contracts that stepped up and down. The CRM held one ARR …

3 sections · 4 min read
Proof Reporting, Forecasting & Board Metrics

Retiring the spreadsheet: computing marketing's sourced and influenced share natively

A PE-backed financial-services platform's marketing team was assembling attribution by hand in spreadsheets and could not fully defend its dashboards.…

3 sections · 2 min read
Proof Reporting, Forecasting & Board Metrics

Forecasting off an inherited spreadsheet, until the revenue book was rebuilt in the CRM

A business line was reporting monthly recurring revenue out of a personal spreadsheet left behind when the role turned over. LeanScale rebuilt the sub…

3 sections · 2 min read
Proof Reporting, Forecasting & Board Metrics

Stopping deals from hiding forever in 'omitted'

Forecast hygiene had eroded at a long-established enterprise software company: large deals sat open indefinitely in an omitted category with no activi…

3 sections · 2 min read