Workflow · Customers · Opening soon

Stripe MRR by plan

Track MRR by plan from your Stripe subscriptions export. See monthly plan totals, unique customer counts, and rows that need review.

Book a demo

Someone typed

“show mrr by plan each month from the stripe subscriptions export, with unique customer counts and a status that says Agrees for normal rows, Plan mismatch for unmapped or weird plan prices, Customer count issue when quantity is over 1, and Canceled still active when a canceled sub is still counted”

The agent read it as

show mrr by plan each month from Stripe subscriptions export, with unique customer counts and a status that says Agrees for normal rows, Plan mismatch for unmapped or weird plan prices, Customer count issue when quantity is over 1, and Canceled still active when a canceled sub is still counted

What the agent built

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

File

Stripe subscriptions export

CSV export · 15 rows

Step

Summarise by month

Step 1

Result

Monthly MRR by plan

9 rows · 3 flagged

Schedule

Runs when you say

Proposed

File
Stripe subscriptions export
CSV export · 15 rows
Step
Summarise by month
Step 1
Result
Monthly MRR by plan
9 rows · 3 flagged
Schedule
Runs when you say
Proposed

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

Download Stripe subscriptions export sample (15 rows)Stripe Dashboard: Billing > Subscriptions > Export

What you get back

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

Monthly MRR by planSample data9 rows

6 agrees1 canceled still active1 customer count issue1 plan mismatch

Month	Plan	MRR	Unique customers	Status
2026-10-01	Starter	87	3	Canceled still active
2026-11-01	Growth	177	2	Customer count issue
2026-11-01	Growth Plus	69	1	Plan mismatch
2026-10-01	Growth	177	3	Agrees
2026-10-01	Plus	149	1	Agrees
2026-10-01	Scale	99	1	Agrees
2026-11-01	Plus	149	1	Agrees
2026-11-01	Scale	99	1	Agrees
2026-11-01	Starter	58	2	Agrees

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

How do you get Stripe MRR by plan each month?

Export your Stripe subscriptions data, then load it into Mammoth. Set the rules for how plans should be grouped, and summarize the rows by month so you can see MRR by plan and unique customer counts.

How it works

How to use the Monthly MRR by plan 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 by plan: questions

What export should you use?

Use a spreadsheet-style export that includes the fields you need for each row, such as plan, amount, month, customer, quantity, and status. A subscriptions export is the usual choice for this workflow.

What happens to rows that do not match the rules?

Rows that do not match are still shown, but they are marked for review. You can use those flags to spot unmapped plans, unusual quantities, or rows that should not be counted the same way.

How do you change the rules?

Edit the rule words so they match your own plan names and counting logic. You can change the plan mapping, the month grouping, and the checks for rows that should be counted differently.