Shopify Metric
Product
Variant Revenue Share = Variant Net Revenue / Parent Product Net Revenue x 100; Variant Sell-Through = Variant Units Sold / (Variant Units Sold + Variant Units On Hand) x 100
Variant Performance Analysis measures how each Shopify product variant, defined by options such as size, colour, or material, contributes to sales relative to its siblings and to the catalogue as a whole. In Shopify, every variant carries its own SKU, price, inventory level, and order line items, so the data lets you rank variants by revenue, units sold, and sell-through rather than judging a product only at the parent level. It surfaces which specific options carry a product and which sit dormant tying up stock.
Full guide: definition, formula, and benchmarksShopifyProductVariant Performance Analysis
Variant Performance Analysis measures how each Shopify product variant, defined by options such as size, colour, or material, contributes to sales relative to its siblings and to the catalogue as a whole. In Shopify, every variant carries its own SKU, price, inventory level, and order line items, so the data lets you rank variants by revenue, units sold, and sell-through rather than judging a product only at the parent level. It surfaces which specific options carry a product and which sit dormant tying up stock.
How to calculate variant performance analysis
Why variant performance analysis matters for Shopify users
Two products with identical total sales can hide very different stories at the variant level. One might sell evenly across every size while another leans entirely on a single colour, and only variant-level analysis tells you which. That distinction drives smarter reorder quantities, sharper merchandising, and fewer markdowns on options nobody wants.
For a team running on Shopify, variant data is where working capital is won or lost. Overstocking slow variants ties up cash and warehouse space, while stocking out of a hero variant pushes shoppers straight to a competitor. Watching variant performance keeps the catalogue lean and the bestsellers in stock.
Understand and act on variant performance analysis with KPI Tree
Sync your Shopify orders, line items, products, variants, and inventory levels into your warehouse, then compute Variant Performance Analysis in KPI Tree by aggregating net revenue and units per variant SKU and comparing each against its parent product and stock on hand. Place it in a metric tree beneath product and revenue metrics so you can see how variant mix rolls up into [average order value](/glossary/sales/average-order-value) and overall sell-through.
Assign RACI ownership to merchandising or buying so one role is accountable for acting on weak and hero variants, with inventory and marketing consulted. Set a weekly review cadence during peak trading and monthly otherwise, and let KPI Tree flag variants that breach sell-through or revenue-share thresholds for reorder or retirement.
Get started with your Shopify data
MCPPull metrics from Shopify directly through the Model Context Protocol.
Connect your existing warehouse where Shopify data already lands.
Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.
Related Shopify metrics
Average Order Value
E-commerceMetric Definition
AOV = Total Revenue / Number of Orders
Average order value (AOV) is the mean monetary value of each completed order. It captures the combined effect of pricing, bundling, upselling, and promotional strategies on basket size.
Collection Performance Analysis
E-commerceMetric Definition
Collection performance analysis evaluates each Shopify collection on revenue contribution, conversion rate, average order value, and traffic volume. It reveals which product groupings resonate with customers and which underperform.
Cart Conversion Rate
E-commerceMetric Definition
Cart Conversion Rate = (Completed Orders / Sessions with Add-to-Cart) × 100
Cart conversion rate is the percentage of visitors who add items to their cart and subsequently complete a purchase. It isolates the effectiveness of the post-browse, pre-checkout stage of the buying journey.
Average Product Rating
E-commerceMetric Definition
Average Product Rating = Sum of All Ratings / Number of Reviews
Average product rating is the mean star rating across all customer reviews for a given product or your entire catalogue. It serves as a proxy for customer satisfaction and product quality perception.
Explore variant performance analysis across integrations
All Shopify metrics
Average Order ValueCart Abandonment RateCheckout Conversion RateCustomer Acquisition CostCustomer Lifetime ValueCustomer Repeat RateDiscount Usage AnalysisFulfilment SpeedGross Merchandise VolumeInventory TurnoverMarketing Channel AttributionNew vs Returning CustomersOrder FrequencyOrders Per CustomerProduct Performance AnalysisProduct Return RateProfit Margin by ProductRevenue by ChannelRevenue by GeographyRevenue Per VisitorSessions to Purchase RatioShipping Cost AnalysisStore Conversion RateTop Selling Products AnalysisTraffic Source PerformanceAbandoned Cart Recovery RateAverage Product RatingCart Conversion RateCheckout Abandonment RateCollection Performance AnalysisCustomer Cohort AnalysisCustomer Segmentation AnalysisPayment Method DistributionRevenue Growth RateSeasonal Trend AnalysisCohort AnalysisConversion RateCross Sell AnalysisCustomer Churn RateDiscount EffectivenessDraft Order Conversion RateFulfillment Time AnalysisGift Card Utilization RateInventory Turnover RateLocation Based Sales AnalysisPurchase Funnel AnalysisRefund RateRepeat Purchase RateRevenue Per CustomerRFM SegmentationStock Out FrequencyTransaction Success RateEmpower your team to understand and act on Shopify data
Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.
