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 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 upload sales velocity, margin, inventory, and competitive data to receive structured assortment analysis grounded in category management principles. The skill identifies low-performing SKUs for elimination, unmet customer demand (white space), and right-sizing opportunities—then delivers actionable recommendations with financial impact projections to justify decisions to leadership.
by cowork-os
You can strategically analyze store layouts and visual displays to identify optimization opportunities that drive unplanned purchases and improve customer navigation. This skill helps you create cohesive visual narratives aligned with brand guidelines, develop seasonal and campaign-driven display concepts, and audit existing installations against performance benchmarks to maximize conversion rates and basket size.
by cowork-os
You can upload sales data, margin metrics, and customer behavior patterns to uncover hidden performance trends across your product portfolio. Claude analyzes sales velocity, margin contribution, and customer engagement to surface optimization opportunities—identifying which SKUs to promote, bundle, or rationalize. The skill generates actionable category strategies, reorder rate analysis, and competitive positioning recommendations tailored to your digital channels and seasonal opportunities.
by cowork-os
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 quantify how customer segments respond to different discount depths and promotional timing by analyzing historical sales data. This skill helps you forecast demand under various discount scenarios, identify which product categories or customer groups are price-elastic versus price-inelastic, and recommend optimal promotional calendars that balance revenue maximization with efficient inventory clearance without training customers to expect constant discounts.
by cowork-os
You can systematically analyze competitor pricing strategies across product categories, quantify price-demand elasticity relationships, and identify market positioning gaps. This skill helps you build defensible pricing recommendations backed by competitive data, assess margin implications, and create scenario analyses for executive decision-making—moving beyond reactive price matching to strategic positioning.
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