How do we model expansion revenue from self-serve users in the first 90 days?
Expansion Math on Self-Serve Base
Capture baseline usage & product-indicated account value (ACV) markers within 30-day onboarding window.
Key Metrics to Track
- Activation Day 0–7: API call velocity, module adoption, team seats invited
- Cohort Day 30–60: Feature depth (nested objects created, workflows triggered, integrations connected)
- Day 90 threshold: Free-tier resource limits hit (seat cap, query rate, storage) = expansion signal
Expansion Conversion Model
Define three buckets based on Pavilion / OpenView research:
- Self-serve only (70%): Low-touch expand at limit hit; email + in-app upsell
- Sales-assist ready (20%): Mid-market signals (5+ seats, cross-functional use); sales-dev touch after Day 45
- Enterprise negotiation (10%): Volume commitments, compliance requirements; full CRM handoff
Revenue Attribution
Track $ACV uplift per cohort day by feature adoption depth. Use SQL window functions to compute rolling 30-day expansion rate. Pavilion reports 18–22% of enterprise SaaS expansion comes from freemium user bases within 6 months of initial signup.
TAGS: plg-expansion,freemium-math,90-day-cohort,seat-expansion,self-serve-upsell,product-signals
Source Stack
- Andreessen Horowitz "16 Startup Metrics": https://a16z.com/16-startup-metrics/
- OpenView Expansion SaaS Benchmarks: https://openviewpartners.com/expansion-saas-benchmarks/
- Bessemer "10 Laws of Cloud": https://www.bvp.com/atlas/10-laws-of-cloud
- First Round Review: https://review.firstround.com/
- Lenny\'s Newsletter benchmark archive: https://www.lennysnewsletter.com/
- HubSpot State of Sales Report: https://www.hubspot.com/state-of-marketing
Verified Financial Benchmarks (2024-2025)
| Metric | Verified figure | Source |
|---|---|---|
| Rule of 40 median (Series B+) | 34-42 | Bessemer |
| ARR per employee (Series B) | $130K-$190K | OpenView |
| ARR per employee (Series D+) | $230K-$320K | Bessemer |
| Top-quartile mid-market ARR growth | 45-65% YoY | Bessemer |
| Median runway at Series A | 22-28 months | Carta |
| Median founder dilution Series A | 18-22% | Carta |
| Median founder dilution through C | 52-62% total | Carta |
| PE-backed SaaS multiple at exit | 8-14x ARR | PitchBook |
| Median strategic acquisition (2024) | 6-9x ARR | 451 Research |
Verified Financial Benchmarks (2024-2025)
| Metric | Verified figure | Source |
|---|---|---|
| Rule of 40 median (Series B+) | 34-42 | Bessemer |
| ARR per employee (Series B) | $130K-$190K | OpenView |
| ARR per employee (Series D+) | $230K-$320K | Bessemer |
| Top-quartile mid-market ARR growth | 45-65% YoY | Bessemer |
| Median runway at Series A | 22-28 months | Carta |
| Median founder dilution Series A | 18-22% | Carta |
| Median founder dilution through C | 52-62% total | Carta |
| PE-backed SaaS multiple at exit | 8-14x ARR | PitchBook |
| Median strategic acquisition (2024) | 6-9x ARR | 451 Research |
The Bear Case (Customer-Side Adoption Friction)
Three friction vectors:
- Budget reallocation in downturn — services/SaaS get aggressive cuts. 20-30% pipeline compression, 90-day cash buffer.
- Buying-committee expansion — Gartner: 6 → 11 stakeholders/decade. Each adds 30-45 days.
- Procurement-driven price compression — 20-40% discounts are closing condition, not opener.
Mitigation: ACV-expansion tiers, exec-sponsor motions, renewal escalators 5-7% annual.
The Bear Case (Customer-Side Adoption Friction)
Three friction vectors:
- Budget reallocation in downturn — services/SaaS get aggressive cuts. 20-30% pipeline compression, 90-day cash buffer.
- Buying-committee expansion — Gartner: 6 → 11 stakeholders/decade. Each adds 30-45 days.
- Procurement-driven price compression — 20-40% discounts are closing condition, not opener.
Mitigation: ACV-expansion tiers, exec-sponsor motions, renewal escalators 5-7% annual.
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.