New-customer CAC $127. First-order margin $95. The cohort payback curve that tells me whether to scale.

Quick Take

A Shopify home brand asks me whether to push paid-media budget from $45K/month to $70K. I do not look at ROAS. I look at the CAC payback curve. Specifically: how many weeks does it take for the cumulative contribution margin from a cohort of new customers to equal the paid-media spend that acquired them. If the curve crosses inside 12 weeks, the brand can afford to scale. If it crosses at 20+ weeks, the next budget increase is buying a cash-management problem, not growth. Blended CAC and reported ROAS both hide this. The cohort payback curve is the only number that surfaces it cleanly. Here is the math, the three patterns I see, and what each one means for the next budget decision.

The receipt

A $7M home furnishings brand on Shopify, last quarter. The dashboard said:

• Blended ROAS: 4.2x
• Blended CAC: $44
• Reported attribution: paid drove 64% of revenue

The board wanted to know if the brand could double paid spend in Q3. The agency said yes. I pulled the cohort and said no.

The cohort numbers told a different story:

• New-customer CAC (paid spend ÷ first-time orders): $127
• First-order AOV: $189
• First-order contribution margin (revenue minus COGS, shipping, payment processing, returns): $95
• The brand was losing $32 per new customer on the first transaction
• Month-2 repeat rate: 8%
• Month-6 repeat rate: 23%
• Month-12 cumulative contribution per customer: $148
• Payback week (cumulative margin = $127 CAC): week 14

Week 14 payback at the existing $45K/month spend was workable. Working capital was sitting at three months of operating cash. Doubling spend to $70K would have stretched the payback week toward 18-22 (because the marginal new customer at higher spend is always more expensive than the average) and dropped working capital to about six weeks. That is the difference between “growth” and “the founder loses a board seat in November.”

The board got a different recommendation: hold paid at $45K, push the marginal $25K into retention (Klaviyo flow rebuild + post-purchase upsell ladder), and revisit the doubling question in 90 days with a tighter payback curve.

That is the kind of read blended CAC cannot produce. The curve does.

How to calculate cohort payback properly

The math is mechanical. The discipline is in pulling clean inputs.

Input 1: paid-media spend for a defined acquisition cohort.

Pick a month. Pull total paid-media spend (Google Ads + Meta + Microsoft + any other) for that month. Subtract any spend that targeted retention or returning audiences (Meta retargeting on past purchasers, Google customer-match excluding new). What’s left is the new-customer acquisition spend for that cohort.

Input 2: net new customers acquired in the cohort month.

Pull Shopify’s “first-time orders” report for the same month. Each first-time order = one new customer. Do not use “all orders”. That mixes returning and skews CAC low.

Input 3: new-customer CAC.

Acquisition spend ÷ first-time orders. For the example above: $45K ÷ 354 = $127.

Input 4: weekly cumulative contribution margin per customer.

This is the work. For the new-customer cohort, track every order they place over the following 26 weeks. Calculate contribution margin per order (gross revenue minus discounts, shipping, COGS, payment processing, returns). Sum cumulatively at each weekly tick. Divide by the cohort size.

For the example brand: week 1 cumulative was $95 (the first-order margin). Week 4 was $98 (3% repeat in first month). Week 8 was $108. Week 12 was $119. Week 14 hit $127. Payback. Week 26 reached $148.

Output: the CAC payback curve.

Plot the weekly cumulative margin against the CAC. The week the line crosses is the payback week. Most home brands I work with should be solving for under 12 weeks. Over 20 is a cash-management risk regardless of how the ROAS looks.

The three curves I see

Curve A: payback inside 12 weeks.

The brand can afford to scale. The cohort pays back the acquisition cost fast enough that the marginal new customer doesn’t strain working capital before contributing. The growth budget decision becomes “how fast can we scale before CAC starts climbing past the breakeven point.”

Typically what produces Curve A: a post-purchase flow that holds a 25%+ Month-2 repeat rate (Klaviyo or Postscript), a category with natural cross-sell (lighting, decor accessories), a 50-65% gross margin product line.

Curve B: payback between 12 and 20 weeks.

The brand can hold the current budget but cannot afford to scale aggressively. The cohort pays back eventually but the slope is shallow enough that doubling spend stretches payback toward the 20+ week danger zone. The right move is to fix the slope (improve repeat rate or first-order margin) before adding more acquisition.

Curve B is the most common one I see on $3-10M home brands. The fix is usually retention infrastructure (email + SMS + post-purchase flow) and a margin pass on the catalog (kill the lowest-margin SKUs that are dragging blended CM down).

Curve C: payback at 20+ weeks or never.

The brand is acquiring at a loss the rest of the lifecycle cannot recover. Scaling makes the problem worse. The cohort never pays back the CAC. Every new customer is a cash drag, not a contribution.

