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

Primary References

• Pavilion Executive Compensation Research: https://www.joinpavilion.com/research
• Bridge Group "Sales Development Metrics": https://www.bridgegroupinc.com/research
• OpenView Partners "PLG Index": https://openviewpartners.com/blog/category/product-led-growth/
• SaaStr Annual State-of-the-Industry survey: https://www.saastr.com/saastr-annual/
• Forrester B2B Buyer Studies: https://www.forrester.com/research/b2b/
• U.S. BLS — Sales & Related Occupations: https://www.bls.gov/ooh/sales/

---

Cited Benchmarks (Replace Generic %s)

---

Cited Benchmarks (Replace Generic %s)

---

The Bear Case (Capital Markets & Funding)

Three funding risks:

1. Valuation compression — public SaaS multiples ranged 4-18× in 5yrs. Future compression to 3-5× changes exit math.
2. Venture funding tightening — Series B+ harder per Carta. Longer fundraises, tougher dilution.
3. Strategic-acquisition window — large acquirer M&A appetites cyclical. 2023-2024 paused; continued pause limits exits.

Mitigation: $1.5+ ARR/$ raised, default-alive at 18mo, 2+ exit optionalities.

---

See Also (related library entries)

Cross-references for adjacent operator topics drawn from the current 10/10 library set, ranked by tag overlap with this entry:

• q9502 — How do you scale a workshop-led senior tech-training business in 2027 — what's the proven path past the single-operator ceiling?
• q9559 — How should a CRO calibrate qualification rigor when cash position and runway are forcing a choice between conservative organic growth and ag
• q9558 — What's the framework for a CRO to decide whether to build two separate sales motions (organic vs M&A/upmarket) with distinct qualification r
• q9557 — When a founder-led company has strong product-market fit but weak sales discipline, is the root cause almost always qualification/champion v

Follow the q-ID links to read each in full.

Related on PULSE

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

The Cohort Attribution Trap: Why "New Source" Often Overstates Pipeline Health

The biggest math mistake in land-expand-renew analysis is misattributing expansion revenue to the wrong cohort. Most companies track expansion as a single number, but it actually comes from two distinct sources: first-year expansion (expansion within 12 months of initial close) and mature expansion (expansion after 12+ months). This matters because first-year expansion often signals an initial undersell—you left ARR on the table at close. Mature expansion, by contrast, indicates genuine product stickiness and use-case growth.

The math to separate them: Create a cohort table by quarter of first purchase. For each cohort, track ARR at month 12 (renewal baseline) and month 24. The difference between month 12 and month 24 ARR is mature expansion. Any ARR added between month 0 and month 12 is first-year expansion. Example: A cohort that closed at $100k in Q1 2023, grew to $130k by Q1 2024, and $160k by Q1 2025 has $30k first-year expansion and $30k mature expansion. If you report that $60k as "expansion" without cohort slicing, you lose the signal that your sales team systematically under-quoted—meaning your new logo CAC is artificially low because you're counting ARR that should have been in the initial deal.

The pipeline math fix: When forecasting, treat first-year expansion as a deduction from new source pipeline—not as expansion. If your average first-year expansion rate is 20% (common in usage-based or seat-based models), then a $100k new logo deal should be recorded as $120k in your new source pipeline, with the $20k tagged as "embedded expansion." This prevents double-counting: you don't want to show $100k new source in Q1 and then claim $20k expansion in Q4 from the same customer. The honest approach is to set new source targets that include expected first-year growth, then track expansion only from year 2 onward.

The Renewal-to-Expansion Ratio: A Leading Indicator of Pipeline Decay

