What's the math for source-of-pipeline in a land-expand-renew motion? How do we separate sourced ARR from internal growth in 2027?

A concrete scenario that frames the problem

Picture a $5M ARR SaaS company at the start of 2027. The board deck shows 22% growth and leadership celebrates. Underneath, the math is ugly. New logos contributed $500k, expansion contributed $800k, and churn removed $200k. Net growth lands at $1.1M — the 22% headline. But $800k of that came from customers already in year two or three of their lifecycle, sold last year, expanded this year. If new logo acquisition stalls again in 2027, that expansion does not repeat. The company is burning its installed base to fund a growth number that masks a broken top-of-funnel.

Now flip the scenario. Same $5M base, but new logos contribute $1.2M, expansion $400k, churn -$200k. Net growth is $1.4M — 28%. Lower headline than the first case, but the engine is healthier. The new-logo cohort seeds next year's expansion and the year after's renewal. The math for source-of-pipeline exists precisely to expose which scenario you are actually running. A blended growth rate cannot tell you. Three separate buckets can.

The 2027 wrinkle: buying committees are smaller, cycles are longer, and inbound volume is noisier because AI-generated content has flooded every channel. That makes source tagging harder and more important. If you cannot separate sourced ARR from internal growth, you cannot tell whether your RevOps motion is compounding or cannibalizing.

How the mechanism actually works

The core mechanism is entry-point tagging at the opportunity level, not the account level. Every closed-won dollar gets exactly one primary tag assigned the moment the opportunity is created — not retroactively, not by a data-cleanup intern in Q4.

Three buckets, defined by entry point:

• New Source (sourced ARR): A logo that did not exist in your customer base before this deal. Sourced by an SDR, an AE, a partner, inbound marketing, or product-led self-serve. This is the only bucket that adds net-new customers.
• Expansion: An existing customer increasing ARR — seats, usage tiers, cross-sell, or a new business unit. No new logo.
• Renewal: An existing customer renewing at roughly the same ARR. Flat renewal is a retention event, not a growth event.

The formula chain:

1. Sourced ARR = sum of closed-won ARR where entry_point = new_source, grouped by originating channel (SDR, AE, partner, inbound, PLG).
2. Expansion ARR = sum of closed-won ARR where entry_point = expansion.
3. Renewal ARR = sum of closed-won ARR where entry_point = renewal, at the contracted value.
4. Gross additions = Sourced ARR + Expansion ARR. (Renewal is excluded — it is not an addition.)
5. Net new ARR = Gross additions − Churn − Contraction.
6. Sourced share of gross additions = Sourced ARR ÷ Gross additions. This is the cleanest mix metric because churn does not distort it.
7. Internal growth = Expansion ARR + Renewal ARR movement (upward renewals only; downward renewals are contraction, counted against churn).

The critical discipline: a dollar can only live in one bucket. If a partner sourced a logo in 2025 and that logo expands in 2027, the 2027 expansion is tagged expansion, not partner-sourced. The partner gets credit for the original land; the expansion belongs to the customer-success or account-management motion that drove it. This is where most companies double-count and inflate sourced ARR.

Two implementation details that make or break the math. First, tag at opportunity creation, and lock the tag once the deal closes. Retroactive re-tagging destroys trend integrity. Second, store the originating channel as a separate field from the entry point. Entry point answers "what kind of revenue is this?" Channel answers "who gets credit?" Conflating them is the single most common RevOps modeling error in land-expand-renew shops.

Real numbers, ranges, and benchmarks

The mix varies wildly by segment, ACV, and motion. What follows are directional ranges practitioners commonly observe — treat them as planning anchors, not universal truths, and calibrate to your own cohort data.

New logo share of gross additions:

• Early-stage SaaS (sub-$10M ARR): 60–75% new source. Expansion base is too small to matter yet.
• Growth-stage SaaS ($10M–$50M ARR): 40–55% new source. Expansion becomes a real lever.
• Scale-stage SaaS ($50M+ ARR): 30–45% new source. Installed base dwarfs new-logo capacity.
• Top-quartile performers across stages: 50–60% new source of gross additions, with expansion under 40%.

Expansion share of gross additions:

• Healthy: 35–50%.
• Overreliant on upsell: 60%+. This is the warning zone — it usually means new-logo acquisition is underfunded or underperforming.
• Underperforming: under 25%. You are leaving money on the table in the installed base.

Churn and contraction as a share of starting ARR:

• SMB SaaS: gross churn 15–25% annually.
• Mid-market SaaS: gross churn 8–15% annually.
• Enterprise SaaS: gross churn 4–8% annually.
• Net revenue retention (NRR): SMB 88–96%, mid-market 100–110%, enterprise 115–128%.

