Pipeline Value: Total value of open sales opportunities, weighted by stage probability unless stated as unweighted.
Formula
Pipeline Value = Sum of (Deal value × Stage probability) for all open opportunitiesPipeline Value = Sum of (Deal value) for all open opportunitiesComputable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
sum(field.opportunity_amount * field.stage_probability where field.opportunity_stage not in ('closed_won', 'closed_lost'))Unit: currency
- Unweighted variant
sum(field.opportunity_amount where field.opportunity_stage not in ('closed_won', 'closed_lost'))
Notes: Weighted form is the main formula. Always state weighted or unweighted.
Data requirements
Grain: Daily snapshot · Frequency: Daily sync · Aggregation: snapshot (day) · Staged: no · Main source: CRM.
| Field | Dataset | Type |
|---|---|---|
opportunity_amount | opportunity | decimal |
opportunity_stage | opportunity | string |
snapshot_date | opportunity | date |
stage_probability | opportunity | decimal |
Example SQL (Postgres)
SELECT (SELECT COALESCE(SUM((opportunity_amount * stage_probability)), 0) FROM opportunity WHERE snapshot_date = :period_end AND opportunity_stage NOT IN ('closed_won', 'closed_lost')) AS pipeline_value Access: recommended
sensitivity tier confidential,
access scope owner-scoped.
Guidance your policy engine enforces.
From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Pipeline Value" }) or generate_query({ "metric": "Pipeline Value", "adapter": "<your adapter JSON>" }).
What It Tells You
The potential revenue if deals close at expected rates.
Related Metrics
Connected in the GASP relationship graph.
Upstream: what drives this
- SQLs drives Pipeline Value (Marketing)
- Partner-Sourced Revenue drives Pipeline Value (Partnerships)
- Product Qualified Accounts drives Pipeline Value (Product)
Downstream: what this drives
- Pipeline Value drives New MRR (Core)
- Pipeline Value measures Opportunity (Entity)