How to Calculate Marketing Sourced Pipeline Percentage

How do you calculate marketing sourced pipeline percentage?

Divide the value of qualified opportunities whose first touch came from a marketing channel by the total value of qualified opportunities created in the same period.

``` Marketing sourced % = Marketing sourced pipeline value / Total pipeline created in period ```

Two details make or break the calculation. Use opportunity creation date to bound the period, because sourcing describes where pipeline originated rather than when it closed. And apply the same qualification bar to every channel, since counting marketing opportunities at a looser stage than outbound ones produces a number that measures record-keeping rather than demand.

What counts as marketing sourced?

An opportunity where the first recorded touch on the account was a marketing-owned channel, under a rule you set once and stop changing. Inbound demo requests, content downloads that converted, paid search clicks, and event registrations are the usual inclusions. Cold outbound to a cold account is the usual exclusion.

The gray cases are where teams argue: an SDR calling into an account that attended a webinar six months ago, or an inbound request from a target account already in an outbound sequence. Pick a rule, write it in the metric definition, and apply it to everything. Any consistent rule produces a usable trend. A rule that shifts mid-year produces a chart nobody can interpret, because the movement reflects the definition rather than the business.

Freeze the sourcing field at opportunity creation and prevent later edits. Sourcing that can be overwritten in month three stops being a measurement and becomes a negotiation.

Should you measure dollars or deal count?

Report both, because they answer different questions and separate more than most teams expect. Those figures illustrate the calculation, not a benchmark. Run it on your own created pipeline and the shape will differ.

Marketing sources 49% of opportunities by count and 33% by dollars, because its deals are smaller. It then delivers 30% of closed revenue, because its win rate sits slightly above the outbound rate and well below partner and expansion.

The expansion row is the sharpest illustration. It contributes 12% of pipeline and 28% of revenue on 26 opportunities. Any conversation about channel investment that reads only the pipeline column will underfund it. Pull win rate by source into the same table so the pipeline share and the revenue share sit side by side.

How do you handle deals with multiple touches?

Sourcing is a single-attribution question, so pick first touch and keep influence measurement in a separate report. An opportunity has one source. Splitting a deal across three channels turns sourcing into a fractional attribution model, and fractional models cannot be summed against a pipeline target without double counting.

Run influence as its own metric with its own definition, typically the share of closed revenue that had any marketing touch at any point. That number will be much higher than the sourced number, and it should be. Reporting the two in the same column is where most pipeline attribution arguments start.

What target should the number hit?

Derive it from your own revenue plan rather than importing a percentage from another company. The calculation is straightforward: take the share of quota marketing is responsible for, multiply by the coverage ratio your conversion rate requires, and the result is a dollar target that converts into a percentage of expected total pipeline creation.

A company where marketing owns 40% of a $20,000,000 target and needs 3.5x coverage on its channels requires $28,000,000 of marketing sourced pipeline. Whether that lands at 30% or 55% of total creation depends on how much pipeline the other channels produce, which is not something a benchmark can tell you. The required multiple varies by channel too, since a channel converting at 34% needs far less volume than one converting at 19%. That inverse relationship is the basis of pipeline coverage.

Why does the number move without anything changing?

Deal amounts and aged opportunities move it more often than campaign performance does.

Amounts entered at creation are frequently larger than what closes. For example, a pipeline averaging $80,000 per deal against closed-won deals averaging $40,000. When that inflation runs unevenly across channels, the sourced percentage shifts on data entry habits. Compare the average created amount by source against the average closed-won amount by source, and correct the channel that runs furthest apart.

Aged pipeline distorts the denominator the same way. Across ORM customers, 10% or more of open pipeline has not been touched in 12 months, where a touch means a change in stage, close date, or amount. If those opportunities skew toward one channel, that channel's share is propped up by deals that will never close.

What else should you check before acting on it?

Whether the shift is a sourcing change or a market change. A new competitor creating pricing pressure lowers average deal size, which lowers the dollar share of whichever channel serves that part of the market, without any drop in campaign performance. Buyer uncertainty lengthens the path from qualified to closed, which delays conversion in longer-cycle channels and makes them look weaker in any single quarter.

Read the sourced percentage alongside opportunity count, average deal size, and win rate by channel. If the percentage moved but all three inputs held, the change is mix. If deal size fell across every channel, the change is the market, and reallocating budget between channels will not fix it. Building that decomposition into the planning process is covered in sales forecasting best practices.