The math that matters most for 2027 planning: if your NRR is 105% and your new-logo ARR is flat year over year, your growth rate is decaying. NRR above 100% only buys you time — it does not compound without new logos feeding the base. A company with 105% NRR and zero new logos grows 5% per year and shrinks in real terms against inflation. A company with 95% NRR and 30% new-logo growth outpaces it within two years.

Cohort waterfall example. A Year-1 cohort lands at $500k ARR. In Year 2 it renews at $500k plus $200k expansion — $700k. In Year 3 it renews at $700k plus $150k expansion — $850k. A Year-2 cohort lands at $600k, renews in Year 3 at $600k plus $180k expansion — $780k. As of Year 3, sourced ARR from these two cohorts is $1.1M, expansion ARR is $530k, and renewal ARR is $1.3M. Total ARR from the two cohorts is $2.93M. The sourced share of that total is 38%. If leadership only saw "$2.93M ARR," they would miss that 62% of it depends on retaining and expanding customers who were already sold.

CAC math splits by bucket. New-source ARR carries full customer acquisition cost — SDR salary, marketing spend, AE commission, tooling. Expansion ARR carries near-zero CAC; it is driven by customer success and account management, which are retention costs, not acquisition costs. Renewal ARR carries retention cost only. If you blend CAC across all three, your new-logo CAC looks artificially low and you will overinvest in expansion motions that cannot scale without a fresh base.

Trade-offs and alternatives

The three-bucket model is not the only way to slice source-of-pipeline. Each alternative has a specific trade-off.

First-touch attribution vs. multi-touch. First-touch is simple and auditable — the first recorded touch gets the credit. Multi-touch spreads credit across every interaction. First-touch understates marketing's contribution in long enterprise cycles; multi-touch is opaque and easy to game. For source-of-pipeline math specifically, first-touch is usually the right default because the question is "where did this revenue originate," not "who helped."

Opportunity-level tagging vs. account-level tagging. Opportunity-level is more precise but requires CRM discipline. Account-level is easier but breaks down when a single account has both sourced and expanded revenue in the same period. In land-expand-renew shops, opportunity-level is non-negotiable.

Gross vs. net reporting. Reporting sourced ARR as a share of gross additions is cleaner than as a share of net new ARR, because churn distorts the denominator. But boards often want net. The fix: report both, and label them explicitly. "Sourced share of gross additions" and "sourced ARR as % of net new ARR" are different metrics and should never share a slide without labels.

Cohort slicing vs. period slicing. Period slicing (this quarter's sourced ARR) is fast and useful for operating cadence. Cohort slicing (this vintage's sourced ARR over time) is slower but reveals whether your land motion is actually seeding future expansion. Both are needed; neither replaces the other.

The 2027-specific trade-off: AI-assisted prospecting has made raw pipeline volume cheap and qualification expensive. If you count sourced ARR by pipeline created rather than pipeline converted, you will overstate your engine. The math must anchor on closed-won ARR by entry point, not on pipeline dollars created.

The practical recommendation: use first-touch attribution with opportunity-level entry-point tagging, report sourced share of gross additions as the primary mix metric, and layer cohort slicing quarterly to catch decay early.

Common pitfalls and how to avoid them

Pitfall 1: Counting renewal ARR as growth. A flat renewal is not growth. If your board deck shows "renewals contributed $2M to ARR," that is a retention statistic, not a growth statistic. Fix: keep renewal out of gross additions entirely. Renewal is a retention metric. Only upward renewal movement (a customer renewing at a higher contracted value) counts as expansion.

Pitfall 2: Double-counting sourced ARR across years. A partner-sourced logo in 2025 that expands in 2027 must not be counted as partner-sourced again in 2027. Fix: lock the entry-point tag at close. Expansion is expansion, regardless of who originally sourced the logo.

Pitfall 3: Using net new ARR as the denominator for sourced share. Net new ARR subtracts churn, which inflates the sourced percentage. A company with $500k new logos, $200k expansion, and -$300k churn shows $400k net new. Sourced share against net new looks like 125% — mathematically impossible and misleading. Fix: use gross additions (sourced + expansion) as the denominator.

Pitfall 4: Ignoring first-year expansion as embedded undersell. If a new logo closes at $100k and expands to $120k within twelve months, that $20k is often an initial undersell, not genuine expansion. Fix: model expected first-year expansion into the new-source target, and count expansion only from year two onward.

Pitfall 5: Blending CAC across buckets. New-source CAC and expansion CAC are fundamentally different. Blending them hides the true cost of new-logo acquisition. Fix: report CAC separately for new source and expansion.

Pitfall 6: Tagging retroactively. If tags are assigned in Q4 cleanup, they reflect whoever had the best memory, not the truth. Fix: make the entry-point field required at opportunity creation, with a picklist and no default.

