For many direct-to-consumer (D2C) founders, ecommerce managers, and operations leaders, the primary metric of success is top-line revenue. However, viewing an ecommerce business solely through the lens of aggregate sales can obscure critical operational realities. While the storefront may be generating substantial revenue overall, the underlying product catalog is rarely performing equally.
The essential business question that merchandising and operations teams must continuously answer is: “Which products are actually driving revenue and profit, which products are underperforming, why are they performing that way, and what should the business do about them?”
Answering these questions requires ecommerce product analytics. By systematically connecting sales, product, customer, and inventory data, businesses can move beyond basic revenue reporting. This capability allows teams to segment their catalog, diagnose the root causes of SKU-level performance, and make precise, data-driven decisions regarding pricing, promotions, inventory replenishment, and overall assortment strategy.
What Is Ecommerce Product Analytics?
In practical business terms, ecommerce product analytics is the systematic evaluation of how individual items within a catalog perform across various commercial dimensions.
Rather than looking at total store revenue, product analytics requires businesses to examine product-level data to deeply understand:
- Sales and Revenue: The raw financial output of the item.
- Volume: The total units moved, independent of the price point.
- Margin: The actual profitability of the product after costs.
- Customer Demand: The velocity and consistency at which the market requests the item.
- Product Trends: Whether an item's popularity is growing, plateauing, or decaying.
- Returns and Discounts: The negative economic factors that erode the product's gross profit.
- Inventory Context: How the sales velocity compares to the stock sitting in the warehouse.
Looking only at total revenue can hide significant product-level problems. A store generating $100,000 a month might look healthy. But product analytics might reveal that 40% of the catalog is completely stagnant, tying up working capital in dead stock, while a single hero product is heavily discounted and generating high revenue but zero net margin. Without granular product analytics, the business is flying blind.
Why Product Performance Analytics Matters for Ecommerce Businesses
The implementation of a robust product analytics framework is essential for scaling an ecommerce operation efficiently. It shifts the business from reactive guessing to proactive management.
Systematically analyzing product performance can help support several critical business functions:
- Identifying Winning Products: Discovering which items not only generate high revenue but also yield strong margins and attract loyal repeat customers.
- Finding Underperforming Products: Flagging SKUs that are tying up capital, incurring storage fees, or suffering from high return rates.
- Understanding Product and Category Trends: Recognizing macro shifts in consumer preference to capitalize on growing categories before competitors do.
- Improving Product Assortment: Deciding objectively which product lines to expand, which colors to drop, and which sizes to over-index on.
- Supporting Merchandising Decisions: Determining which products deserve premium placement on the homepage or within marketing emails.
- Improving Pricing and Promotion Decisions: Understanding the price elasticity of a product to avoid unnecessary margin erosion during sale periods.
- Managing Inventory More Effectively: Connecting sales velocity to inventory levels to prevent expensive stockouts on winners and costly overstock on losers.
- Understanding Product Profitability: Ultimately, ensuring that the catalog functions as a profitable engine rather than just a revenue generator.
While analytics alone does not automatically improve profitability, it provides the undeniable evidence required for operators to make the structural changes that do.
Which Product Performance Metrics Should Ecommerce Businesses Track?
To execute effective product performance analysis, a business must track a specific set of granular metrics for every single SKU. Each metric tells a different part of the product's story.
Revenue
Revenue is the total dollar amount generated by the product. While it indicates the sheer scale of the product's impact, its limitation is severe: revenue ignores costs. A product with massive revenue but equally massive production and shipping costs may contribute nothing to the bottom line.
Units Sold
Tracking the sheer volume of units moved is useful for understanding pure product demand independent of price. If revenue drops but units sold remain constant, it immediately signals that discounting or pricing changes are the culprit, not a lack of customer interest.
Average Selling Price (ASP)
The actual average price customers paid for the item over a specific period. ASP is crucial for understanding pricing dynamics and the true effect of discounts. If a product's MSRP is $100 but its ASP is $65, the business is highly dependent on promotions to move that inventory.
Gross Margin / Contribution Margin
This is arguably the most important metric. Margin calculates the revenue minus the Cost of Goods Sold (COGS) and, ideally, direct fulfillment costs. It explains the actual profitability of the SKU.
Conversion Rate
Where reliable product-level traffic data exists (e.g., product page views), tracking the conversion rate reveals how effectively the product page turns browsers into buyers. A product with high traffic but low conversion rate may suffer from poor imagery, bad reviews, or uncompetitive pricing.
Return Rate
Returns can materially change the economics of a product. A dress might have excellent revenue and strong initial margins, but if 40% of the units are returned due to a sizing defect, the reverse logistics costs will destroy the product's profitability.
Discount Rate
The percentage of sales that required a discount code to convert. Tracking this helps businesses understand the relationship between promotions and product performance, highlighting items that cannot sell at full price.
Inventory Turnover
Where inventory data is available, turnover measures how efficiently a product cycles through the warehouse. High turnover indicates efficient capital usage, while low turnover highlights trapped cash.
Repeat Purchase / Customer Association
Does buying this product lead to a second purchase? Understanding whether products are associated with high ecommerce customer lifetime value (CLV) helps businesses identify which items should be used as "acquisition products" in top-of-funnel advertising.
Revenue vs Profit: Why the Best-Selling Product May Not Be the Best Product
One of the most dangerous assumptions in ecommerce is equating high revenue with high business value. To illustrate why businesses should evaluate products across multiple dimensions rather than ranking purely by revenue, consider this classic scenario:
Product A (The Revenue Leader):
- Generates $50,000 in monthly revenue.
- Highly dependent on 30% off discounts to sell.
- Suffers a 25% return rate due to sizing issues.
- Yields a net margin of 5%.
- Result: Generates only $2,500 in actual profit and creates massive customer service overhead.
Product B (The Profit Engine):
- Generates $20,000 in monthly revenue.
- Sells consistently at full price (0% discount rate).
- Enjoys a negligible 2% return rate.
- Strongly associated with returning customers.
- Yields a net margin of 40%.
- Result: Generates $8,000 in actual profit while building a loyal customer base.
If the merchandising team only sorts the dashboard by "Total Revenue," they will dedicate premium website placement and marketing budget to Product A. A robust product analytics framework exposes the reality, allowing the business to strategically pivot resources to Product B.
How to Identify Winning Products
A "winning" product is rarely defined by a single metric. Furthermore, winning depends heavily on the specific business objective at the time (e.g., market share growth vs. cash flow generation).
Generally, identifying winning products involves looking for items that exhibit a combination of the following characteristics:
- Strong and Consistent Sales: Steady velocity that doesn't rely entirely on flash sales.
- Healthy Margins: Providing sufficient gross profit to comfortably cover marketing and overhead.
- Low Return Rates: Indicating high customer satisfaction and product quality.
- Strong Conversion: Efficiently turning paid traffic into revenue.
- Repeat Purchases: Acting as a gateway product that creates brand loyalty.
- Positive Trend: Sales volume that is naturally growing month-over-month.
- Good Inventory Velocity: Moving through the warehouse quickly without tying up capital.
A high-margin niche accessory may be a "winner" because it quietly generates reliable cash flow with zero marketing spend, even if its total sales volume is relatively low.
How to Identify Underperforming Products
Conversely, underperforming products are not just items with low sales. An item that was intentionally purchased in small quantities to serve a tiny niche is not necessarily underperforming just because its revenue is low.
Underperformance must be identified through specific negative signals:
- Declining Sales: A clear, continuous drop in velocity over several months.
- Low Conversion: High traffic but terrible sales.
- Excess Inventory: Weeks of supply that stretch into the hundreds, trapping working capital.
- High Return Rates: A direct indicator of a quality, sizing, or description issue.
- Heavy Discount Dependence: Products that literally will not move unless marked down by 40%.
- Weak Margins: High COGS or high shipping weights destroying profitability.
Crucially, underperformance should be diagnosed rather than simply assumed. If a product shows weak sales, analytics should be used to find the root cause. The weak sales may be caused by poor pricing, lack of homepage visibility, frequent out-of-stock periods, wrong seasonality, or poor product positioning, rather than a fundamental lack of customer demand.
SKU Performance Analysis and Product Segmentation
Once a business has access to SKU-level metrics, the next step is product segmentation. Grouping products allows operations and merchandising teams to apply systematic strategies rather than making decisions on a whim.
ABC Analysis
This is a classic revenue or value-based segmentation based on the Pareto principle (the 80/20 rule).
- A-Products: The top 20% of SKUs that generate 80% of the revenue. These require absolute inventory protection and premium marketing.
- B-Products: The middle tier of solid, reliable performers.
- C-Products: The bottom tail of the catalog that generates very little revenue but often consumes a disproportionate amount of warehouse space.
XYZ Analysis
Often paired with ABC, XYZ segments products by demand variability.
- X-Products: Highly consistent, predictable demand.
- Y-Products: Fluctuating demand, often due to seasonality.
- Z-Products: Highly erratic, unpredictable demand.
Revenue-Margin Segmentation
This quadrant approach is incredibly useful for direct commercial decisions:
- High Revenue / High Margin: The core heroes. Protect stock and scale ad spend.
- High Revenue / Low Margin: The traffic drivers. Attempt to increase price, reduce COGS, or bundle them with high-margin accessories.
- Low Revenue / High Margin: The hidden gems. Increase marketing visibility to see if volume can scale.
- Low Revenue / Low Margin: The dead weight. Liquidate and discontinue.
Product Lifecycle Segmentation
Products behave differently depending on their maturity.
- New Products: Need high visibility and rapid performance evaluation.
- Growth Products: Need aggressive inventory scaling to capture momentum.
- Mature Products: Need margin optimization and consistent replenishment.
- Declining Products: Need markdown strategies and graceful discontinuation.
These frameworks are not universally mandatory. Segmentation should always match the specific business decision being made.
Product Performance by Category, Channel, and Customer Segment
Aggregate SKU performance can still be deceptive if not analyzed across different commercial dimensions. A product's success is highly contextual.
- By Customer Segment: A heavy winter jacket might look like an average performer overall, but when segmented, it may be the absolute top-selling product for returning VIP customers.
- By Acquisition Channel: A quirky, low-priced accessory might perform terribly via organic search but convert explosively when featured in a TikTok ad campaign.
- By Sales Channel: A product might be a top seller on the Shopify storefront but see massive return rates when sold through a marketplace like Amazon.
Analyzing product performance across these dimensions prevents businesses from accidentally killing a product that is highly valuable to a specific, profitable niche.
How Promotions and Discounts Affect Product Performance
Promotions are the most common lever pulled by ecommerce managers to stimulate sales, but they heavily distort product performance data. Product analytics must decouple the discount from the demand.
When evaluating discounted products, operators must analyze:
- Discount Dependency: Can this product ever sell at full MSRP?
- Margin Erosion: Did the 20% discount completely wipe out the net margin for the month?
- Cannibalization: Did the promotion on Product A simply steal sales that would have organically gone to full-priced Product B?
- Incremental Sales vs. Shifted Sales: Did the Black Friday sale actually generate new revenue, or did it just convince your loyal customers to buy in November instead of December?
"Sales increased during the promotion" does not necessarily mean the promotion was profitable. Product analytics provides the historical context (before, during, and after the promotion) to evaluate true promotional lift.
Product Performance and Inventory Decisions
Product analytics and inventory management are intrinsically linked. You cannot make a good inventory decision without understanding how the product is performing.
Product performance insights can help businesses identify:
- Fast-Moving Products: Requiring expedited freight and larger purchase orders to prevent stockouts.
- Slow-Moving Products: Requiring marketing interventions or immediate liquidation to free up warehouse space.
- Products with Recurring Stockouts: Items where the total revenue metric is artificially low simply because it was never in stock to be purchased.
It is vital to distinguish between product analytics and demand forecasting. Product Performance Analytics asks: "How is the product performing right now, and why?" It evaluates the current reality based on historical and present data. Demand Forecasting asks: "What is likely to happen next?" It uses that historical performance data to mathematically predict future velocity.
While they are complementary, they are not interchangeable. For a deeper dive into predicting future sales, see our guide on ecommerce demand forecasting.
How Product Performance Analytics Supports Merchandising Decisions
Merchandising is the art of presenting the right products to the customer. Product analytics provides the mathematical evidence required to make these decisions objectively.
Practical applications include:
- Assortment Planning: Deciding objectively which product variants (colors/sizes) to expand and which to discontinue based on historical margin and velocity.
- Product Placement: Ensuring the highest-converting, highest-margin products receive the prime digital real estate above the fold on the homepage.
- Bundling: Identifying which products are frequently bought together (often requiring ecommerce recommendation engines) to create compelling, high-AOV bundles.
- Pricing Strategy: A/B testing price points and monitoring the resulting changes in volume and margin to find the optimal equilibrium.
Analytics provides the evidence for these decisions; the merchandising team provides the creative execution.
How Data Science Can Improve Product Performance Analysis
For mature D2C brands with massive catalogs, manual spreadsheet analysis eventually breaks down. This is where data science extends traditional reporting.
Advanced data science can provide significant business value by automating complex analyses:
- Product Demand Pattern Detection: Automatically categorizing thousands of SKUs into smooth, erratic, or lumpy demand patterns.
- Anomaly Detection: Instantly alerting the operations team if a high-performing product's conversion rate suddenly drops by 40% on a Tuesday.
- Product Clustering: Using machine learning to automatically group products that behave identically, allowing for bulk merchandising decisions.
- Customer-Product Affinity: Mathematically mapping the relationships between specific customer cohorts and specific product categories.
Advanced models should be deployed strictly where they provide tangible business value. A brand with 10 SKUs does not need machine learning for product analytics; a brand with 10,000 SKUs absolutely does.
How Shopify and Ecommerce Data Can Power Product Analytics
As discussed in our broader overview of Shopify analytics, the native ecommerce platform is the primary system of record. It provides the foundational data points required for product analysis: orders, exact product variants, customer IDs, discount codes applied, and refunds processed.
However, to achieve a complete picture of product performance, Shopify data is rarely sufficient on its own. Advanced operators extract this native data and combine it with external sources:
- ERP Systems: For exact, landed Cost of Goods Sold (COGS) to calculate true SKU margin.
- 3PL / Warehouse Systems: For real-time stock levels and granular fulfillment costs.
- Google Analytics / Meta Ads: To understand product-level traffic, bounce rates, and the specific ad spend driving that product's sales.
Combining these sources into a unified data warehouse provides a complete, 360-degree view of product profitability.
How Cantar Analytics Helps Ecommerce & D2C Businesses
At Cantar Analytics, we help ecommerce brands transition from high-level revenue reporting to granular, actionable product intelligence. We understand that sustainable growth requires knowing exactly which SKUs are driving profit and which are silently eroding margins.
Our expertise spans the full spectrum of supply chain analytics and data engineering. We partner with merchandising, operations, and growth leaders to build custom analytics dashboards that answer your specific business questions. By integrating your Shopify transaction data with ERP cost data, 3PL inventory feeds, and marketing spend, we create unified systems designed for SKU performance analysis and product profitability tracking.
Whether you need a dynamic ABC segmentation model, an automated anomaly detection system for product conversion rates, or a comprehensive profitability dashboard, Cantar Analytics builds the infrastructure to support confident, data-driven assortment and merchandising decisions.
When Should an Ecommerce Business Invest in Product Analytics?
Moving beyond basic Shopify reporting to a dedicated product analytics infrastructure is a natural evolution for scaling brands. Businesses should look for practical operational signals indicating it is time to invest:
- Growing SKU Count: When the catalog expands beyond what can be easily tracked in a single spreadsheet.
- Inventory Complexity: When the business begins experiencing simultaneous stockouts on winners and severe overstock on losers.
- Increasing Discounting: When the marketing team is running frequent promotions, but the finance team cannot determine if those promotions are actually profitable at the SKU level.
- Manual Reporting Friction: When operations managers spend hours every Monday downloading CSVs just to understand what sold over the weekend.
- Margin Compression: When total revenue is hitting record highs, but bottom-line cash flow is shrinking, demanding a rigorous investigation into SKU-level unit economics.
Smaller businesses can often start with simple reporting rules, but as complexity compounds, an automated product analytics system becomes a mandatory operational requirement.
Frequently Asked Questions
What is ecommerce product analytics?
Ecommerce product analytics is the practice of evaluating individual products within a catalog across multiple dimensions—such as sales volume, revenue, gross margin, conversion rate, and return rate—to understand their true commercial performance.
What is product performance analytics?
It is a subset of analytics focused entirely on diagnosing how a specific item or category is performing, and more importantly, why it is performing that way. It moves beyond aggregate store revenue to isolate the health of individual SKUs.
How do you measure product performance in ecommerce?
Performance is measured by combining financial metrics (revenue, margin, ASP) with behavioral metrics (conversion rate, page views) and operational metrics (return rate, inventory turnover) to evaluate a product holistically.
What metrics should ecommerce businesses track for each product?
At a minimum, businesses should track Units Sold, Gross Margin, Return Rate, Discount Rate, and Conversion Rate. These metrics provide a clear picture of both demand and profitability.
How do you identify underperforming products?
Underperforming products are identified through specific signals such as declining sales velocity, high return rates, heavy dependence on discounts to convert, or high inventory days-on-hand.
What is SKU performance analysis?
SKU (Stock Keeping Unit) performance analysis is the most granular level of product analytics. It evaluates performance down to the exact variant level (e.g., evaluating the "Medium Blue Shirt" independently from the "Large Red Shirt") to make precise inventory and merchandising decisions.
What is the difference between product analytics and demand forecasting?
Product analytics evaluates historical and present data to explain how a product is currently performing. Demand forecasting uses that data to predict what will likely happen in the future (e.g., how many units will sell next month).
Can Shopify data be used for product analytics?
Yes, Shopify provides the core transactional foundation for product analytics. However, to calculate true profitability, Shopify data is typically combined with cost data from an ERP and traffic data from Google Analytics.
How can product analytics improve merchandising?
By providing objective data, product analytics allows merchandising teams to confidently decide which products to feature on the homepage, which items to bundle together, and which variants should be discontinued, eliminating guesswork from assortment planning.
How can product profitability be analyzed?
Product profitability is analyzed by subtracting all direct variable costs (COGS, freight, pick/pack fees, shipping, and transaction fees) from the actual average selling price (post-discount) of the item. This yields the true contribution margin of the product.