Category Performance Diagnostic & Optimization
Analyze category performance data and generate ROI-backed improvement strategies
What You Can Do
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
Features
Apply a proven 5-step analysis model (baseline assessment, driver identification, competitive benchmarking, gap quantification, opportunity prioritization) to any category dataset
Identify whether underperformance stems from assortment gaps, pricing misalignment, promotional inefficiency, market share loss, or seasonal anomalies
Compare your category metrics against peer categories, retail standards, and identified competitors to pinpoint strategic vulnerabilities
Quantify revenue impact, margin improvement, and payback period for each recommended initiative with sensitivity analysis
Rank improvement opportunities by effort, timeline, and financial impact so your teams execute highest-value initiatives first
Produce polished performance dashboards and one-pagers with key findings, insights, and strategic recommendations for leadership presentations
Develop justification for category investment, assortment resets, pricing changes, or staffing with quantified impact scenarios
Diagnose unexpected sales fluctuations, trend breaks, or cyclical performance patterns to improve forecasting accuracy
Example Output
Example 1: Quarterly Category Review
Input: Q3 sales data, margin trends, and competitive pricing for a Home & Garden category Output:
- Baseline Performance: 8% below plan, margin compression of 120bps
- Root Causes Identified: 35% assortment gap vs. competitor (missing 12 SKUs), promotional elasticity declining 15%, price premium eroding
- Top 3 Opportunities: (1) Add seasonal outdoor living bundle (+$240K revenue, 6-week implementation), (2) Adjust promotional cadence to higher-velocity weeks (+$85K margin, immediate), (3) Price reoptimization on core SKUs (+$120K margin, 2-week testing)
- Projected Impact: +$445K revenue, +$205K margin improvement in Q4
Example 2: Competitive Threat Analysis
Input: Market share loss data, competitor assortment, and customer feedback Output:
- Gap Analysis: Competitor X gained 3.2 share points; your category missing 8 high-velocity SKUs they carry
- Opportunity Quantification: Adding competitor's top-5 SKUs could recover 1.8 share points (+$380K revenue annually)
- Risk Assessment: If you don't act within 8 weeks, projected share loss reaches 5% (−$625K revenue)
- Recommended Action Plan: 4-week SKU onboarding, promotional support ($45K investment), landing page optimization
Example 3: Seasonal Anomaly Investigation
Input: Monthly sales trend data showing unexpected July dip Output:
- Anomaly Root Cause: Competitor ran aggressive flash sale (−28% traffic week-of), your promo was under-merchandised, supply constraint on #2 SKU
- Corrective Insights: Traffic issue recoverable; inventory issue resolved by August; promo visibility improvement = +$62K recovery potential
- Forward Forecast Adjustment: Updated Q3 projection with mitigation factors; Q4 seasonal modeling adjusted based on learned elasticity
What's Included
- SKILL.md: Complete diagnostic framework with 5-step methodology and implementation checklist
- Category Diagnostic Template: Structured data intake format for sales metrics, competitive data, and market context
- Root Cause Analysis Checklist: Guided framework for identifying performance drivers across assortment, pricing, promotion, market, and operational levers
- ROI Projection Worksheet: Template for modeling revenue/margin impact, payback periods, and sensitivity scenarios for each recommendation
- Executive Summary Template: One-pager format with key findings, gap analysis, top 3 recommendations, and projected P&L impact
Who It's For
- Category Managers — Conducting quarterly/annual reviews and building data-driven improvement roadmaps
- Merchandising Directors — Analyzing category-wide performance and strategic portfolio optimization
- Retail Operations Managers — Investigating performance anomalies and diagnosing underperforming categories
- Category Strategy Teams — Building business cases and executive presentations for category investment or resets
- Finance/Planning Analysts — Supporting category teams with ROI validation and financial impact modeling
Best For
- Quarterly/annual category performance reviews — Comprehensive diagnostic analysis with improvement roadmaps
- Underperformance investigation — Root cause analysis when categories miss plan or targets
- Competitive threat response — Gap mapping and recovery strategy development
- Category reset planning — Assortment, pricing, and promotional optimization for major category initiatives
- Business case development — ROI-backed justification for category investment, staffing, or technology
You might also like
You can systematically analyze vendor quotes by deconstructing cost structures, identifying hidden costs and margin compression points, and modeling multiple pricing scenarios. The skill enables you to forecast margin impact across volume tiers, develop proactive negotiation strategies grounded in vendor financials, and build data-backed proposals that improve both your margins and vendor sustainability—transforming reactive price-pushing into strategic partnership analysis.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level targets.
by cowork-os
You can rapidly assess current planogram performance against sales data, identify underperforming SKUs and space inefficiencies, and generate detailed shelf layout recommendations that balance profitability, velocity, and compliance. Claude processes your category mix, fixture dimensions, regulatory constraints, and competitive positioning to produce actionable planograms ready for retail operations review and store execution.
by cowork-os
Transform raw sales data into strategic insights by decomposing performance variance into specific drivers, benchmarking category health against targets, and quantifying the financial impact of merchandising decisions. You'll uncover hidden patterns in customer behavior, identify performance bottlenecks, and build executive-ready business cases backed by rigorous data analysis—moving beyond dashboards to actionable strategy.
by cowork-os
You develop strategic visual merchandising plans that integrate business objectives, customer behavior analysis, and brand guidelines into actionable retail presentations. This skill guides you through spatial psychology, color theory, product hierarchy, and sales velocity analysis to create zone-specific placement strategies, seasonal displays, and fixture specifications that drive conversion and average transaction value. You'll analyze competitor approaches, align visual hierarchy with margin targets, and build frameworks for multi-location consistency.
by cowork-os
This skill transforms raw sales, inventory, and market data into actionable assortment insights. You'll rank SKUs by velocity, margin, and trend trajectory to identify underperformers worth pruning. Discover whitespace gaps—missing size/color/price tier combinations that competitors stock but you don't. Model the financial impact of proposed assortment changes, projecting revenue and margin shifts before implementation.
by cowork-os
You can systematically analyze vendor performance data across multiple KPIs (sales, turn rate, on-time delivery, quality, margin contribution), identify root causes of underperformance, benchmark vendors against category standards, and develop specific improvement plans with calculated financial impact. This skill translates raw vendor metrics into compelling business cases for vendor investments, contract negotiations, or corrective actions, replacing intuition-based feedback with data-driven strategic conversations.
by cowork-os
You can convert raw pricing data into defensible, actionable price recommendations by analyzing competitor behavior, demand elasticity, inventory health, and seasonal factors simultaneously. This skill helps you balance revenue maximization against competitive positioning and inventory velocity, enabling you to prioritize which SKUs to adjust first and justify price changes to stakeholders with quantitative rationale.
by cowork-os