Workflow · Customers · Opening soon

Expansion and contraction MRR

Use a Chargebee subscription MRR change log export to split MRR movements by month. See each customer’s changes as new, expansion, contraction, or churned MRR.

Book a demo

Someone typed

“from the chargebee subscription mrr change log, show mrr by month and customer with new, expansion, contraction, and churned mrr, using the change type and delta mrr to bucket each change”

The agent read it as

From the Chargebee subscription MRR change log, show MRR by month and customer with new, expansion, contraction, and churned MRR, using the change type and delta MRR to bucket each change, counting reactivations as new MRR.

What the agent built

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

File

Chargebee subscription MRR change log

CSV export · 20 rows

Step

Bucket changes by month and customer

Step 1

Result

Customer MRR Movements

19 rows

Schedule

Runs when you say

Proposed

File
Chargebee subscription MRR change log
CSV export · 20 rows
Step
Bucket changes by month and customer
Step 1
Result
Customer MRR Movements
19 rows
Schedule
Runs when you say
Proposed

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

Download Chargebee subscription MRR change log sample (20 rows)Chargebee: Analytics > Exports > Subscription changes > Export CSV

What you get back

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

Customer MRR MovementsSample data19 rows

Customer	Month	New MRR (USD)	Expansion MRR (USD)	Contraction MRR (USD)	Churned MRR (USD)	Customer ID
Bluefin Studio	2026-09-01	800	0	0	0	cus_5c8d12
Northstar Labs	2026-09-01	1,200	0	0	0	cus_7f3a21
Orbit Works	2026-09-01	1,500	0	0	0	cus_9a1e44
Red Cedar Co	2026-09-01	450	0	0	0	cus_b2d901
Silverline Health	2026-09-01	950	0	0	0	cus_18c4ef
Bluefin Studio	2026-10-01	0	0	200	600	cus_5c8d12
Mint Ridge	2026-10-01	1,100	0	0	0	cus_d4a8ff
Northstar Labs	2026-10-01	0	500	0	0	cus_7f3a21
Orbit Works	2026-10-01	0	400	0	0	cus_9a1e44
Pinecrest Media	2026-10-01	650	0	0	0	cus_6e2b77
Red Cedar Co	2026-10-01	0	250	0	0	cus_b2d901
Silverline Health	2026-10-01	0	0	200	0	cus_18c4ef

19 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you break down MRR change by month into new, expansion, contraction, and churned MRR?

Export the Chargebee subscription MRR change log, then group the changes by month and customer. Mammoth uses the change type and delta MRR to bucket each row as new, expansion, contraction, or churned MRR, and it counts reactivations as new MRR. The result is a customer-level view of MRR movements by month.

How it works

How to use the Customer MRR Movements 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.

Customer MRR Movements: questions

What export should you use for this workflow?

Use the Chargebee subscription MRR change log export, or the closest file that lists MRR changes with a date, customer, change type, and delta MRR.

What happens to rows that do not match a bucket?

They stay as unassigned rows until you add a rule that matches them. You can review those rows and decide how they should be grouped.

How do you change the rules?

Edit the bucketing rules in plain words, using the fields in your file. For example, change the month rule, adjust which change types count as new, or add a rule for a different delta MRR pattern.