Category Performance Analysis & Optimization
Analyze category sales performance and generate actionable merchandising insights
What You Can Do
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.
Features
isolate which factors (price, assortment, promotion, seasonality) drive sales changes
compare category health against targets, peer categories, and industry standards
calculate ROI and financial impact of pricing, promotion, and assortment changes
surface leading indicators of performance decline and vulnerability factors
build executive-ready summaries connecting data insights to strategic recommendations
forecast demand cycles and optimize inventory/promotion timing
validate assumptions about price sensitivity and product mix preferences
measure impact of supplier changes on category results
Example Output
Example 1: Variance Decomposition Category down 8% YoY. Analysis reveals: Assortment gaps (-4.2%), competitive price pressure (-2.8%), reduced promotional support (-1.1%), seasonal shift (+0.1%). Recommendation: Expand hero SKU selection and pilot targeted price reductions on key competitors' items.
Example 2: Merchandising Impact Case Proposed 15% expansion of premium tier assortment. Analysis projects: +$2.3M revenue (12% uplift), +180 bps margin improvement, +8% basket size increase. Risk: 2-week inventory lead time. ROI: 340% over 12 months.
Example 3: Seasonal Opportunity Q4 analysis shows peak demand window compressed by 3 weeks vs. prior year. Identified $890K revenue gap from delayed promotional timing. Recommendation: Shift promotional calendar forward 2 weeks and increase depth during identified peak window.
What's Included
- SKILL.md instruction file with analysis framework and best practices:
- Data collection template: standardized metrics and dimensions for category performance analysis
- Variance decomposition framework: systematic approach to isolating performance drivers
- Executive summary template: structure for translating analysis into board-ready narratives
- Benchmarking checklist: KPIs and peer comparison methodology for category health assessment
Who It's For
- Category managers — optimize assortment, pricing, and promotion strategies based on rigorous analysis
- Merchandising directors — identify cross-category trends and inform buying committees
- Retail analysts — support category leadership with deep-dive performance diagnostics
- Business strategists — build financial cases for category investments and restructuring
- Buying team leaders — quantify vendor and supplier impact on category results
Best For
- Monthly/quarterly performance reviews — synthesize sales data into actionable insights
- Variance investigation — diagnose root causes of sales declines or growth shortfalls
- Merchandising ROI analysis — quantify impact of pricing, promotion, and assortment changes
- Business case development — build data-backed proposals for category investments
- Seasonal planning — identify demand patterns and optimize promotional calendars
- Competitive benchmarking — compare category health against peer performance and industry standards
You might also like
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
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
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 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.
by cowork-os