Workflow · Customers · Opening soon

Recurly churn by cohort

Track churn by signup month cohort from your exported Recurly subscriptions. See how many subscriptions are still active after 1, 3, 6 and 12 months.

Book a demo

Someone typed

“churn by signup month cohort from recurly subscriptions: how many are still active after 1, 3, 6 and 12 months”

The agent read it as

churn by signup month cohort from Recurly subscriptions: how many are still active after 1, 3, 6 and 12 months

What the agent built

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

File

Recurly subscriptions

CSV export · 25 rows

Step

Count active at each milestone

Step 1

Result

Subscription Cohort Retention

11 rows

Schedule

Runs when you say

Proposed

File
Recurly subscriptions
CSV export · 25 rows
Step
Count active at each milestone
Step 1
Result
Subscription Cohort Retention
11 rows
Schedule
Runs when you say
Proposed

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

Download Recurly subscriptions sample (25 rows)Recurly: Subscriptions > Export

What you get back

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

Subscription Cohort RetentionSample data11 rows

Signup month	Active after 1 month	Active after 3 months	Active after 6 months	Active after 12 months	Cohort size
2025-11-01	4	3	3	2	4
2025-12-01	3	2	2	2	4
2026-01-01	3	2	2	2	3
2026-02-01	2	2	2	2	3
2026-03-01	3	2	2	2	3
2026-04-01	2	1	1	1	2
2026-05-01	2	1	1	1	2
2026-06-01	1	0	0	0	1
2026-07-01	1	1	1	1	1
2026-08-01	0	0	0	0	1
2026-10-01	1	1	1	1	1

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

How do you track Recurly churn by cohort?

Export your Recurly subscriptions, then load the file into a spreadsheet-style workflow. Group each subscription by signup month, then count how many are still active at 1, 3, 6 and 12 months after signup.

How it works

How to use the Subscription Cohort 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.

Subscription Cohort Retention: questions

Which export should you use from Recurly?

Use an export of subscriptions that includes the signup date and the current subscription status, plus any dates needed to work out whether a subscription is active at each milestone.

What happens to rows that do not match the rules?

Rows that do not have the needed dates or status are left out of the cohort counts. You can review them separately and fix the export or the rules before running it again.

How do you change the cohort rules?

Edit the rules in words, for example, change the signup period, the milestone months, or what counts as active. Then run the workflow again on a new export.