top of page

Ad-Sourced Pipeline: Separate Open Deal Value, Won Work and Customer Revenue

Writer: DIGITALTHROB
DIGITALTHROB
Nov 6
3 min read

Open pipeline reports potential work, not revenue already earned or money received. A weighted forecast, a won agreement, finance-recorded customer revenue and cash receipts describe different views of that work. We keep the definitions and dates beside the figures so an attractive pipeline total does not become an unsupported advertising result.


An amber receipt roll and coral return arrow stand beside cobalt accounting blocks on a mint surface.

Define what each number answers


For this operating review, open pipeline is the current potential amount of included opportunities still open on the review date. State the inclusion rule, currency and treatment of estimates. A quote awaiting acceptance and a rough estimate awaiting scope can both be open, but they do not carry the same degree of certainty.


Won value is the agreed amount for opportunities meeting the business’s documented won criterion. It does not establish completed delivery or payment. Take customer revenue from the business’s financial records under its applicable reporting treatment, rather than deriving a revenue rule from a sales-stage label.


Cash received answers a further question: what has actually been paid? Connect these views to opportunity identifiers where possible while retaining their own dates. They can explain the progress of the same work; adding them together usually counts that work more than once.


Give each opportunity one current value


Use a stable identifier, preserve acquisition information and show the current scope, value, stage and expected decision. Distinguish a quoted amount from an estimate awaiting clarification.


When a quote changes, replace its current amount and retain the superseded version as history. Our quote revision guide explains that boundary. A $4,000 quote revised to $6,000 creates one current $6,000 opportunity, not two opportunities worth $10,000.


Salesforce’s forecasting guidance recommends maintaining opportunity-level detail and grounding close probabilities in historical data. That supports a forecast review; it does not make an individual open deal certain to close.


Reconcile five fictional opportunities


Imagine one fixed group of enquiries acquired through advertising. The following positions, amounts and outcomes are fictional:


  • A: open, current quote $6,000; its previous $4,000 version is superseded.

  • B: open, $10,000 proposal under discussion.

  • C: open, estimated $4,000 pending clarification of scope.

  • D: won agreement $8,000; finance has recorded $3,000 of customer revenue by the review date, and $2,000 has been received.

  • E: lost, previously valued at $5,000; excluded from the current open pipeline.


The open pipeline is A + B + C: $6,000 + $10,000 + $4,000 = $20,000 across three opportunities. D contributes to the won view, not that open total. E remains in the outcome history but contributes nothing to the current open value.


The snapshot therefore shows $20,000 open, $8,000 won, $3,000 recorded customer revenue and $2,000 received. Those are different states and dates, not four independent streams of value. In particular, D’s agreement, recorded revenue and receipts must not become $13,000 of sales by addition.


Calculate weighting without hiding its assumptions


A weighted view multiplies each included open amount by an assigned closing probability and totals the contributions. Tableau’s weighted pipeline definitions distinguish open pipeline amount from open amounts weighted by closing probability.


For arithmetic only, assign A 25%, B 60% and C 20%. The contributions are $1,500, $6,000 and $800, producing an $8,300 weighted open estimate. These invented probabilities are not benchmarks, validated forecasts or recommended settings.


The $20,000 gross view and $8,300 weighted view describe the same three open opportunities. Adding them to claim $28,300 of extra sales would double-count two descriptions of the pipeline. If the probabilities lack a defensible basis, identify the calculation as experimental; a precise total does not establish reliable prediction.


Explain movement and acquisition separately


Keep a dated snapshot so the next review can explain why the total changed. A larger pipeline could reflect a revised quote, more estimates or delayed decisions as well as useful new demand. Compare the underlying opportunities before treating the increase as progress.


Also distinguish opportunities credited to advertising under the chosen source rule from proof that advertising caused every eventual sale. Keep source limitations visible. Our advertising cash-flow guide explains why expected sales do not establish when money is available to fund the work.


Turn the snapshot into a spending decision


A completed fictional review could read: “The $20,000 open total does not by itself support the proposed spending increase. C still needs a defined scope, while A and B remain undecided. D has an $8,000 won agreement, with $3,000 recorded revenue and $2,000 received by this date. Review its delivery economics and payment position using the appropriate records before deciding what additional demand the business can support.”


Explore DigitalThrob’s paid advertising agency services to connect campaign reporting with that wider commercial review. Bring a dated opportunity snapshot and the definitions behind it, so recorded outcomes and work still to be won remain clear.


 
 
 

Comments


Discover clics solution for the efficient marketer
More clics

Never miss an update

bottom of page