Product Line Profitability Analysis: How to Find (and Kill) the SKUs Draining Your DTC Brand

Here's a stat that should make every DTC founder uncomfortable: in the average ecommerce catalog, 20-30% of SKUs generate negative contribution margin after you factor in all variable costs. Not "low margin." Negative. Every unit sold makes the business poorer.

And yet most brands have no idea which products those are.

They look at top-line revenue by product, see that their best-seller does $200K/month, and assume that's their most profitable line. Meanwhile, a SKU doing $30K/month with 68% contribution margin is quietly subsidizing the entire operation — and nobody's paying attention to it.

Product line profitability analysis isn't glamorous. It's spreadsheets, allocation decisions, and uncomfortable conversations about killing products that "the team loves." But it's also the single fastest way to improve your bottom line without spending a dollar more on acquisition.

At ATTN Agency, we've seen brands increase net margin by 8-15 percentage points just by restructuring their product portfolio based on actual unit economics. No new products. No new channels. Just math.

Let's break down exactly how to do it.

Why Revenue-Based Product Analysis Is Lying to You

Most brands rank their products by revenue. Maybe gross revenue, maybe net of returns. Either way, it's the wrong metric for making portfolio decisions.

Here's why: revenue tells you nothing about profitability at the unit level. A product doing $500K/month at 15% contribution margin generates $75K in contribution. A product doing $150K/month at 55% contribution margin generates $82.5K. The "smaller" product is literally more valuable to your business.

But it gets worse. Revenue-based analysis hides:

Variable cost differences across products (packaging, shipping weight, fulfillment complexity)
Return rate disparities — some products get returned at 3%, others at 25%
Customer service load — complex products generate more tickets per unit
Ad spend allocation — some products require 3x the CPA to move
Discount dependency — products that only sell at 30% off aren't really generating the margin you think

When you stack all of these against each product line, the profitability picture looks radically different from the revenue picture.

The Product Line Profitability Framework

Here's the framework we use with every DTC brand we work with. It's not theoretical — it's been pressure-tested across 100+ brands doing $1M-$50M annually.

Step 1: Calculate True COGS Per Product Line

Start with landed COGS, not just manufacturer cost. This includes:

Raw product cost (what you pay the manufacturer or supplier per unit)
Inbound freight (allocated per unit based on weight/volume)
Duties and tariffs (if importing — this is often 5-15% that brands forget)
Packaging materials (primary packaging, inserts, poly mailers or boxes)
Assembly or kitting labor (if you bundle or customize)

For a typical DTC skincare brand, here's what this looks like:

| Cost Component | Serum (Hero SKU) | Moisturizer | Eye Cream | Bundle (3-Pack) | |---|---|---|---|---| | Product Cost | $8.50 | $6.20 | $5.80 | $20.50 | | Inbound Freight | $0.85 | $0.90 | $0.60 | $2.35 | | Duties (8%) | $0.68 | $0.50 | $0.46 | $1.64 | | Packaging | $2.10 | $1.80 | $1.50 | $4.20 | | Kitting Labor | $0.00 | $0.00 | $0.00 | $1.50 | | True COGS | $12.13 | $9.40 | $8.36 | $30.19 |

Most brands only track the first line. That's a 30-40% undercount of actual COGS.

Step 2: Map Variable Costs Per Product Line

Beyond COGS, every product has variable costs that scale with each unit sold:

Fulfillment cost (pick, pack, ship — varies by size/weight/complexity)
Outbound shipping (actual carrier cost or average if you offer flat-rate)
Payment processing (typically 2.9% + $0.30 per transaction)
Platform/marketplace fees (if selling on Amazon, Shopify Payments, etc.)
Return processing (receiving, inspecting, restocking or disposing — multiplied by return rate)
Customer service cost (average tickets per order × cost per ticket)

Continuing the skincare example:

| Variable Cost | Serum | Moisturizer | Eye Cream | Bundle | |---|---|---|---|---| | Fulfillment | $3.20 | $3.20 | $3.00 | $4.50 | | Shipping | $5.80 | $5.80 | $4.90 | $7.20 | | Payment Processing | $2.02 | $1.55 | $1.26 | $3.48 | | Return Cost (rate × cost) | $1.44 (8%) | $0.96 (6%) | $2.70 (15%) | $2.40 (6%) | | CS Cost | $0.80 | $0.60 | $1.40 | $1.20 | | Total Variable | $13.26 | $12.11 | $13.26 | $18.78 |

Notice the eye cream — it has the lowest product cost but a 15% return rate and higher CS load. These hidden costs fundamentally change the profitability picture.

Step 3: Calculate Contribution Margin Per Product Line

