Workflow · Customers · Opening soon

Gross revenue retention

Turn exported Stripe subscription MRR into monthly gross revenue retention. Count churn and downgrades, and leave expansion out.

Book a demo

Someone typed

“calculate gross revenue retention by month from subscription MRR, counting churn and downgrades but not expansion”

The agent read it as

Calculate gross revenue retention by month from Stripe subscription MRR by month, counting churn and downgrades but not expansion.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Stripe subscription MRR by month

CSV export · 31 rows

Step

Calculate monthly gross retention

Step 1

Result

Gross Revenue Retention

6 rows

Schedule

Runs when you say

Proposed

File
Stripe subscription MRR by month
CSV export · 31 rows
Step
Calculate monthly gross retention
Step 1
Result
Gross Revenue Retention
6 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 6 rows came out.

Download Stripe subscription MRR by month sample (31 rows)Stripe Sigma: Billing > Revenue > Monthly recurring revenue export

What you get back

The result of that run, the rows to look at first.

Gross Revenue RetentionSample data6 rows

Month	Gross revenue retention	Gross retained MRR	Starting MRR	Contraction MRR	Churn MRR
2026-05-01	0.97	5,600	5,750	150	0
2026-07-01	0.97	5,700	5,900	200	0
2026-06-01	0.98	5,700	5,800	100	0
2026-08-01	0.94	5,000	5,300	300	0
2026-09-01	0.78	4,650	5,950	400	900
2026-10-01	1	5,250	5,250	0	0

6 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate gross revenue retention by month?

Export your Stripe subscription MRR by month, then load it into the workflow. It groups the data by month and calculates gross revenue retention from churn and downgrades only, without counting expansion.

How it works

How to use the Gross Revenue Retention 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.

Gross Revenue Retention: questions

What file should you export from Stripe?

Use the export that contains subscription MRR by month. The workflow needs rows with monthly MRR so it can compare changes over time.

What happens to rows that do not match the rules?

Rows that do not match are left out of the calculation for that step. You can review them and decide whether to adjust the input or the rule.

How do you change the rules in words?

Edit the step description in plain language. For example, say whether to count churn, downgrades, expansion, or a different time group such as week or quarter.