Workflow · Customers · Opening soon

ARPU by month

Use your Stripe invoices export to calculate monthly ARPU. Active customers are the customers with paid invoices in that month.

Book a demo

Someone typed

“calculate average revenue per user each month from stripe invoices and active customers”

The agent read it as

Calculate average revenue per user each month from Stripe invoices and Stripe customers, with active customers meaning customers with paid invoices that month.

What the agent built

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

File

Stripe invoices

CSV export · 23 rows

File

Stripe customers

CSV export · 12 rows

Join

Add customer IDs

23 of 23 paired

Step

Calculate monthly revenue per user

Step 2

Result

Monthly Revenue Per User

11 rows

Schedule

Runs when you say

Proposed

File
Stripe invoices
CSV export · 23 rows
File
Stripe customers
CSV export · 12 rows
Join
Add customer IDs
23 of 23 paired
Step
Calculate monthly revenue per user
Step 2
Result
Monthly Revenue Per User
11 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 11 rows came out, and the join paired 23 of 23 rows.

Download Stripe invoices sample (23 rows)Stripe: Billing > Invoices > Export
Download Stripe customers sample (12 rows)Stripe: Customers > Export

What you get back

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

Monthly Revenue Per UserSample data11 rows

Month	Average revenue per user (USD)	Active customers	Revenue (USD)
2026-01-01	365	2	730
2026-02-01	602.50	2	1,205
2026-03-01	552.50	2	1,105
2026-05-01	720	2	1,440
2026-06-01	560	2	1,120
2026-08-01	557.50	2	1,115
2026-09-01	475	2	950
2026-10-01	1,037.50	2	2,075
2026-04-01	662.50	2	1,325
2026-07-01	620	2	1,240
2026-11-01	621.67	3	1,865

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

How do you calculate average revenue per user each month?

Export your Stripe invoices and customer data, then add customer IDs so each invoice matches a customer. Mammoth calculates monthly revenue per user from the paid invoices in that month and the active customers in that month.

How it works

How to use the Monthly Revenue Per User 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 Revenue Per User: questions

What export should you use?

Use a Stripe invoices export with invoice amounts, dates, payment status, and customer IDs. You also need a customer list export if the IDs are not already in the invoice file.

What happens to rows that do not match?

Rows that do not match the rules are left out of the result for that step. You can review them and decide whether to fix the source file or change the rule.

How do you change the rules?

Edit the steps in plain words, such as which columns to match, how to define an active customer, and which dates to group by. Then run the workflow again on the exported file.