The BFCM CAC Payback Trap: Why Revenue Is Not Customer Value
Black Friday acquisition reports can look fantastic on Monday and terrible in February. The problem is not necessarily that the campaigns failed. It is that we keep treating first-order revenue as proof that a customer was worth acquiring.
If I am running CRM, I want to know something more useful than how many discounted orders came through the door. I want to know when those customers generate enough contribution to pay back what we spent acquiring them, and which of them are actually coming back without another expensive incentive.
Start with a cohort, not a blended ROAS
Shopify’s customer cohort analysis groups customers by first-order timing and can break out subsequent purchasing, spend per customer, first-order marketing channels, and subscription versus one-time purchases. That makes it a useful starting point for a BFCM quality-of-acquisition review.
The key is comparing customers at the same age. A November 2026 customer with 14 days of history should not be judged against a July customer with four months of opportunity to reorder. I would report day 0, day 30, day 60 and day 90 contribution on each acquisition cohort, and label immature cohorts as incomplete.
What I would put in the acquisition payback table
At minimum, every row needs first-order month, acquisition channel, first product, discount band, subscription versus one-time status, new-customer count, paid acquisition cost, net sales, refunds, variable fulfillment costs, product cost, payment fees and cumulative contribution. Where attribution is uncertain, show an unattributed bucket rather than forcing a clean answer.
The calculation is straightforward in principle: cumulative contribution from the acquired cohort divided by the cost of acquiring that cohort. Contribution should reflect the actual economics of orders after variable costs, not gross revenue. The first day that cumulative contribution covers acquisition cost is the observed payback point.
For example, imagine two channels each acquire 1,000 customers at $40 CAC. Channel A produces $55 in first-order net revenue per customer but only $12 in contribution after discounts and variable costs. Channel B produces $48 in revenue but $19 in contribution. Neither has paid back its $40 CAC on the first order, but Channel B starts $7 closer. These are illustrative numbers, not industry benchmarks.
If Channel A later drives a $20 second order with $8 contribution and Channel B drives a $30 second order with $15 contribution, the comparison changes again. That is why I want the cohort economics before I approve another round of discounts.
Keep new-customer bidding logic separate from actual retention
Google Ads supports customer lifecycle goals, including bidding modes for new-customer acquisition, high-value new customers and re-engagement. These tools can influence acquisition optimization, but the bidding configuration is not evidence that a cohort has generated incremental long-term profit.
I would audit the new-customer classification against the ecommerce customer record and separate returning purchasers from genuinely new customers. I would also avoid assuming an advertising platform’s reported conversion value equals the merchant’s net contribution.
Why the first repeat order needs its own scorecard
The repeat order is where a lot of the economics become visible, but it is easy to contaminate the measurement. A customer who buys again because of an aggressive 40% coupon is not economically equivalent to one who reorders at full price. Both count as repeat purchasers. Only one may materially improve payback.
Track second-order conversion, days to second order, second-order discount rate, contribution per second order and cumulative contribution per original acquired customer. Keep the denominator fixed to the original cohort. Otherwise a shrinking group of repeat buyers can make average order value look healthy while the cohort as a whole loses money.
I have written before about why the second order is the real test after Black Friday. This is the financial companion to that argument: measure the quality and contribution of the second order, not just its existence.
Use AI to investigate differences, not invent LTV
An AI analyst can help surface cohorts where discount exposure, product mix, refund behavior or fulfillment problems diverge. It can generate questions worth testing. It should not fill in missing acquisition costs, assume future retention or turn a predicted LTV into a realized outcome.
Shopify’s cohort reporting offers projections when enough historical data exists, but explicitly cautions that projections can differ from eventual spending. I would keep realized contribution and forecast contribution in separate columns with different labels, and use scenarios for the forecast.
The same discipline applies to predictive churn. A model that says a customer might leave is not a license to spend whatever it takes to retain them. The intervention has to make economic sense.
A practical two-week operating plan
Days 1 through 3: align Finance, Growth and CRM on the definition of net sales, contribution, CAC and a new customer. Freeze the rules for the comparison period. Document where refunds, taxes, shipping and platform fees enter the model.
Days 4 through 6: export first-order cohorts by channel, product, offer and subscription status. Reconcile the acquired customer counts to the ecommerce platform. Flag missing channel attribution rather than redistributing it by assumption.
Days 7 through 10: build the day-0, day-30, day-60 and day-90 contribution curves. Segment by discount band and identify the cohorts where repeat orders improve contribution versus simply increasing gross sales. Compare like-aged cohorts.
Days 11 through 14: turn the analysis into decisions. Which acquisition audiences deserve more budget? Which first products create a better second-purchase path? Which offers should stop? Which customers need product education instead of another coupon? Put an owner and a test design next to each decision.
The metric I would put in the leadership meeting
I would lead with cumulative contribution per acquired customer at a fixed cohort age, alongside CAC and the share of the cohort that has paid back acquisition cost. I would still show revenue, ROAS and repeat purchase rate, but not let any of them stand in for customer economics.
A Black Friday campaign can acquire a lot of customers. A good retention operation determines which of those relationships become valuable, how quickly, and at what cost. That is the difference between reporting a strong holiday and building a stronger business.
Comments