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

Track three ARR buckets separately: New Source, Expansion, Renewal. Land-expand-renew requires distinct reporting because expansion often hides CAC and closes ratio failures. A $5M ARR company showing 10% growth that's 8% internal expansion and 2% new logo acquisition has a broken sales engine.

The Three Buckets (by Entry Point)

The Dangerous Hidden Trap

When 60%+ of "growth" is expansion, you've likely failed to fix new logo acquisition. Example:

• ARR start: $5M
• New logos: $500k (10% growth target: undershot)
• Expansion: $800k (amazing, right?)
• Renewal churn: −$200k
• Net growth: $1.1M ARR = 22% growth

Leadership cheers. But you're burning customers to fund expansion. The $800k expansion came from customers in year 2–3 (already sold last year). Next year, if you don't add new logos, that $800k won't repeat—you'll only have renewal to fall back on.

Cohort Math: 3-Year Waterfall Example

``` Year 1 New Logos: $500k ARR ↓ Year 2: $500k renewal + $200k expansion = $700k ↓ Year 3: $700k renewal + $150k expansion = $850k

Year 2 New Logos: $600k ARR ↓ Year 3: $600k renewal + $180k expansion = $780k

Year 1–3 Total (as of Year 3):

• New Source: $500k (Y1) + $600k (Y2) = $1.1M
• Expansion: $200k (Y1 cohort) + $180k (Y2 cohort) + $150k (Y1 repeat) = $530k
• Renewal: $700k + $600k = $1.3M
• Total ARR: $2.93M

```

Why Separate Them:

1. Expansion rate hides sales productivity. If your AE spends 40% of time on expansion, closing at 60%, but only adds 2 new logos/year, expansion math lets you ignore the real problem.
2. Renewal churn shows customer health. If churn is 15%+ while expansion is 12%, you're growing on a sinking ship.
3. Cohort sizing predicts future. If Year 1 cohort only expanded 20% but Year 2 cohort expands 35%, something changed (pricing, market fit, or you're over-serving). Track it.
4. CAC payback splits. New source ARR has CAC; expansion has low/zero CAC. They're different unit economics.

Pavilion Data: SaaS Benchmarks (2025)

• Median new logo ARR: 35–45% of total growth
• Median expansion: 40–50% of total growth
• Median renewal churn: −5–15% of total growth
• Top quartile: 55–65% new, <30% expansion (new logo-focused)
• Struggling: 20–30% new, 60–70% expansion (overreliant on upsell)

Implementation:

1. Tag every deal at creation: source type (SDR, AE-sourced, inbound, partner, expansion, renewal).
2. Pull monthly cohort report: for each vintage year, track new + expansion + churn separately.
3. Set board KPIs as three metrics, not one blended growth rate.

TAGS: revenue-reporting,expansion,new-logos,cohort-analysis,renewal,churn