Curve C usually has one of three causes: the CAC is structurally too high (paid channels are wrong for the AOV band), first-order margin is too thin (discounts and shipping eating the contribution), or repeat rate is broken (no email infrastructure, single-purchase category, or product-market fit problem masked by ad spend). The recommendation is always the same: stop scaling, fix the curve, come back when payback weeks crosses under 16.

What changes the curve

Three levers move CAC payback weeks. In rank order of impact for most home brands:

1. First-order contribution margin.

The biggest single lever. A $95 first-order margin going to $130 (through better margin SKUs, smarter discount discipline, or shipping that no longer eats $18 per order) is the difference between Curve B and Curve A. Most home brands have 10-15 points of margin on the table inside the first 90 days of working on the discount stack and the shipping math.

2. Month-2 repeat rate.

The second-biggest lever. Going from 8% to 18% Month-2 repeat (through a real Klaviyo flow, post-purchase upsell, abandoned-cart sequence) compounds across the curve. Each subsequent customer in the cohort contributes more, faster. A 10-point repeat-rate lift typically pulls payback in by 3-5 weeks on a Curve B brand.

3. New-customer CAC.

The lever everyone focuses on first and that moves the curve the least. Going from $127 CAC to $115 CAC (through better creative, tighter targeting, or a tracking-audit fix) is real money, but it does not change the shape of the curve. It shifts the starting point. The slope of cumulative contribution stays the same.

This is the order of operations for most growth conversations: fix the margin, fix retention, then re-look at CAC.

Why blended CAC fools the board

Blended CAC = total paid spend ÷ all orders. It mixes new and returning customers. Returning customers are cheap to reactivate (often an email cost), which pulls the blended number down hard.

The example brand’s blended CAC was $44. Its new-customer CAC was $127. The blended number told the board the brand was acquiring efficiently. The new-customer number told the board the front of the funnel was barely paying for itself.

A board reading blended CAC concludes the growth engine is healthy and approves doubling the budget. A board reading new-customer CAC and the payback curve sees the cash trap and approves holding budget while fixing retention.

The four-number deck I recommend for the quarterly board update puts new-customer CAC at Number 2 and payback weeks at Number 4 specifically to prevent the blended-CAC misread. The two numbers together tell the cash story. Blended CAC by itself tells nothing.

When the payback curve says “do not scale”

Three signals that the next budget increase should wait:

Payback already over 18 weeks at the current spend. Adding spend stretches it further. Fix the slope first.

Working capital under 90 days of operating expense. Even a Curve A brand can’t afford to double down if the cash cushion is thin. The marginal new customer at higher spend gets more expensive, payback stretches by 2-4 weeks, and the cash buffer goes from 90 days to 60. Get a cash buffer first.

Month-2 repeat rate under 10%. The shape of the cohort margin curve relies on repeat purchases. Sub-10% Month-2 repeat means the curve is going to be shallow no matter what the first-order margin is. Fix repeat before adding acquisition.

If any of these three is true, the right answer to “should we scale paid?” is “not yet.” The payback curve gives the founder language for that conversation.

Common errors in the calculation

Using gross revenue instead of contribution margin. Gross revenue makes payback look fast. The CAC is real cash out the door. The matching number has to be real cash in (after discounts, shipping, COGS, payment processing, and returns). Most agencies skip this and the curve looks 3-4 weeks shorter than reality.

Including returning-customer spend in the CAC numerator. Retargeting past purchasers is not new-customer acquisition. Strip it out. Otherwise CAC is inflated and the curve looks worse than it is.

Counting all orders instead of first-time orders in the denominator. Same direction, opposite reason. Mixing returning into the count makes CAC look low. Shopify’s first-time-orders report is the right input.

Pulling a single cohort and stopping. One month’s cohort is one data point. The curve has to be tracked across at least 3-4 cohorts before the pattern stabilizes. Quarterly is the minimum cadence.

Ignoring seasonal cohort variance. A November cohort acquired around Black Friday has a different shape than a March cohort. Compare like to like, not Q4 cohorts to Q1 cohorts.

Keep going

If this hit, the next two pieces in the same universe:

• The 4 numbers I put in a $20M home brand’s next board deck on paid. The board-prep memo where new-customer CAC and payback weeks are Numbers 2 and 4. This post is the methodology behind both.
• I paused all paid media in one state for 21 days. The companion post for Number 3 (incrementality lift). The geo holdout protocol that produces the true incremental ROAS the payback math should be calibrated against.

The Wasted Spend Calculator is the front-end version of the same math. A 60-second cash read on whether your existing spend is paying back.

If your blended CAC looks healthy and your finance team is still nervous about working capital, the disconnect is almost certainly in the new-customer payback curve. The setup call is the audit conversation.