Workflow · Customers · Opening soon

LTV to CAC ratio

Use your Stripe and Google Ads exports to track LTV to CAC by month. The workflow matches new customers to ad spend, then calculates CAC and LTV from the same period.

Book a demo

Someone typed

“by month, match new stripe customers to google ads spend, calculate cac as spend per new customer and ltv as paid revenue per paying customer from stripe invoices, then show ltv to cac”

The agent read it as

By month, match new Stripe customers to Google Ads campaigns spend, calculate CAC as spend per new customer and LTV as paid revenue per paying customer from Stripe invoices, then show LTV to CAC.

What the agent built

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

File

Google Ads campaigns

CSV export · 14 rows

File

Stripe customers

CSV export · 18 rows

File

Stripe invoices

CSV export · 24 rows

Step

Total spend by month

Step 1

Step

Count new customers by month

Step 2

Step

Total paid revenue by month

Step 3

Join

Add new customers

11 of 11 paired

Join

Add paid revenue

11 of 11 paired

Step

Calculate monthly CAC and LTV

Step 6

Result

Monthly CAC and LTV

11 rows

Schedule

Runs when you say

Proposed

File
Google Ads campaigns
CSV export · 14 rows
File
Stripe customers
CSV export · 18 rows
File
Stripe invoices
CSV export · 24 rows
Step
Total spend by month
Step 1
Step
Count new customers by month
Step 2
Step
Total paid revenue by month
Step 3
Join
Add new customers
11 of 11 paired
Join
Add paid revenue
11 of 11 paired
Step
Calculate monthly CAC and LTV
Step 6
Result
Monthly CAC and LTV
11 rows
Schedule
Runs when you say
Proposed

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

Download Google Ads campaigns sample (14 rows)Google Ads: Reports > Predefined reports (Campaigns) > Export
Download Stripe customers sample (18 rows)Stripe: Customers > All customers > Export
Download Stripe invoices sample (24 rows)Stripe: Billing > Invoices > Export

What you get back

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

Monthly CAC and LTVSample data11 rows

Month	CAC	LTV	LTV to CAC	Spend	New customers	Paid revenue	Paying customers
2026-01-01	130	114	0.88	260	2	228	2
2026-04-01	850	114	0.13	1,700	2	228	2
2026-06-01	180	114	0.63	360	2	228	2
2026-08-01	410	114	0.28	410	1	228	2
2026-09-01	430	149	0.35	430	1	447	3
2026-10-01	450	149	0.33	450	1	596	4
2025-11-01	220	79	0.36	220	1	79	1
2025-12-01	120	114	0.95	240	2	228	2
2026-03-01	150	79	0.53	300	2	158	2
2026-05-01	340	149	0.44	340	1	149	1
2026-07-01	600	149	0.25	600	1	149	1

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

How do you calculate LTV to CAC ratio by month?

Export monthly data from Stripe and Google Ads, then upload the files. The workflow matches new customers to ad spend, calculates CAC as spend per new customer, and LTV as paid revenue per paying customer. It then shows the monthly LTV to CAC ratio.

How it works

How to use the Monthly CAC and LTV 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 CAC and LTV: questions

Which export files should you use?

Use a Stripe export that includes customers and invoices, and a Google Ads export that includes monthly spend. The files should have dates and the values needed to count new customers, total spend, and paid revenue.

What happens if a row does not match another file?

Rows that do not find a match are kept separate based on the workflow rules. You can review them and decide whether to map them, leave them unmatched, or exclude them from the result.

How do you change the matching or calculation rules?

You change the rules in plain words, such as how to match months, what counts as a new customer, and which revenue to include. You can also change how CAC and LTV are calculated, then rerun the workflow.