━ Analyses·Live

DTC Pet Nutrition Brand — Acquisition Payback & Retention Offer Model

Interactive cohort model built from 100K+ orders that prices new-customer payback, designs a two-tier subscribe-and-save offer, and sizes the holdout test needed to prove it.

01

The Goal

The Client (a premium DTC pet nutrition brand) was weighing two moves at once: putting real money behind new-customer acquisition, and launching a subscribe-and-save offer to lift repeat purchase. Leadership wanted to know what a new customer is actually worth, how fast one pays back, and whether a retention discount would earn its cost or just give margin away to customers who were coming back anyway.

· What does a new customer return over 24, 36, and 60 months, and when do they pay back? · What happens if the brand holds acquisition flat and does nothing? · How should a retention offer be structured so it changes behavior without subsidizing it? · How long would a clean test take to prove it worked?

02

How We Went About It

Started from roughly nine years of order history. Customers were matched on email rather than account ID, because nearly one in five orders came through guest checkout and would otherwise have looked like brand-new buyers every time. One-time and repeat buyers were modeled on separate curves, and lifetime value was split into retention (do they come back?) and basket (what do they spend when they do?), so each lever could be pressure-tested on its own.

Four connected pieces:

· A do-nothing floor — what revenue looks like if budget and CPA stay where they are · A payback model at a default $120 CPA, month by month, on an illustrative $10K/month budget · Recency segmentation — what each slice of the existing file is worth over the next two years · A retention offer simulator — an enrollment discount on the second order plus a standing subscription discount, modeled as twelve monthly cohorts that each earn only the months left in year one, with offer-driven conversions discounted 50% to avoid over-crediting the offer

The deliverable is one interactive HTML file. The client can move CPA, budget, retention, and discount inputs and watch payback, year-one cost, and test duration recompute live. Volumes are rounded and the margin is set to an illustrative 50% for this public version.

03

Key Insights

(1) Acquisition pays back fast, but flat spend only holds the line. A $120 customer pays back in month 3, and the program is in the black by month 6 after a low point of roughly $7K out of pocket. Holding budget and CPA flat keeps revenue roughly level (+2% over two years). Growth requires scaling spend, which is exactly the assumption a live test has to prove.

(2) Recency is the whole story in the existing file. A customer who bought last month is worth about $2,057 over the next two years; one lapsed 13–24 months is worth about $45. The 12% of customers who bought in the last three months drive 86% of existing-customer revenue, and existing customers generate roughly 14x the monthly revenue of new first orders.

(3) Make the second order the loud part. Point for point, the standing discount costs about 3.4x more than the enrollment discount, because it applies to every future order. A 20% standing rate costs as much in year one as a 68% one-time second-order discount, and keeps costing every year after. The recommended structure leads with a strong second-order incentive and keeps the standing rate low.

(4) Measure what can actually move in time. At roughly 80 new customers a month, a 25% holdout reads a shift in subscription enrollment in about seven months, while a 3-point lift in repeat rate would take more than five years to detect. So enrollment became the success metric and repeat rate the guardrail. A competitive benchmark of 11 pet food brands also showed the Client was the only one with no acquisition offer at all.