SaaS metrics pack
“from our subscriptions give me mrr, new, expansion, churned mrr, customer count and arpa by month”
From our Stripe invoice line items give me MRR, new, expansion, churned MRR, customer count and ARPA by month, leaving out prorated lines.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileStripe invoice line itemsCSV export · 35 rows
- StepCalculate monthly MRR movementsStep 1
- ResultMonthly MRR Summary13 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 13 rows came out.
- Download Stripe invoice line items sample (35 rows)Stripe: Invoices > All invoices > Export line items
What you get back
The result of that run, the rows to look at first.
| Month | MRR (USD) | New MRR (USD) | Expansion MRR (USD) | Churned MRR (USD) | Customer count | ARPA (USD) |
|---|---|---|---|---|---|---|
| 2025-11-01 | 120 | 120 | 0 | 0 | 1 | 120 |
| 2025-12-01 | 200 | 80 | 0 | 0 | 2 | 100 |
| 2026-01-01 | 400 | 200 | 0 | 0 | 3 | 133.33 |
| 2026-02-01 | 700 | 300 | 0 | 0 | 4 | 175 |
| 2026-03-01 | 830 | 90 | 40 | 0 | 5 | 166 |
| 2026-04-01 | 890 | 60 | 0 | 0 | 6 | 148.33 |
| 2026-05-01 | 770 | 0 | 0 | 120 | 5 | 154 |
| 2026-06-01 | 310 | 50 | 0 | 510 | 3 | 103.33 |
| 2026-07-01 | 300 | 250 | 0 | 260 | 2 | 150 |
| 2026-08-01 | 250 | 0 | 0 | 50 | 1 | 250 |
| 2026-09-01 | 140 | 140 | 0 | 250 | 1 | 140 |
| 2026-10-01 | 140 | 0 | 0 | 0 | 1 | 140 |
How do you get SaaS metrics from Stripe exports?
Export your subscription or invoice line items from Stripe, then load the file into Mammoth. The workflow groups the data by month and calculates MRR, new MRR, expansion MRR, churned MRR, customer count, and ARPA, while leaving out prorated lines.
How it works
How to use the Monthly MRR Summary workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Monthly MRR Summary: questions
Which export should you use?
What happens to rows that do not match the rules?
How do you change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Cohorts, churn, repeat purchases, retention, RFM segments and recurring revenue, from your orders or payments.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- ARPU by monthCalculate average revenue per user each month from Stripe invoices and active customers.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Net revenue retentionNet and gross revenue retention for every monthSee the workflow Template
- Repeat purchase rateEach month's new customers and the share who ordered again within 90 daysSee the workflow Template