The Calculation, Step by Step
1. Set the window. Decide the lookback period between a marketing touch and the opportunity create date. Ninety days works for most reporting, twelve months for enterprise segments. 2. Define a qualifying touch. Pick a threshold that indicates real engagement, such as a form submission or an event registration by a contact tied to the opportunity. 3. Match contacts to opportunities. Roll contact-level touches up to the account, then to the open and closed opportunities on that account. This step is where most implementations break. 4. Filter out stale records. Drop opportunities with no meaningful change for twelve months before summing. 5. Sum opportunity amounts per channel. Report each channel separately. Do not add them.
Why the Raw Number Overstates Value
Influenced pipeline is measured at CRM opportunity value, which is consistently higher than what deals actually close for. ORM's position is that most deals close for less than the value carried in the CRM. The illustration Pete uses is a pipeline carrying an average deal size of $80,000 against closed-won deals averaging $40,000. Timing compounds it. On the first day of a quarter, roughly 20% of the pipeline dated to close in that quarter actually closes in it, so 80% of the value visible on day one is not realized in the period.
Stale records make it worse. ORM applies a twelve-month rule for most customers, and a typical customer carries 10% or more of pipeline with no change in stage, close date, or amount over that period. Include those and you are reporting influence over dead deals.
Report It Honestly
| Weak version | Better version |
|---|---|
| Marketing influenced $12M of pipeline | Paid search touched 34 of 91 open opportunities worth $4.1M at CRM value |
| Marketing influenced 78% of revenue | 78% of closed-won deals had at least one qualifying touch in the 90-day window |
Where It Fits
Influenced pipeline is a diagnostic for program reach, not a coverage input. Do not feed it into pipeline coverage math or a commit number. If you need a value-adjusted view of what the pipeline is worth, use stage probabilities instead, as covered in weighted pipeline. And treat any coverage-derived conclusion carefully for the reasons laid out in the 3x pipeline coverage rule is wrong.
Frequently Asked Questions
What is the formula for influenced pipeline?
Influenced pipeline equals the sum of opportunity amounts for all opportunities where at least one associated contact had a qualifying marketing touch within the attribution window. Each opportunity is counted at full value in every channel that qualifies.
Can influenced pipeline exceed total pipeline?
Yes, when you add channels together, and that is expected. A single deal touched by four channels contributes its full amount to four channel totals. Report influenced pipeline per channel and never sum across channels.
What counts as a qualifying touch?
Define it in writing before you build the report. Common thresholds are a form submission, an event attendance, or a content download by a contact associated with the opportunity. An email open is too weak a signal to qualify.
Should influenced pipeline include stale opportunities?
No. Opportunities with no change in stage, close date, or amount for twelve months should be excluded, otherwise the report credits marketing for pipeline that will not convert.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like how do you calculate influenced pipeline? into prescriptive action for your team.
Schedule a Demo