Now you can calculate true contribution margin:

Contribution Margin = Net Revenue - True COGS - Variable Costs

| Metric | Serum ($65) | Moisturizer ($48) | Eye Cream ($38) | Bundle ($108) | |---|---|---|---|---| | Net Revenue (after discounts) | $58.50 | $43.20 | $30.40 | $97.20 | | True COGS | $12.13 | $9.40 | $8.36 | $30.19 | | Variable Costs | $13.26 | $12.11 | $13.26 | $18.78 | | Contribution Margin ($) | $33.11 | $21.69 | $8.78 | $48.23 | | Contribution Margin (%) | 56.6% | 50.2% | 28.9% | 49.6% |

The eye cream — which looked fine on a revenue basis — is barely contributing. And this is before allocating any marketing spend to it.

Step 4: Allocate Marketing Spend

This is where most analyses fall apart because marketing allocation is genuinely hard. But you have to do it, even imperfectly.

Three approaches, from simple to sophisticated:

Revenue-proportional allocation: Divide total ad spend based on each product's share of revenue. Simple but inaccurate — it assumes all products require equal marketing intensity.

Campaign-level allocation: Map ad spend directly to product-specific campaigns. More accurate but misses brand-level spend that drives traffic to all products.

Blended approach (recommended): Allocate product-specific campaign spend directly, then divide brand/awareness spend proportionally by revenue. This gets you 80% accuracy with reasonable effort.

For our skincare example (assuming $45K/month total ad spend):

| Marketing | Serum | Moisturizer | Eye Cream | Bundle | |---|---|---|---|---| | Direct Campaign Spend | $18,000 | $8,000 | $7,000 | $12,000 | | Units Sold/Month | 800 | 500 | 300 | 250 | | Marketing Cost/Unit | $22.50 | $16.00 | $23.33 | $48.00 |

Step 5: Calculate Fully-Loaded Product Line P&L

| Final P&L | Serum | Moisturizer | Eye Cream | Bundle | |---|---|---|---|---| | Contribution Margin/Unit | $33.11 | $21.69 | $8.78 | $48.23 | | Marketing Cost/Unit | $22.50 | $16.00 | $23.33 | $48.00 | | Profit/Unit | $10.61 | $5.69 | -$14.55 | $0.23 | | Monthly Units | 800 | 500 | 300 | 250 | | Monthly Product Profit | $8,488 | $2,845 | -$4,365 | $58 |

There it is. The eye cream is losing $14.55 per unit sold. Every ad dollar spent driving eye cream sales is making the business less profitable. And the bundle — which looked like a strong offering — is basically breaking even.

The Product Portfolio Matrix

Once you have contribution margin and marketing efficiency for every product line, plot them on a 2x2 matrix:

Stars (High CM%, Low CPA)

These are your money-makers. They convert efficiently and generate strong margin. Pour fuel on them. In our example: the serum.

Action: Increase budget allocation. Test new audiences. Create content variants. These products should get 50-60% of your ad spend.

Cash Cows (High CM%, High CPA)

Good margin but expensive to acquire customers for. Often mature products with saturated audiences.

Action: Focus on retention and repeat purchase. Use email/SMS to drive reorders rather than relying on paid acquisition. Reduce paid spend and let organic/retention carry volume.

Question Marks (Low CM%, Low CPA)

Cheap to acquire customers for but low margin. Could be gateway products that lead to higher-margin purchases.

Action: Analyze post-purchase behavior. If buyers of this product subsequently buy Stars, keep it as a loss leader with a defined allowable CPA. If not, consider discontinuing or reformulating for better margin.

Dogs (Low CM%, High CPA)

The worst of both worlds. Low margin and expensive to sell. Our eye cream lives here.

Action: Kill it, reformulate it, or radically reprice it. Do not continue spending marketing dollars on products in this quadrant. Every dollar here has a better use somewhere else.

How to Make the Hard Decisions

Identifying unprofitable products is the easy part. Actually doing something about it is where brands struggle. Here's the decision framework:

Decision 1: Can You Fix the Margin?

Before killing a product, ask if you can improve its unit economics:

Renegotiate supplier pricing — if you've grown volume, you may have leverage you haven't used
Reduce return rates — better product descriptions, size guides, or reformulation
Simplify packaging — does this product really need the custom box and tissue paper?
Optimize fulfillment — can you ship this product in a poly mailer instead of a box?

If you can get contribution margin above 40%, the product might be worth keeping.

Decision 2: Does It Drive Lifetime Value?

Some products are intentionally low-margin because they bring in customers who later buy high-margin products. This is a valid strategy — but you need to prove it with data.

