Category Performance Diagnosis

Overview

Category Performance Diagnosis provides a structured, root-cause-driven analysis of why a product category is performing the way it is. Rather than simply reporting metrics, this skill decomposes performance into its component drivers—traffic, conversion, basket, price, mix, distribution—and isolates the factors most responsible for observed changes. The output is an actionable diagnostic narrative with prioritized levers for improvement.

This methodology mirrors how leading CPG companies (P&G, Unilever, PepsiCo) conduct category reviews with retail partners, combining the rigor of a consulting-style decomposition with the specificity of CPG domain expertise.

When to Use

Quarterly or annual category business review preparation
A category shows unexpected decline or acceleration and the user asks "why"
Cross-category portfolio prioritization requiring standardized health assessments
Retailer-supplier joint business planning sessions
Post-event analysis (e.g., after a major promotion, competitor launch, or assortment reset)
User provides category sales data and asks for a performance diagnosis

Required Inputs

| Input | Required | Description | |---|---|---| | Category sales data | Yes | Revenue, units, transactions — minimum 52 weeks, ideally 104 weeks for YoY | | Time granularity | Yes | Weekly or monthly data; weekly preferred for decomposition | | Product hierarchy | Yes | Category > subcategory > brand > SKU with attributes | | Traffic/visit data | Recommended | Store visits, site sessions, category page views | | Basket/transaction data | Recommended | Items per basket, basket size, attach rates | | Pricing data | Recommended | Regular and promoted prices, price indices | | Distribution data | Recommended | Store count, %ACV, online availability rate | | Market/syndicated data | Optional | Nielsen/Circana total market data for share context | | Competitor data | Optional | Competitor pricing, promotions, launches |

Methodology

Step 1: Establish the Performance Fact Base

Calculate core category KPIs for current period vs. year-ago and vs. plan/budget:

| Metric | Current | YoY Change | vs. Plan | |---|---|---|---| | Revenue | — | — | — | | Units | — | — | — | | Transactions | — | — | — | | Average Selling Price (ASP) | — | — | — | | Units per Transaction (UPT) | — | — | — | | Revenue per Transaction (RPT) | — | — | — | | Gross Margin % | — | — | — | | Gross Margin $ | — | — | — |

Step 2: Revenue Growth Decomposition

Decompose total revenue change into additive components using the standard retail growth bridge:

ΔRevenue = ΔTraffic Effect + ΔConversion Effect + ΔBasket Effect + ΔPrice/Mix Effect

Traffic Effect: Change in total visits/sessions × prior-period conversion × prior-period RPT Conversion Effect: Prior traffic × change in conversion × prior-period RPT Basket Effect: Prior traffic × current conversion × change in items/basket × prior ASP Price/Mix Effect: Prior traffic × current conversion × current items/basket × change in ASP

For each component, express as:

Absolute dollar contribution to the total change
Percentage of total change explained
Trend direction (improving, stable, deteriorating)

Step 3: Price/Mix Disaggregation

Further decompose the Price/Mix effect:

ΔPrice/Mix = Pure Price Effect + Trade-Up/Down Mix Effect + Size Mix Effect + Channel Mix Effect

Pure Price Effect: Same-SKU price changes (regular price increases, cost-driven)
Trade-Up/Down Mix: Shift in revenue share between premium, mid, and value tiers
Size Mix: Shift between single-serve, standard, and bulk sizes
Channel Mix: Shift between online, in-store, marketplace (different ASP profiles)

Step 4: Subcategory and Brand Waterfall

Identify which subcategories and brands are driving the overall category trend:

Rank subcategories by absolute contribution to category ΔRevenue
For the top 3 growth and top 3 decline contributors, repeat the growth decomposition (Step 2)
Identify share-shifting dynamics: which brands are gaining at whose expense
Calculate Growth Contribution Index: (Brand's contribution to category growth / Brand's revenue share). Values > 1.0 indicate disproportionate growth contribution.

Step 5: Identify Root Cause Hypotheses

Map decomposition findings to root causes using this diagnostic framework:

| Observed Signal | Likely Root Causes | Diagnostic Action | |---|---|---| | Traffic declining, conversion stable | Category relevance issue, reduced marketing, seasonal shift | Check media spend, category search volume trends | | Traffic stable, conversion declining | Assortment issues, price competitiveness, UX friction | Analyze search-to-cart rate, price index vs. competition | | Conversion up, basket declining | Promo-driven traffic (cherry-picking), stock issues | Check promo depth/frequency, OOS rates | | ASP declining, units flat | Trade-down, promo depth increase, channel mix shift | Analyze tier mix trends, promo analysis | | ASP rising, units declining | Price resistance, elasticity threshold crossed | Run price elasticity check, competitive price audit |

Step 6: Prioritize Improvement Levers

