CAC payback period
“show every cohort month from the stripe monthly cohort payback export with payback months from spend and new mrr, and a status: Agrees if it earns back within 12 months, Slow payback if longer”
Show every cohort month from Stripe monthly cohort payback export with payback months from spend and new mrr, and a status: Agrees if it earns back within 12 months, Slow payback if longer.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileStripe monthly cohort payback exportCSV export · 12 rows
- StepCalculate paybackStep 1
- ResultCohort payback status12 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 12 rows came out.
- Download Stripe monthly cohort payback export sample (12 rows)Stripe: Sigma > Queries > Run cohort payback query > Export CSV
What you get back
The result of that run, the rows to look at first.
| Cohort month | Acquisition spend | New MRR | Payback months | Status |
|---|---|---|---|---|
| 2025-11-01 | 14,400 | 900 | 16 | Slow payback |
| 2026-02-01 | 15,000 | 1,000 | 15 | Slow payback |
| 2025-12-01 | 9,800 | 1,400 | 7 | Agrees |
| 2026-01-01 | 11,200 | 2,200 | 5.09 | Agrees |
| 2026-03-01 | 8,600 | 1,700 | 5.06 | Agrees |
| 2026-04-01 | 9,200 | 2,400 | 3.83 | Agrees |
| 2026-05-01 | 7,800 | 1,950 | 4 | Agrees |
| 2026-06-01 | 10,100 | 2,600 | 3.88 | Agrees |
| 2026-07-01 | 8,900 | 2,100 | 4.24 | Agrees |
| 2026-08-01 | 7,400 | 1,850 | 4 | Agrees |
| 2026-09-01 | 8,100 | 2,700 | 3 | Agrees |
| 2026-10-01 | 6,900 | 2,300 | 3 | Agrees |
How do you calculate CAC payback period for each cohort?
Upload your Stripe monthly cohort payback export, then map spend and new MRR for each cohort month. The workflow calculates payback months for every row and marks it Agrees when payback is within 12 months, or Slow payback when it takes longer.
How it works
How to use the Cohort payback status 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.
Cohort payback status: questions
Which export should you use?
What happens if a row does not match the rule?
How do you change the rule in words?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Cohorts, churn, repeat purchases, retention, RFM segments and recurring revenue, from your orders or payments.
- Involuntary churn and failed payment recoveryTrack failed subscription payments, retries, and churn from Stripe exports, with invoice and subscription status for this month.See the workflow Built by the agent
- Stripe failed payments, weeklyList failed Stripe payments each week, with decline reason and whether the customer paid later.See the workflow Built by the agent
- Stripe MRR by planShow MRR by plan each month from your Stripe subscriptions export, with customer counts and row checks.See the workflow Built by the agent
- Year-over-year growth by product lineCompare each month this year to the same month last year, with growth % and a status for product line sales exported from QuickBooks.See the workflow Built by the agent
- Chargebee MRR movementCheck Chargebee monthly MRR movement by customer and subscription, including new, expansion, contraction, churn, and reactivation.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template