Pull cohort data on customers who entered via each product line. Track their 90-day and 12-month LTV. If eye cream buyers have a 12-month LTV of $180+ (compared to $120 for the average customer), the negative per-unit margin might be justified as an acquisition cost.

In our experience, this justification holds true about 20% of the time. The other 80%, brands are just telling themselves a story to avoid killing a product someone on the team is emotionally attached to.

Decision 3: What's the Catalog Effect?

Removing a product affects perception. A skincare brand with only two products feels incomplete. But a brand with 15 SKUs where 6 are unprofitable is bleeding money to maintain an illusion of breadth.

The sweet spot for most DTC brands: 8-15 active SKUs with contribution margins above 40% across the board. Better to have a tight, profitable catalog than a broad, unprofitable one.

Real Numbers: What Good Looks Like

After working with 100+ DTC brands on product line profitability, here are the benchmarks we see from top-performing brands:

Contribution margin spread: Top SKU at 55-65%, worst active SKU at 35-40%. No SKU below 30%.
Revenue concentration: Top 3 SKUs drive 60-70% of revenue. This is healthy, not a risk.
SKU-level ROAS: Every actively-marketed SKU achieves 3x+ blended ROAS when measured at the product level.
Return rate range: Best-in-class brands keep every product under 10% return rate. Any product over 15% gets immediate attention.
Marketing allocation match: Ad spend allocation roughly mirrors contribution dollar generation (not revenue generation).

Brands that hit these benchmarks typically operate at 15-22% net margin. Brands that don't are usually in the 5-10% range — or negative.

The Quarterly Product Line Review

This isn't a one-time exercise. Product line profitability shifts as costs change, competitors move, and consumer preferences evolve.

Set up a quarterly review cadence:

Week 1 of each quarter:

Pull updated COGS for all product lines (check for supplier price changes, duty rate changes)
Recalculate variable costs (shipping rates change, return rates shift)
Pull marketing spend and unit volumes for the prior quarter
Rebuild the product line P&L

Review meeting agenda:

P&L walkthrough — any product lines that moved quadrants?
Margin trend analysis — are margins improving or degrading? Why?
Kill/fix/fuel decisions — what changes based on this quarter's data?
New product evaluation — does any proposed new product meet minimum margin thresholds before launch?

The golden rule for new products: Never launch a SKU without modeling its unit economics first. If it doesn't clear 40% contribution margin at projected volume, it doesn't launch. Period.

Common Mistakes in Product Line Analysis

Mistake 1: Ignoring Shared Costs

Some costs are shared across products — warehouse rent, software subscriptions, salaried staff. Don't allocate these to individual products for profitability analysis. They're fixed costs that exist regardless of your product mix. Contribution margin (before fixed costs) is the right metric for product portfolio decisions.

Mistake 2: Using Average Shipping Costs

A 2 oz serum and a 16 oz body lotion don't cost the same to ship. Use actual shipping costs by product, not catalog-wide averages. This is especially important if you offer free shipping — the cost difference between products is hidden from the customer but very real on your P&L.

Mistake 3: Forgetting Discount Rates Vary by Product

If your eye cream only sells when it's 30% off but your serum sells at full price 80% of the time, their effective revenue per unit is drastically different. Always use net revenue (after discounts, not before) in your profitability calculations.

Mistake 4: Annual Analysis Only

Product profitability changes faster than you think. Supplier costs shift, shipping rates adjust quarterly, return rates fluctuate seasonally. Annual reviews aren't frequent enough. Quarterly is the minimum; monthly is better if you have the data infrastructure.

Mistake 5: Emotional Attachment to Products

The founder's favorite product. The SKU that launched the brand. The product with great reviews but terrible margins. Emotional attachment to products is the #1 reason brands carry unprofitable SKUs. The numbers don't care about sentiment. Neither should your portfolio decisions.

Action Steps: Start This Week

You don't need a perfect system to start. Here's what you can do in the next 5 days:

Day 1: Export your product catalog with COGS. Add inbound freight, duties, and packaging costs per unit.

Day 2: Pull fulfillment costs, shipping costs, and return rates by product from your 3PL or Shopify data.

Day 3: Calculate contribution margin per product line. Rank them. Identify any below 30%.

Day 4: Allocate marketing spend to product lines using the blended approach. Calculate fully-loaded profit per unit.

Day 5: Build your 2x2 matrix. Identify your Stars, Cash Cows, Question Marks, and Dogs. Make one decision: which Dog are you killing first?

The brands that do this work — consistently, quarterly, with intellectual honesty — are the ones that scale profitably. Everyone else is just growing their revenue while their margin bleeds out.

Your product catalog is not a museum. It's a portfolio. Manage it like one.