What is SKU-level profitability? It means breaking down your revenue and costs for every single product. This shows you exactly which items make money and which ones quietly drain your ad budget, warehouse space, and profit margins. At PROHED, we analyze this first whenever an e-commerce brand has strong sales but low cash in the bank.
Your revenue dashboard looks fine. Orders are coming in. Ad spend is converting. And yet, at the end of the month, the margin is thinner than it should be, and nobody can quite explain where it went.
This is one of the most common situations seen across ecommerce brands in India, particularly in the ₹20L-₹1Cr monthly revenue range. The business looks like it’s working from the outside. The problem is that inside the catalogue, a handful of SKUs are quietly consuming resources, ad spend, logistics costs, return rates, customer service time, at a rate that makes them net negative contributors even when their revenue line looks perfectly acceptable.
At PROHED, we build product profitability analysis into every D2C client’s strategy from day one. Across the e-commerce brands we managed in 2025-26, those running these reviews found that 15% to 25% of their active products either just broke even or actually lost money. More importantly, ad spend pushed toward these underperforming items directly dragged down the account’s overall marketing efficiency.
The good news is that finding these products isn’t complicated. The fix, once they’re identified, is usually straightforward. The hard part is knowing what to look for and where
Why Revenue-Level Reporting Hides the Real Problem
Most ecommerce brands track performance at the campaign level or the category level. Revenue per category, ROAS per campaign, total orders per month. These numbers are useful, but they’re also dangerously incomplete for understanding margin health.
The issue is simple: average performance masks individual product performance. A skincare catalogue might show a healthy 4x blended ROAS across the account. However, within that catalogue, a hero moisturiser might be running at 7x while a slow-moving SPF product is running at 1.8x, below the threshold needed to cover acquisition cost, fulfilment, and return handling.
When both products sit inside the same campaign or category report, the hero carries the underperformer. The overall number looks acceptable. The margin problem stays hidden. And the brand keeps spending on both products at similar intensity, not realising that one is subsidising the other.
Furthermore, this problem compounds as catalogues grow. A 10-SKU brand can usually spot this manually. A 50-SKU or 200-SKU brand almost certainly cannot — not without deliberately building SKU-level profitability tracking into the ecommerce analytics infrastructure.
The True Cost of a SKU – What Most Brands Miss
The first step in any SKU profitability analysis is building an accurate picture of what each product actually costs, not just the cost of goods, but the full loaded cost of putting that product in a customer’s hands and keeping them satisfied with the experience.
Most ecommerce brands calculate product margin as selling price minus cost of goods. That calculation misses at least four significant cost categories that vary meaningfully by SKU.
- Fulfilment cost per unit: Heavier or bulkier products cost more to ship. Products requiring special packaging cost more to prepare. If a brand is running on flat-rate fulfilment assumptions, the lighter SKUs are effectively subsidising the heavier ones, and that subsidy doesn’t show up anywhere in the standard margin calculation.
- Return rate by SKU: This is the one that surprises most founders. A product with a 20% return rate has a fundamentally different true margin than one with a 3% return rate, even if the selling price and COGS are identical. Returns consume reverse logistics cost, re-processing cost, and often result in inventory write-downs for items that can’t be resold at full price. Tracking return rate at the SKU level is one of the highest-value additions to any ecommerce analytics setup.
- Customer acquisition cost by SKU: Not all products attract buyers at the same cost. Some SKUs convert efficiently from paid traffic. Others require significantly more ad spend per conversion, whether because the product is harder to communicate in an ad, the category is more competitive, or the audience is harder to reach. When campaigns are structured at the catalogue or category level rather than the SKU level, this cost difference is invisible.
- Customer service load by SKU: Some products generate a disproportionate volume of customer queries, complaints, and resolution requests. That service cost is real, it consumes team time, increases operational overhead, and in high-return-rate scenarios, directly reduces the effective margin on every unit sold.
The Prohed SKU Profitability Framework
At Prohed, the approach to SKU-level profitability analysis for ecommerce clients is built around what the team calls the Prohed SKU Margin Audit, a four-step process for identifying which products in a catalogue are genuinely worth scaling, which need to be restructured, and which should be quietly phased out.
Step 1: Build the True Cost Stack Per SKU
Before any analysis is meaningful, the cost data needs to be complete. For each active SKU, build a cost stack that includes COGS, average fulfilment cost per unit, packaging cost, return rate applied to reverse logistics cost, and an allocated portion of customer service cost if that data is available.
The output of this step is a true contribution margin per unit for each SKU, the amount left over after all variable costs are deducted from the selling price, before marketing spend is applied.
Step 2: Layer in SKU-Level Marketing Cost
Once true contribution margin is established, layer in the actual acquisition cost for each SKU from your e-commerce data analysis. Pull conversion data at the product level from your ad account, calculate cost per purchase per SKU, and subtract this from the contribution margin calculated in Step 1.
The resulting number is the net margin per unit per SKU after marketing, the closest approximation to what each product is actually contributing to the business on a per-sale basis.
Step 3: Classify Every SKU Into One of Four Categories
With accurate per-SKU net margin data in hand, every product in the catalogue can be classified into one of four groups.
- Profit engines are SKUs with strong net margin after marketing, healthy conversion rates, and manageable return rates. These are the products that deserve scaled investment, more creative resources, and priority placement in the media plan.
- Fixable underperformers are SKUs where the underlying product economics are sound but the marketing cost is too high. The contribution margin is healthy, but acquisition cost is compressing the net margin. These products need creative testing, audience refinement, or landing page optimisation, not budget cuts.
- Structurally broken SKUs are products where the issue isn’t marketing efficiency but underlying economics. High return rates, thin contribution margin, or excessive fulfilment costs mean that no amount of creative optimisation will fix the margin problem. These SKUs need repricing, reformulation, or discontinuation.
- Catalogue filler are low-volume, low-margin SKUs that aren’t losing significant money but aren’t contributing meaningfully to growth either. These consume disproportionate operational attention relative to their revenue contribution and are often the first candidates for quiet phase-out during a catalogue rationalisation.
Step 4: Realign Ad Spend to Match SKU Classification
This is where the analysis becomes ecommerce strategy. Once SKUs are classified, the media plan is restructured to reflect the classification. Profit engines get increased budget and creative priority. Fixable underperformers get a defined testing window with a specific improvement target. Structurally broken SKUs get spending paused immediately. Catalogue filler gets minimal organic support only, no paid media.
The impact of this reallocation on overall account MER is typically significant. Moving spend from underperforming SKUs to profit engines, without increasing total budget, consistently improves blended ROAS and overall contribution margin per marketing rupee spent.
What This Looks Like in Practice
A D2C personal care brand managed by Prohed had a catalogue of 34 active SKUs spread across skincare, haircare, and body care categories. Their blended ROAS across the account was 3.8x, which looked acceptable. However, the monthly margin after all costs was significantly below what the revenue numbers suggested it should be.
After running the Prohed SKU Margin Audit, the picture became clear. Eight SKUs were classified as profit engines, together they represented 41% of revenue but 68% of net margin contribution. Eleven SKUs were classified as structurally broken, primarily driven by a combination of high return rates and heavy fulfilment costs on bulky formats. The remaining fifteen were a mix of fixable underperformers and catalogue filler.
Ad spend was reallocated away from the eleven structurally broken SKUs and toward the eight profit engines. Simultaneously, creative testing was initiated on three of the fixable underperformers to identify whether improved landing pages and ad angles could bring acquisition costs down to a viable margin.
Within 60 days, blended account ROAS improved from 3.8x to 5.1x on the same total budget. More meaningfully, contribution margin per order improved by 34%, because the mix of products being sold had shifted toward the ones that were actually profitable.
Same budget. Same catalogue. Just a much clearer view of which products deserved the spend.
The Ecommerce Analytics Setup That Makes This Possible
SKU-level profitability analysis is only as good as the data infrastructure supporting it. Without the right ecommerce analytics setup, the cost data needed to run this analysis simply doesn’t exist in one place.
The minimum viable setup for SKU-level tracking includes product-level conversion data from your ad account, COGS data per SKU from your inventory management system, SKU-level return rate data from your order management system, and fulfilment cost data from your 3PL or shipping provider.
Ideally, all of this data flows into a single dashboard, whether that’s a custom build in Google Looker Studio, a Shopify analytics setup with the right app integrations, or a dedicated ecommerce analytics tool. The goal is a single view where every SKU’s true net margin is visible without requiring a manual spreadsheet exercise every month.
Additionally, this infrastructure supports better decisions beyond just SKU rationalisation. When SKU-level margin data is connected to your paid media reporting, it becomes possible to set SKU-specific ROAS targets that reflect actual margin rather than a single blended target across a mixed catalogue. That precision, applied consistently, is what separates ecommerce brands that scale profitably from those that scale revenue while watching margin compress.
Related read: The D2C Metrics Dashboard Every Founder Needs: 9 Numbers That Matter More Than ROAS
How Prohed Approaches SKU-Level Profitability for Ecommerce Clients
At PROHED, we focus on individual product profitability right from day one, not after low margins become a major problem.
Every partnership starts with a product audit. We figure out exactly which items make enough profit to justify ad spend and which ones do not. We then build campaigns around these findings. This ensures your budget automatically flows to your most profitable products, instead of being wasted equally across your entire catalog.
Beyond performance marketing, our full range of services keeps profits in mind:
- SEO: We build organic traffic for your highest-margin products.
- Social Media: We create content only for products that can absorb brand-building costs.
- Google Ads: We optimize for individual product margins rather than a generic, account-wide ROAS.
- Audits: We quickly find where your current ads are wasting money on slow-moving items.
If your e-commerce revenue looks healthy but your actual profits are not, you need a team that knows the difference between scaling sales and scaling profit. PROHED is that partner.
Frequently Asked Questions
1. Why does blended ROAS hide SKU-level margin problems?
Blended ROAS averages performance across all products in a catalogue. When high-performing SKUs and low-performing SKUs sit inside the same campaign or category report, the strong products carry the weak ones in the overall number. The result is an account metric that looks acceptable while individual products quietly destroy margin. SKU-level analysis breaks the average down to reveal what’s actually happening at the product level.
2. Which costs are most commonly missed in SKU profitability analysis?
The four most commonly missed cost categories are return rate applied to reverse logistics cost, SKU-specific fulfilment cost per unit for heavy or bulky products, customer acquisition cost calculated at the SKU level rather than the account level, and customer service load generated by specific products. Each of these varies significantly by SKU and can materially change the true margin calculation.
3. How do you calculate true contribution margin per SKU?
Start with the selling price. Subtract cost of goods, average fulfilment cost per unit, packaging cost, and return rate multiplied by reverse logistics cost. The resulting number is the contribution margin per unit before marketing spend. Then subtract the average customer acquisition cost for that specific SKU from your paid media data. The final number is the net margin per unit per SKU after marketing.
4. What should a brand do with structurally broken SKUs?
A structurally broken SKU has fundamental economic flaws like high return rates or expensive shipping costs that ads cannot fix. You must either raise the price, lower production costs, or stop selling the item entirely. Turn off ads for these products immediately to stop losing money while you decide on a long-term plan.
5. How often should ecommerce brands run SKU profitability analysis?
Run a full product margin audit every quarter. You should also run one whenever shipping costs, return rates, or competitor prices change significantly. Additionally, review your product-level sales and return data every month. This helps you catch and fix broken products before they drain your budget for months on end.
6. What ecommerce analytics infrastructure is needed for SKU-level tracking?
You need to connect sales data from your ad accounts, product costs from your inventory, return rates from your order management, and shipping costs from your logistics partner. Pulling all of this into a single dashboard like Google Looker Studio or Shopify Analytics saves you from building manual spreadsheets every month.
7. Can SKU-level profitability analysis improve overall account ROAS without increasing budget?
Yes, and this is one of the most consistently impactful findings from the Prohed SKU Margin Audit process. When ad spend is reallocated from structurally broken or catalogue-filler SKUs to profit engines on the same total budget, blended account ROAS typically improves significantly because a higher proportion of spend is now driving purchases of genuinely profitable products. The D2C personal care example above saw blended ROAS improve from 3.8x to 5.1x with zero increase in total ad spend.
8. How does SKU-level thinking affect campaign structure in paid media?
Instead of setting one generic sales target for your whole store, you set specific targets for each product based on its actual profit margin. High-margin products can handle a lower sales target because they make more cash per sale, while low-margin products need much higher targets to stay profitable.
9. How does Prohed incorporate SKU-level profitability into ecommerce campaigns?
We start with a margin audit to sort your catalog into top profit makers, fixable items, broken products, and filler items. We build your campaigns so your budget automatically goes to the most profitable items, then review this data monthly to adjust spend based on real-time profits.
Want to know which products are actually driving your growth? Partner with PROHED to uncover your true SKU-level profitability.
Schedule Free Consultation to Maximize Your Performance
