Skip to main content

Pipeline Metrics Reference

Every pipeline and forecasting metric in Weflow, what each one measures and how Weflow calculates it from your Salesforce opportunities.

Weflow calculates every pipeline metric from your Salesforce opportunities, inside the forecast configuration you are looking at, so each revenue motion, such as new logo or expansion, has its own numbers.

This reference lists the metrics on the Forecasting and Pipeline Analytics screens, what each one measures and how Weflow calculates it.

Note: The Collaborative Forecast and Roll-up read Salesforce live. Pipeline Analytics, Pacing and Forecast Accuracy run on Weflow's hourly opportunity snapshots and on up to two years of history imported from Salesforce.

How pipeline coverage is calculated in Weflow

Pipeline coverage shows how many times your open pipeline covers a target.

Pipeline coverage = Pipeline / Target

  • Pipeline: the summed amount of the open opportunities whose close date falls in the period, at every stage. Closed won deals are not part of it.

  • Target: the target the column belongs to. Admins create several named targets, such as Quota or Revenue Goal, and each target gets its own coverage column under its own name, such as Pipeline Coverage (Quota) and Pipeline Coverage (Revenue Goal). Both are the same calculation against a different target.

  • Display: a multiplier, such as 2.9x.

Example: total pipeline is €870,000 and quota is €300,000. Coverage = 870,000 / 300,000 = 2.9x.

Total pipeline coverage tile: on the Collaborative Forecast, the tile divides the pipeline by the target shown on the first tile.

Commit coverage: each target also has a Commit Coverage column, which measures the Commit forecast category against that target.

Target metrics in Weflow forecasts

Each named target adds six columns to the Targets category of the column picker, each labelled with the target's name. An admin sets targets per user by month or quarter under Admin Console > Forecasting & Analytics > Targets.

Learn more about managing quota options.

Metric

What it measures

Attainment %

Share of the target closed

Weighted Attainment

Attainment on the weighted forecast

Gap to Target

Revenue still needed to reach target

Gap to Target %

Gap to Target as a percentage

Pipeline Coverage

Open pipeline against the target

Commit Coverage

Commit category against the target

  • Attainment %: (Closed / Target) × 100.

  • Gap to Target: Target minus Closed.

  • Pipeline Coverage: Pipeline / Target.

Forecast metrics in Weflow: Collaborative Forecast and Roll-up

Metric

What it measures

How Weflow calculates it

Closed

Revenue won in the period

Sum of Closed Won deals

Commit, Best Case and other categories

Deals in that forecast category

Sum of their amounts

Stage columns

Deals in each stage

Sum of their amounts

Pipeline

Open deal value in the period

Sum of open deals, any stage

Weighted Forecast (Salesforce)

Pipeline weighted by stage

Salesforce stage probabilities

Dynamic weighting

Pipeline weighted by real win rates

Each stage's close rate, rolling window

Forecast call

The number a person submitted

Latest submission, no stage weighting

Gap to Forecast

Distance to each forecast call

One column per call

Win Rate %

Share of closed deals won

Closed deals, date range you choose

Average Deal Size (ADS)

Average deal amount

Closed deals, date range you choose

Average Contract Value (ACV)

Average size of a closed deal

Closed revenue / closed deals

Sales Cycle Length (days)

Average time to close

Days from creation to Closed Won

Forecast Accuracy

How close calls came to the outcome

Closed won / newest forecast call

  • Period: a deal counts in the one period its forecast date field falls in, usually the close date, with its full amount.

  • Forecast calls: a call sums the amount of the deals in it, without stage weighting. The Weighted Forecast and Dynamic weighting columns show the weighted numbers beside it.

  • Dynamic weighting: when an admin switches it on under Admin Console > Forecasting & Analytics > Dynamic Weighted Forecast, Weflow replaces the Salesforce stage probabilities with each stage's close rate over a rolling window, such as the last 365 days, and recalculates daily.

  • Forecast Accuracy: uses each person's newest submission for each part of the period, and measures a manager's own calls apart from their team's.

  • Win Rate %, Average Deal Size and Average Contract Value: calculated from closed deals only, over a date range you choose freely.

Pipeline Analytics metrics in Weflow

Report

What it measures

How Weflow calculates it

Waterfall

How pipeline moved between two dates

Start plus additions minus removals

Team Benchmark

Reps, teams or territories side by side

One row per rep, team summaries

Avg. Sales Cycle

Average days to close a deal

Average cycle length in days

Pipeline Velocity

How fast pipeline becomes revenue

Pipeline × deal size × win rate / days

Stage Conversion Rate

Deals moving stage to stage

From snapshots, per month

Stage Win Rate

Deals won after reaching each stage

Won / (won + lost) per stage

Opportunities Created

New pipeline added

Count or amount, by Created Date

  • Waterfall: End Pipeline = (Start + New Opps + Amount Increase + Moved In) - (Moved Out + Lost + Amount Decrease + Won). Start Pipeline is not calculated: it is the snapshot of open pipeline on the start date.

    Learn more about the Waterfall chart.

  • Team Benchmark: compares quota, attainment against commit and against closed, new pipeline generated, opportunities created, win rate, and deals won and lost, with the minimum and average for each team.

  • Pipeline Velocity: open pipeline times average deal size times win rate, divided by the average days to win.

  • Stage Conversion Rate: covers every opportunity stage in Salesforce, and you choose which stages count as starting stages.

    Learn more about stage conversion rates.

  • Stage Win Rate: counts won against won plus lost among the deals that reached each stage, so open deals do not dilute it. A deal that skipped a stage still counts as having reached it.

  • Opportunities Created: groups deals by their Salesforce Created Date and converts amounts to your corporate currency, at dated rates when advanced currency management is on.

Frequently asked questions about pipeline metrics in Weflow

Is pipeline coverage against quota different from coverage against revenue goal?

No. Both divide the same open pipeline by a target. Quota and Revenue Goal are two named targets, so each has its own Pipeline Coverage column.

Does pipeline coverage include closed won deals?

No. Pipeline counts only open opportunities whose close date falls in the period. Closed won revenue shows in the Closed column and in Attainment %.

Why does a Weflow pipeline metric differ from my Salesforce report?

Weflow calculates every metric inside the forecast configuration: its amount field, its date field and the filters the admin set on it. A Salesforce report with a different amount field, date field or filter counts a different set of deals.

Can I add my own pipeline metric to a Weflow forecast?

Yes. An admin builds a calculated column from other forecast columns, the target and plain numbers with + - * / and parentheses, shown as currency, percent or ratio. Calculated columns are computed at every level of the hierarchy and included in CSV and XLSX exports.

Did this answer your question?