Category Performance Diagnosis

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

Methodology

Step 1: Establish the Performance Fact Base

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

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:

1. Rank subcategories by absolute contribution to category ΔRevenue
2. For the top 3 growth and top 3 decline contributors, repeat the growth decomposition (Step 2)
3. Identify share-shifting dynamics: which brands are gaining at whose expense
4. 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:

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

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:

1. Health Scorecard: Overall grade C — Revenue declining, units declining faster (−5.1%), ASP up +2.0% masking volume weakness. Traffic yellow, conversion red.
2. Growth Bridge: Traffic (−$0.4M) + Conversion (−$1.1M) + Basket (−$0.3M) + Price/Mix (+$0.2M) = −$1.6M total decline
3. 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.
4. 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?"