For each root cause identified, define an improvement lever and size the opportunity:

Lever Impact = Current Gap × Recovery Rate × Confidence Factor

Where:

Current Gap: Measured shortfall vs. benchmark, prior period, or plan
Recovery Rate: Realistic % of gap that can be recovered (typically 30–60%)
Confidence Factor: 0.5–1.0 based on data quality and certainty of root cause

Output Specification

1. Category Health Scorecard

One-page summary with traffic-light indicators (green/yellow/red) for:

Revenue trend, Unit trend, Margin trend
Traffic, Conversion, Basket size
Price competitiveness, Assortment coverage
Overall Category Health Rating (A/B/C/D)

2. Growth Decomposition Bridge

Waterfall chart (or table) showing additive contribution of each growth driver to total ΔRevenue.

3. Root Cause Narrative

Structured narrative (3–5 paragraphs) explaining: What happened → Why it happened → What matters most → What to do about it.

4. Subcategory/Brand Contribution Matrix

Table showing each subcategory's contribution to category growth with Growth Contribution Index.

5. Prioritized Action Plan

| Priority | Lever | Root Cause | Expected Impact | Timeline | Owner | |---|---|---|---|---|---| | 1 | — | — | — | — | — |

Analysis Framework

Key Performance Indicators

Revenue Growth Rate: Current vs. YoY, vs. market, vs. plan
Volume/Price Decomposition: % of growth from volume vs. price
Category Development Index (CDI): Category performance in a market vs. national average (index 100)
Brand Development Index (BDI): Brand performance in a market vs. national average
Share of Wallet: Category spend as % of total department or basket
Promotion Intensity: % of volume sold on promotion (healthy range: 25–40% for CPG)
Everyday Margin Rate: Gross margin excluding promotional markdowns
Inventory Turns: Annual COGS / average inventory (benchmark varies by category: 8–15 for center store, 20–50 for perishables)

Diagnostic Benchmarks

Healthy category grows at ≥ market rate ± 1pp
Conversion rate decline > 2pp warrants urgent investigation
If > 50% of growth comes from price, sustainability is at risk
Promo-driven volume exceeding 45% of total signals promotional dependency
Top brand gaining > 3pp share in 12 months signals competitive disruption

Examples

Input: "Our Beverages category did $48M last year, down 3.2% vs. prior year. We have weekly POS data for 52 weeks, 280 SKUs across carbonated, water, juice, energy, and tea subcategories. Help me understand what's driving the decline."

Output:

Health Scorecard: Overall grade C — Revenue declining, units declining faster (−5.1%), ASP up +2.0% masking volume weakness. Traffic yellow, conversion red.
Growth Bridge: Traffic (−$0.4M) + Conversion (−$1.1M) + Basket (−$0.3M) + Price/Mix (+$0.2M) = −$1.6M total decline
Root Cause: Conversion is the primary drag. Deep dive reveals: (a) Carbonated soft drinks lost 12% of units due to out-of-stocks on the #2 and #3 brands during a supplier disruption (Q2); (b) Juice subcategory declined $0.6M as consumers shifted to flavored water, which is under-assorted (only 8 SKUs vs. 22 at key competitor); (c) Energy subcategory grew +14% but doesn't offset core declines.
Action Plan: P1 — Fix CSD supply chain ($0.8M recovery). P2 — Expand flavored water assortment by 10 SKUs ($0.5M). P3 — Increase energy shelf space to match growth trajectory ($0.3M).

Guidelines

Always decompose before diagnosing — resist jumping to conclusions from headline numbers
Present the "so what" after every data point; diagnosis without interpretation is not useful
Distinguish between cyclical effects (weather, seasonality) and structural shifts (consumer behavior change)
Compare category performance to total market growth, not just prior period — a category growing 2% in a market growing 6% is underperforming
Account for calendar shifts (Easter timing, extra/fewer selling days) in YoY comparisons
If promotional volume is high, separate base volume trends from promoted volume trends
Flag data quality issues explicitly rather than drawing conclusions from unreliable inputs
Consider external macro factors: inflation, consumer confidence, demographic shifts
The diagnosis should tell a story, not just present numbers — lead with the narrative

Validation Checklist

[ ] Growth bridge components sum to total ΔRevenue (within rounding tolerance)
[ ] Both volume and value decompositions are presented
[ ] Year-over-year and vs.-plan comparisons are included
[ ] At least 3 subcategories are analyzed in detail
[ ] Root causes are supported by data, not assumptions
[ ] External/market context is referenced (market growth rate, share trends)
[ ] Recommendations are sized with estimated revenue impact
[ ] Promotional vs. base volume trends are separated
[ ] Seasonal and calendar effects are accounted for
[ ] The narrative answers "What happened? Why? What now?"