Product Performance KPIs: The Metrics That Actually Tell You If a Product Is Working
by Trivas.ai
|
7 min read
Oct 23, 2026
Open your product performance dashboard right now and you'll probably see a leaderboard: top SKUs by revenue, sorted high to low. Looks great. Tells you almost nothing.
A product can sit at the top of that list and still be bleeding money once you factor in the 22% off discount code it ran last month, the return rate quietly climbing, and the ad spend it took to get those sales in the first place. Revenue per SKU is a vanity number dressed up as an insight. Product performance KPIs are supposed to fix that, but most teams only track the one or two that are easiest to pull, not the ones that actually tell them whether a product is working.
This is for DTC founders and growth leads running a catalog with more than a handful of SKUs, selling across at least one marketplace and spending on at least one paid channel. If that's you, you already know the spreadsheet is lying to you somewhere. This article covers what product performance KPIs actually are, which ones are worth the effort to track, and why doing it by hand stops working once your catalog crosses a certain size.
What Are Product Performance KPIs?
Product performance KPIs measure how a single product or SKU is doing against revenue, profit, customer experience, and operational goals. Not the store. Not the brand. The individual item.
That's the key difference from general ecommerce KPIs like total revenue or site-wide conversion rate. Those tell you how the business is doing in aggregate. Product performance KPIs tell you whether SKU #4821 should be restocked, discounted, or killed off entirely.
They fall into three buckets: commercial (sales and margin), customer (returns and reviews), and operational (inventory and fulfillment). A product can look healthy in one bucket and be quietly failing in another, which is exactly where most reporting breaks down.
The Core Categories of Product Performance KPIs
Four categories do the real work here.
Revenue and profitability. Sell-through rate, SKU-level contribution margin, revenue per unit after discounts. This is where most dashboards stop, which is the problem.
Customer signal. Return rate by product, review and rating trends, repeat purchase rate per SKU. A product with great margin and a 30% return rate isn't actually profitable, it just hasn't been caught yet.
Demand and marketing efficiency. Product-level conversion rate, ad spend to sales ratio per SKU, customer acquisition cost by product line. This is where you find out if a "best seller" is actually just a product you've been subsidizing with ad spend.
Operational. Inventory turnover rate, days of stock on hand, stockout frequency. A product can hit every commercial target and still be a mess operationally, tying up cash in slow-moving inventory.
A product needs to be judged across all four, not just whichever one happens to look good this month. Teams that only check revenue end up discontinuing profitable slow-sellers and reordering unprofitable fast-sellers. Both mistakes are expensive.
10 Product Performance KPIs Worth Tracking at the SKU Level
Here are the ones that earn their place on a dashboard, with the decision each one should drive.
Sell-through rate. Units sold divided by units received, over a given period. Drives restock or markdown decisions, especially for seasonal or limited-run products.
Contribution margin per SKU. Revenue minus COGS, shipping, and allocated ad spend, per unit. Tells you whether to keep selling a product at all, regardless of how many units move.
Product conversion rate. Product page views (or listing views on a marketplace) divided by purchases. Signals a pricing or listing problem if traffic is healthy but conversion isn't.
Return rate. Units returned divided by units sold, by SKU. Flags a sizing, quality, or description mismatch before it eats your margin.
Repeat purchase rate. Percentage of customers who buy that SKU again within a set window. High repeat rate justifies a higher CAC on that product.
Inventory turnover. COGS sold divided by average inventory value. Low turnover means cash is sitting on a shelf instead of in the bank.
Ad-to-sales ratio per SKU. Ad spend attributed to that product divided by revenue from that product. Tells you when to cut ad spend on a SKU that only sells while it's subsidized.
Customer acquisition cost per SKU. Ad spend divided by new customers acquired through that specific product. Different products often have wildly different CAC, even in the same catalog.
AOV contribution. How much a given SKU lifts average order value when it's in the cart, often as an add-on or bundle item. Worth knowing before you discontinue something that looks unremarkable on its own.
Time-to-first-sale for new launches. Days between going live and the first unit sold. A slow start on a new SKU is an early warning, not something to wait out for a full quarter.
Some of these are a five-minute pull from one platform. Sell-through rate and inventory turnover usually live cleanly in Shopify or Seller Central. Conversion rate and ad-to-sales ratio are the hard ones: they require blending order data, ad platform data, and sometimes marketplace data just to get an accurate per-SKU number. If you want exact formulas and definitions for any of these, the data dictionary has the breakdowns.
How to Actually Track These KPIs Without Living in Spreadsheets
Here's what this actually looks like for most teams: someone pulls a Seller Central report, exports Shopify analytics, downloads a Meta ads CSV, and manually joins all three in a spreadsheet. Weekly. By hand. Recalculating margin each time because COGS lives in a completely different system than the sales data.
It works, sort of, until it doesn't. Store-level KPIs are one row per week. Product-level KPIs multiply that by every SKU in your catalog, so a 200-SKU catalog turns a 10-row sheet into a 2,000-row nightmare, recalculated every time someone changes a price or a discount code. Margin math alone, with COGS sitting in yet another system, is where most of these sheets quietly go wrong.
The fix isn't a better spreadsheet template. It's a single data layer that joins order, ad, and marketplace data at the SKU level automatically, so contribution margin and ad-to-sales ratio are just numbers on a dashboard instead of a Tuesday afternoon project. That's the gap tools like BI reporting and product-level insights are built to close: one source of truth instead of three exports and a prayer that the VLOOKUP didn't break.
Once that historical data is clean, forecasting becomes the natural next step. Instead of finding out about a stockout the week it happens, forecasting and simulation lets you see a demand drop or inventory gap coming while there's still time to act on it.
Mistakes That Make Product Performance KPIs Misleading
Revenue without margin. The SKU at the top of your bestseller list might be the least profitable thing you sell once ad spend and discounts are netted out. Check both numbers before you reorder anything.
Inconsistent time windows. Comparing a product's trailing 30 days against another product's trailing 90 days and declaring a winner. It's an easy mistake to make when pulling reports from different platforms on different schedules, and it produces conclusions that don't hold up.
Ignoring return rate until it's a margin problem. Returns lag sales by days or weeks. By the time a rising return rate shows up in your profit numbers, you've already shipped a few hundred more units of the problem.
One threshold for every SKU. Apparel returns at 15% might be normal. Supplements at 15% is a different story entirely. Judging every product against the same benchmark, regardless of category, is how good products get killed and bad ones get a pass.
Turning Product KPIs Into Decisions, Not Just Dashboards
The whole point of tracking product performance KPIs is speed: catching the restock, the price change, or the ad budget cut before the spreadsheet would've told you about it next month.
A dashboard nobody acts on is just a more expensive spreadsheet. If any of this sounds like the reporting process your team already has, minus the manual exports and the margin guesswork, it might be worth seeing what unified product-level reporting looks like across Amazon, Shopify, and your ad accounts in one place. Worth a look before your next restock cycle, not after.
Content author and contributor at Trivas.ai, sharing insights on e-commerce analytics, business intelligence, and data-driven strategies to help businesses grow.
Continue Reading
explore more insights
Ecommerce Analytics for International Shopify Plus Brands: The BOFU Buying Guide
3 min read
Neptun Kosovo: Inside a 2025 Multi-Channel Ecommerce Reporting Overhaul
3 min read
Ecommerce Analytics for a European Shopify Brand Doing $10M
.d53b12e5.png&w=3840&q=75 "Trivas.ai")
