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:

1. Self-serve only (70%): Low-touch expand at limit hit; email + in-app upsell
2. Sales-assist ready (20%): Mid-market signals (5+ seats, cross-functional use); sales-dev touch after Day 45
3. 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)

Verified Financial Benchmarks (2024-2025)

The Bear Case (Customer-Side Adoption Friction)

Three friction vectors:

1. Budget reallocation in downturn — services/SaaS get aggressive cuts. 20-30% pipeline compression, 90-day cash buffer.
2. Buying-committee expansion — Gartner: 6 → 11 stakeholders/decade. Each adds 30-45 days.
3. 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:

1. Budget reallocation in downturn — services/SaaS get aggressive cuts. 20-30% pipeline compression, 90-day cash buffer.
2. Buying-committee expansion — Gartner: 6 → 11 stakeholders/decade. Each adds 30-45 days.
3. 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.