Pitfall 7: Confusing channel with entry point. "Partner-sourced" is a channel. "New logo" is an entry point. A partner can source a new logo, an expansion, or a renewal. Fix: two separate fields, always.

Pitfall 8: Reporting one blended growth rate to the board. This is the root cause of every other pitfall. Fix: report three metrics — sourced ARR, expansion ARR, and net revenue retention — as separate lines. The blend is a summary, never the primary number.

Related questions

How do you tag an opportunity that was sourced by a partner but closed by an AE?

Tag entry point as new logo (if it is a first-time customer) and channel as partner. Entry point describes the revenue type; channel describes origination credit. Keep them in separate CRM fields so both the sourced-ARR math and the partner-comp math stay clean.

What counts as expansion versus a new logo in a multi-product company?

If the buying entity is already a customer and is adding a product, seat, or tier, it is expansion. If it is a genuinely new legal entity or business unit with its own budget and buying committee, treat it as a new logo — but document the rule and apply it consistently.

How often should source-of-pipeline math be refreshed?

Monthly for operating cadence, quarterly for cohort slicing, and annually for the board-level mix target. Monthly refreshes catch tagging drift early; quarterly cohorts catch decay in the land motion before it shows up in the growth rate.

Does sourced ARR include product-led self-serve conversions?

Yes, if the converting account is a first-time customer. Tag entry point as new logo and channel as PLG. If a self-serve user later converts to a sales-assisted contract, the original sourced ARR stays with PLG; the sales-assisted upgrade is expansion.

How do you handle a renewal that is slightly higher than the prior contract?

Split it. The original contracted value is renewal ARR. The increment above it is expansion ARR. Never let a renewal carry an expansion component without splitting — it corrupts both the retention metric and the expansion metric.

FAQ

What is the single formula for sourced ARR?

Sourced ARR equals the sum of closed-won ARR where the opportunity's entry point is new logo. Everything else — expansion, renewal, contraction, churn — is tracked separately. There is no blended formula, because blending is what hides the problem the math exists to expose.

Why can't I just report net new ARR and be done?

Net new ARR blends sourced, expansion, renewal, and churn into one number. It tells you the total moved but not whether the engine is healthy. A company can post strong net new ARR while its new-logo motion is collapsing, because expansion from a large installed base masks the failure for a year or two.

What is a healthy sourced share of gross additions in 2027?

For most growth-stage SaaS companies, 40–55% sourced share of gross additions is healthy. Below 30% signals overreliance on the installed base. Above 65% at scale usually means you are underinvesting in expansion and leaving retention revenue on the table.

How does RevOps enforce tagging discipline?

Make the entry-point field required at opportunity creation, use a locked picklist with no default value, audit a random sample monthly, and tie sales-ops reviews to tag accuracy. If tagging is optional, it will be wrong, and every downstream metric will be wrong with it.

Can I run this math without a data warehouse?

Yes, for a company under roughly $20M ARR. A well-configured CRM with required fields and a handful of reports can produce sourced, expansion, and renewal ARR by month. Above that scale, a warehouse or a dedicated RevOps analytics layer becomes necessary to slice cohorts reliably.

How do I separate sourced ARR from internal growth in a single sentence?

Sourced ARR is closed-won ARR from first-time customers that your pipeline originated; internal growth is expansion plus upward renewal movement on the existing base. Tag at creation, sum by tag, never blend.

Sources

• OpenView Partners — SaaS benchmarks and product-led growth research: https://openviewpartners.com/
• Bessemer Venture Partners — cloud and SaaS metrics: https://www.bvp.com/
• Bridge Group — sales development and pipeline metrics research: https://www.bridgegroupinc.com/
• Pavilion — go-to-market benchmarking and executive research: https://www.joinpavilion.com/
• SaaStr — SaaS operating benchmarks and annual surveys: https://www.saastr.com/
• Gartner — go-to-market and revenue operations research: https://www.gartner.com/
• Harvard Business Review — growth and retention frameworks: https://hbr.org/
• Salesforce — CRM and revenue operations documentation: https://www.salesforce.com/
• HubSpot — marketing and pipeline attribution resources: https://www.hubspot.com/
• SaaS Capital — SaaS growth and retention benchmarks: https://www.saas-capital.com/

Related on PULSE

• What renewal cadence should a SaaS company operate on to maximize land-expand-renew velocity?
• What is Marketing Sourced Pipeline vs Sales Sourced Pipeline in 2027?
• How do you prove marketing sourced pipeline when Salesforce campaign influence is disabled?
• How do you compensate for product-led trials that an SDR sourced but an AE closed — full credit to whom?
• How do you coach a partner manager to drive sourced pipeline?
• Why do 2027 buying committees require access to a vendor's internal RevOps dashboard before signing?