Workflow · Customers · Opening soon

Annual recurring revenue by customer

Use your Stripe exports to calculate annual recurring revenue for each customer. Keep active subscriptions, match prices, and turn monthly plans into ARR.

Book a demo

Someone typed

“calculate annual recurring revenue for each customer from their active subscriptions, monthly plans times 12”

The agent read it as

Calculate annual recurring revenue for each customer from their active subscriptions, monthly plans times 12, using Stripe customers, Stripe subscriptions and Stripe prices.

What the agent built

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

File

Stripe customers

CSV export · 10 rows

File

Stripe subscriptions

CSV export · 14 rows

File

Stripe prices

CSV export · 8 rows

Step

Make customer join key

Step 1

Step

Keep active subscriptions

Step 2

Step

Make price join key

Step 3

Join

Bring in active subscriptions

8 of 10 paired

Join

Bring in subscription prices

11 of 13 paired

Step

Calculate ARR by customer

Step 6

Result

Customer ARR

10 rows

Schedule

Runs when you say

Proposed

File
Stripe customers
CSV export · 10 rows
File
Stripe subscriptions
CSV export · 14 rows
File
Stripe prices
CSV export · 8 rows
Step
Make customer join key
Step 1
Step
Keep active subscriptions
Step 2
Step
Make price join key
Step 3
Join
Bring in active subscriptions
8 of 10 paired
Join
Bring in subscription prices
11 of 13 paired
Step
Calculate ARR by customer
Step 6
Result
Customer ARR
10 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 10 rows came out, and the join paired 8 of 10 rows; the join paired 11 of 13 rows.

Download Stripe customers sample (10 rows)Stripe: Customers > Export
Download Stripe subscriptions sample (14 rows)Stripe: Billing > Subscriptions > Export
Download Stripe prices sample (8 rows)Stripe: Products > Prices > Export

What you get back

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

Customer ARRSample data10 rows

Customer	ARR (USD)	Currency	Customer ID
Harbor Books	960	usd	cus_Q1a9kL3q
Lumen Foods	1,320	usd	cus_Q1a9kL4r
Pine Trail Outfitters	1,200	usd	cus_Q1a9kL5s
Willow Market	1,440	usd	cus_Q1a9kL9w
Quartz Labs	0	·	cus_Q1a9kL6t
Acme Orchard	2,640	usd	cus_Q1a9kL0m
Northwind Studio	1,980	usd	cus_Q1a9kL1n
Sunset Clinic	1,800	usd	cus_Q1a9kL7u
Tidewater Realty	540	usd	cus_Q1a9kL8v
Beacon Dental	0	·	cus_Q1a9kL2p

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

How do you calculate annual recurring revenue for each customer?

Export your Stripe customers, subscriptions, and prices files. Keep active subscriptions, match each subscription to its customer and price, then multiply monthly prices by 12 to get ARR by customer.

How it works

How to use the Customer ARR 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 ARR: questions

Which export file should I use?

Use the exported files that contain the rows you want to work with. For this workflow, that means customer, subscription, and price rows.

What happens to rows that do not match?

Rows that do not match the join key are left out of the matched result. You can review them separately and decide whether to fix the source data or change the rules.

How do I change the rules?

Edit the steps in plain words, for example by changing which rows are kept, which columns are used as join keys, or how a value is calculated.