Most DTC brands calculate one blended CAC number. Total ad spend divided by total orders. Then they apply that single number to every product in the catalog. This is wrong — and it is hiding which products can actually afford paid acquisition and which ones cannot.
The blended CAC problem
Here is how most brands calculate customer acquisition cost: take total monthly ad spend, divide by total orders. If you spent $50,000 and got 2,000 orders, your CAC is $25. Simple. Clean. And deeply misleading.
The problem is that $25 gets applied to every product equally. A $120 jacket and a $28 tee both get charged $25 in acquisition cost. The jacket can absorb it easily. The tee cannot. But because you are averaging across the whole catalog, you never see the tee bleeding money on every ad-driven sale.
| SKU | Price | Gross Profit | Blended CAC | After CAC |
|---|---|---|---|---|
| SKU A — Premium Jacket | $120.00 | $60.00 | $25.00 | $35.00 |
| SKU B — Basic Tee | $28.00 | $15.00 | $25.00 | -$10.00 |
This is not a rounding error. In most catalogs, the gap between the highest-margin and lowest-margin products is large enough that a blended CAC makes some SKUs look profitable when they are not, and makes other SKUs look more expensive to acquire than they actually are. Both distortions lead to bad decisions: you overspend on products that cannot afford it and underspend on products that could scale.
3 ways to allocate CAC per SKU
There are three approaches, in order of increasing accuracy. Which one you use depends on how your ad campaigns are structured and how much data you have.
1. Revenue-weighted allocation
The simplest method. Each SKU gets charged a share of total ad spend proportional to its share of total revenue. If a product generates 40% of revenue, it absorbs 40% of ad spend.
Revenue-Weighted CAC
SKU CAC = (SKU Revenue / Total Revenue) x Total Ad Spend / SKU Orders
This works as a starting point, but it has a bias: it loads more ad cost onto higher-priced products. A $120 jacket absorbs 4x the ad spend of a $28 tee even if the tee required more advertising to sell. Revenue-weighted allocation is better than blended CAC, but it still makes assumptions about where the money went.
2. Order-weighted allocation
Instead of weighting by revenue, weight by order count. Each SKU gets a share of ad spend proportional to how many orders it accounts for. If a product is 25% of total orders, it absorbs 25% of ad spend.
Order-Weighted CAC
SKU CAC = (SKU Orders / Total Orders) x Total Ad Spend / SKU Orders = Total Ad Spend / Total Orders
Notice something: order-weighted allocation actually gives every SKU the same per-order CAC. It is essentially the blended number again. The difference is subtle — it is more useful when you combine it with break-even analysis per SKU, because it shows you which products can and cannot absorb the average acquisition cost. It is most useful for catalogs where products have similar price points but different cost structures.
3. Channel-specific allocation
The most accurate method. If you run SKU-specific ad campaigns — a Meta campaign for the jacket, a Google Shopping group for the tee, a TikTok campaign for the shorts — you allocate each campaign's spend directly to the SKU it promotes.
Channel-Specific CAC
SKU CAC = (Campaign Spend Attributed to SKU) / (Orders from That Campaign)
This requires campaign-level tracking and ideally UTM-tagged landing pages or post-purchase attribution. It is more work to set up, but the data is real rather than estimated. For shared campaigns (like a brand awareness campaign that drives sales across multiple products), you can still use revenue-weighted or order-weighted allocation for the shared portion and channel-specific for dedicated campaigns.
| SKU | Revenue | Orders | Revenue-Weighted | Order-Weighted | Channel-Specific |
|---|---|---|---|---|---|
| Premium Jacket | $48,000 | 400 | $20.00 | $12.50 | $8.00 |
| Basic Tee | $14,000 | 500 | $5.83 | $12.50 | $22.00 |
| Running Shorts | $27,000 | 450 | $11.25 | $11.25 | $14.00 |
| Canvas Bag | $18,000 | 360 | $7.50 | $9.00 | $4.50 |
| Phone Case | $13,000 | 290 | $5.42 | $7.25 | $1.50 |
The table tells a clear story. Under revenue-weighted allocation, the Basic Tee looks cheap to acquire at $5.83. Under channel-specific allocation, it is actually $22.00 — because the tee had a dedicated Meta campaign that burned through budget with a poor conversion rate. The blended number hid that entirely.
Meanwhile, the Canvas Bag and Phone Case are far cheaper to acquire than any averaging method would suggest, because they sell primarily through organic search and repeat purchases. Those SKUs are subsidizing the tee's ad spend in blended reporting.
What changes when you allocate properly
Once you break CAC out per SKU instead of averaging it, four things become visible that were hidden before:
| Finding | Action | Decision |
|---|---|---|
| SKU has gross profit >> its allocated CAC | Raise ad spend — this product can afford more acquisition | Scale |
| SKU has gross profit < its allocated CAC | Pause paid ads — sell through organic, email, or bundles | Pause |
| SKU is only profitable with organic traffic | Keep in catalog but never bid on it directly | Organic only |
| Best seller by revenue, worst by margin after CAC | Re-evaluate — volume without margin is just expensive logistics | Investigate |
The last row is the most common surprise. Your best-selling product by revenue — the one you are proudest of, the one you feature on your homepage — might be your worst margin product after allocated CAC. Volume without margin is just expensive logistics. You are paying to move boxes without keeping any of the money.
This does not mean you kill your best seller. It means you stop advertising it and let organic demand carry it, or you raise the price, or you pair it with a high-margin upsell. The fix depends on the product. But you cannot fix what you cannot see, and blended CAC keeps it invisible.
Finding your break-even CAC per SKU
Once you know each product's allocated CAC, the next question is: what is the maximum each product can afford? That is your break-even CAC — the point where an ad-driven sale produces exactly zero contribution margin.
Break-Even CAC Formula
Break-Even CAC = Sale Price - COGS - Shipping - Payment Fees - Returns Allowance - Fulfillment
In other words, break-even CAC is gross profit minus every other variable cost except acquisition. It is the ceiling. Spend above it and the product loses money on every paid sale. Spend below it and you have contribution margin left over.
The gap between your actual allocated CAC and your break-even CAC is your headroom. Products with large headroom can afford more aggressive bidding. Products with no headroom should not be advertised at all.
We covered this in detail in our guide on how to calculate break-even CAC by SKU, including worked examples for a five-product catalog.
Stop averaging. Start allocating.
You can do this in a spreadsheet. Pull your ad platform data, map campaigns to SKUs, and calculate per-product CAC manually. It works — until your campaigns change, your product mix shifts, or you add new SKUs. Then you are rebuilding the spreadsheet from scratch.
MarginCaptain automates per-SKU cost allocation — including CAC — and shows you exactly which products can afford paid acquisition and which ones cannot. It runs the break-even analysis across your entire catalog so you can see headroom per SKU in real time.
Try the interactive demo to see how a 10-SKU catalog looks when you stop averaging CAC and start allocating it. The numbers will look different from what you are used to — and that is the point.