Another hidden math problem is the renewal-to-expansion ratio—the percentage of your expansion that comes from customers who were up for renewal versus customers who are mid-contract. This ratio reveals whether your expansion is reactive (you only get more money when the contract is renegotiated) or proactive (you're adding value mid-term). A ratio above 70% (meaning 70% of expansion happens at renewal) signals that you're not driving adoption between contract cycles—you're just price-increasing or seat-capping at renewal time.

The math: Track expansion events by timing. For each quarter, calculate: (Total expansion from customers whose contracts ended that quarter) ÷ (Total expansion from all customers that quarter). If this ratio is 0.8, then 80% of your expansion is renewal-triggered. That's dangerous because it means your growth is tied to contract cycles, not product engagement. A healthy SaaS company targets a ratio below 50%—meaning more than half of expansion happens mid-contract through usage spikes, feature adoption, or seat additions.

Why this matters for pipeline math: If your expansion is renewal-heavy, you need to model a lag effect in your pipeline. A customer who renews in Q3 with a 30% expansion was likely showing usage signals in Q1–Q2. Your pipeline should include a "renewal expansion probability" column that scores each upcoming renewal based on current usage data. For example: customers using >80% of their current seats have a 60% chance of seat expansion at renewal; customers using <50% have a 10% chance. This turns renewal pipeline from a binary (will they renew?) to a probabilistic (how much will they expand?) calculation.

The Churn-Adjusted Source-of-Pipeline Formula

The most common error in separating sourced ARR from internal growth is ignoring churn in the denominator. When you calculate "new source as % of total growth," you're usually dividing new logo ARR by net new ARR. But net new ARR already subtracts churn, which inflates the new source percentage. Example: $500k new logos, $200k expansion, -$300k churn = $400k net new. New source appears to be 125% of growth ($500k/$400k)—which is mathematically impossible and hides the fact that you're losing customers faster than you're adding them.

The correct formula: Calculate gross new source contribution as: New Logo ARR ÷ (New Logo ARR + Expansion ARR). This gives you the true mix of where your gross additions come from, before churn distorts the picture. Then calculate net retention-adjusted growth separately. In the example above, gross new source contribution is $500k/$700k = 71%—meaning 71% of your gross additions are from new logos. The churn problem is visible in the net retention rate (($500k + $200k - $300k)/$500k = 80%), not in the source-of-pipeline mix.

The pipeline math application: Use gross new source contribution to set realistic targets. If you want 50% of growth to come from new logos, you need new logo ARR to equal expansion ARR in gross terms. For a company targeting $2M in gross additions next year, that means $1M in new logos and $1M in expansion. If your churn rate is 10%, your net growth will be $1.8M—but the source mix is clean. This prevents the common mistake of setting new logo targets that are actually impossible because expansion is growing faster than you can hire SDRs.

Sources

• HubSpot — marketing analytics and pipeline attribution models
• Salesforce — CRM and revenue operations documentation
• Gartner — research on go-to-market metrics and ARR decomposition
• SaaS Capital — benchmarks for SaaS growth and pipeline sources
• OpenView — venture capital insights on land-expand-renew motions
• Harvard Business Review — frameworks for separating organic vs. sourced growth

FAQ

How do I calculate new source ARR separately from expansion and renewal? Track each dollar by its entry point: new logo ARR comes from first-time customers, expansion ARR from existing customers increasing spend, and renewal ARR from same-amount renewals. Use CRM tags or contract line items to split them—no mixing allowed.

What’s the typical ratio of new source to expansion for a healthy SaaS company? A balanced pipeline usually sees 40–60% of net new ARR from new logos and the rest from expansion, depending on maturity. If expansion exceeds 60% consistently, new logo acquisition is likely underperforming.

How do I avoid the trap of hiding CAC failures in expansion numbers? Report new source ARR separately and track its growth rate against expansion. If expansion is high but new logos are flat, your sales engine is broken—fix sourcing before celebrating overall growth.

Can expansion ARR be counted as growth in the same way as new source? No—expansion is valuable but doesn’t replace new logos for long-term health. New source builds your customer base; expansion only works if you keep adding fresh accounts to expand into.

What’s a simple way to audit if my pipeline is new-source healthy? Look at the ratio of new logo ARR to total net new ARR over 6–12 months. If it’s below 30%, you’re likely relying too much on existing customers and risking future stagnation.

How do I handle renewal ARR that’s slightly higher or lower than the prior period? Renewal ARR should match the expiring contract’s value—any increase is expansion, any decrease is churn or contraction. Keep renewal as a pure retention metric to avoid muddying growth calculations.