SaaS growth model worksheet
Connect acquisition, activation, retention and expansion assumptions to recurring revenue changes. Use the editable worksheet, example and review steps to turn it into a working document.
On this page 6 sections
The short answer
SaaS growth model worksheet helps a SaaS team connect acquisition, activation, retention and expansion assumptions to recurring revenue changes. The fields below define the required decisions and evidence. Download a CSV working copy, assign owners and replace the illustrative example with your own approved information.
Key points before you start
Connect acquisition, activation, retention and expansion assumptions to recurring revenue changes. This worksheet supports the broader saas growth plan.
The working template
| Field | What to enter | Your answer | Owner |
|---|---|---|---|
| Starting base | Record opening customers and MRR. | ||
| Acquisition | Estimate new eligible accounts by source. | ||
| Activation | Apply a cohort-specific first-value rate. | ||
| Paid conversion | Use a defined conversion window. | ||
| Churn | Model account and revenue losses separately. | ||
| Expansion | Add eligible usage or package growth. | ||
| Costs | Include acquisition and delivery expenses. | ||
| Scenarios | Compare base, downside and upside assumptions. |
Editable working copy
Download this template
Save an editable working copy of the framework on this page. Add your own owners, evidence and decisions.
A worked example
Start with 100 customers paying $100 monthly. Model ten new customers, two losses and $300 of expansion as separate movements before calculating ending MRR.
The example is illustrative. It does not describe a measured customer result or create a promise about your own outcomes. Use it to understand the level of specificity the document needs.
How to complete the worksheet
- Choose one project, account segment or decision. A document that attempts to cover the whole company usually hides important differences.
- Gather the evidence required by the fields above. Use approved customer research, current product information and the relevant business records.
- Draft the answers with the person responsible for doing the work. Keep unresolved questions visible and assign a next action to each one.
- Review the document with the people who depend on it. Confirm scope, responsibilities and any constraints before treating it as an operating agreement.
- Save the version and review date. Update it when the underlying offer, process or customer evidence changes.
Review before sharing
A spreadsheet can balance while its assumptions are implausible. Keep observed inputs separate from guesses.
A useful working document makes disagreements visible while there is still time to resolve them. Ask a colleague to explain the intended decision from the filled-in version without additional narration. If they cannot identify the next step or the evidence behind it, revise the relevant field.
Remove confidential customer details from any public copy. Keep names, prices and results only when you have permission and can explain their context. An empty evidence field is a signal to investigate, not an invitation to supply a plausible-sounding number.
Continue the work
- How to Build a SaaS Growth Model
- Growth Loops for SaaS
- SaaS Growth Strategies That Actually Compound
- B2B SaaS Growth
- Product Led Growth for SaaS
Find more templates and checklists for adjacent tasks.
Apply saas growth model worksheet in a working review
Make a copy of the working file and complete one representative row before filling the entire document. Replace example values with evidence from the actual project. Add an owner and a review condition where the template calls for a decision. A blank marked unknown is more useful than an invented number that makes the file look finished.
For this topic, involve the experiment owner and the analyst responsible for design integrity and work from hypothesis, assignment rules, metric definition and decision record. The relevant unit is the prespecified eligible user or account cohort. State the question the review should resolve before choosing a chart, an asset or a tool. If participants disagree about the unit or scope, resolve that disagreement before combining their evidence.
Evidence to prepare
Check the design before interpreting a result. Assignment, exclusions, outcome timing and stopping rules can change the meaning of an apparently precise statistic. Separate practical effect from statistical evidence and keep guardrails beside the primary outcome.
| Review field | What to record |
|---|---|
| Topic | SaaS growth model worksheet |
| Decision | The specific action this explanation should help you choose |
| Working evidence | hypothesis, assignment rules, metric definition and decision record |
| Unit and scope | the prespecified eligible user or account cohort |
| Responsible people | experiment owner and the analyst responsible for design integrity |
| Remaining uncertainty | The missing fact that could change the decision |
Two situations that can change the interpretation
When the activation event is too easy to complete
A first login may be necessary, but it does not establish that a team created a usable project or resolved a support ticket.
Use this check: Compare the event with an observable customer outcome and later appropriate use. Do not select an event solely because it has the strongest correlation in a small sample.
The focused diagnostic guide provides the correction process and a working evidence sheet.
When a growth model double-counts referrals
A customer who clicks a referral link and later a search ad should not become two new customers in the forecast.
Use this check: Trace the model’s stock and flow definitions and identify overlapping cohorts. A referral invitation is not a referred customer until the defined conversion occurs.
The focused diagnostic guide provides the correction process and a working evidence sheet.
Record the decision and the limit
A higher signup rate is not automatically a better activation path if the removed step helped users reach a useful workflow. Review the complete sequence and the relevant customer outcome. A bundled product change can be evaluated as a bundle without claiming to isolate every component.
Keep the conclusion beside the evidence that supports it. Record what the team will do, who owns the next action and which event or date will trigger a review. If the underlying definition, audience or product behavior changes, revisit the conclusion rather than assuming the old result still applies. A clear limit is useful information; it tells the next reader where additional investigation is required.
Use the complete topic collection for related methods and the category field guides when the product’s buying situation or implementation requirements change how the method should be applied.
Editable working copy
Download this template
Save an editable working copy of the framework on this page. Add your own owners, evidence and decisions.
Frequently asked questions
What format is the downloadable template?
The working copy is a CSV file. Open it in your spreadsheet application, add owners and dates, and keep a separate copy of the original for reference.
How should I fill in this template?
Connect acquisition, activation, retention and expansion assumptions to recurring revenue changes. Start with one real project so that the decisions remain specific.
What mistake should I avoid?
A spreadsheet can balance while its assumptions are implausible. Keep observed inputs separate from guesses.
Do I need to complete every field before starting?
Identify the fields that change the decision or block safe execution. Mark unknowns with an owner and a review date rather than inventing an answer.
The saas-marketing.net editorial team Research and editorial
We research, write and maintain every page on this site. The library explains marketing decisions through practical frameworks, explicit assumptions and references. Corrections can be requested through the contact page.
Published September 17, 2026. Last updated .