Retail Performance Analytics & Strategy Optimizer
Analyze retail sales data to optimize SKU performance and forecast revenue impact
What You Can Do
You can analyze store-level sales performance data to pinpoint which SKUs drive profitability versus volume, benchmark your brand against category standards and competitors, and predict revenue outcomes before implementing shelf resets. This skill helps you create data-backed presentations for retail partners, optimize product allocation across store formats, and make informed decisions on discontinuations, repositioning, and promotional timing.
Features
identifies top and underperforming products by revenue, margin, and velocity across store formats and geographies
compares your portfolio positioning, pricing, and shelf productivity against category standards and direct competitors
recommends planogram changes, adjacency placements, and space allocation to maximize retail productivity
models financial impact of assortment changes, promotional calendars, and seasonal resets with confidence intervals
identifies white space opportunities and category growth drivers based on competitive landscape and consumer trends
generates executive-ready analytics summaries and insights for QBRs and business reviews
calculates profitability impact of different pricing strategies and product mix scenarios
tailors recommendations for prestige counters, mass-market shelves, and specialty retailers with format-specific KPIs
Example Output
Example 1: SKU Performance Review
- Lipstick SKU #4521 (Matte Red): Volume #3 in category, but 18% below category margin average. Recommend repositioning or discontinuation within 90-day window.
- Serum SKU #2187: High margin (42%), low velocity. Suggest bundling with bestseller or limited edition positioning to drive trial.
Example 2: Shelf Reset Forecast Proposed reallocation: 20% increase in prestige skincare, 15% decrease in color cosmetics. Projected 12-month revenue impact: +$247K (+8.3% in skincare category, -2.1% in color). ROI: High confidence with 95% probability of positive outcome.
Example 3: Competitive Analysis Your foundation assortment (12 SKUs) vs. competitor average (18 SKUs). Gap identified: Lack of clean/green formulations. Market opportunity: Launch 2-3 SKUs in this segment to capture emerging consumer demand.
What's Included
- SKILL.md instruction file with full methodology for retail analytics:
- POS Data Analysis Template: structured framework for extracting and categorizing sales metrics
- SKU Performance Scorecard: weighted metrics for profitability, velocity, and strategic value assessment
- Competitive Benchmarking Worksheet: competitive positioning matrix and category performance standards
- Revenue Forecast Model: scenario planning tool for assortment changes with sensitivity analysis
- Retail Partner Presentation Framework: slide templates and key messaging for QBRs and business reviews
Who It's For
- Cosmetics Brand Managers — optimizing portfolio performance and retail partnerships
- Retail Strategy Directors — planning assortment, shelf allocation, and promotional calendars
- Commercial Finance Teams — supporting margin improvement and revenue forecasting initiatives
- Product Portfolio Managers — evaluating SKU viability and discontinuation decisions
- Key Account Managers — preparing data-backed recommendations for major retail partners (Sephora, Ulta, department stores)
Best For
- Quarterly business reviews (QBRs) and retail partner presentations
- SKU performance audits and discontinuation decisions
- Planogram resets and shelf redesign planning
- Seasonal assortment planning and holiday collection strategy
- Competitive threat response and market repositioning
- Post-launch performance reviews and revenue forecasting
- Margin improvement initiatives and promotional budget allocation
You might also like
You can rapidly develop comprehensive treatment plans that meet medical spa standards, including procedure sequencing, contraindication screening, downtime restrictions, and measurable outcome expectations. This skill generates customized pre/post-care instructions and regulatory-aligned documentation tailored to individual client needs and your clinic's specific environment, eliminating hours of manual protocol creation.
by asklokesh
You can evaluate new retail opportunities with segment-specific strategies, prepare for retailer negotiations with buyer teams armed with realistic velocity assumptions, and forecast sales impact before committing inventory. The skill helps you analyze underperforming doors, compare ROI of shelf space investment across channels, and build annual retail strategy with clear door mix targets and success metrics.
by asklokesh
You can transform cosmetic formulation development from trial-and-error into a systematic, science-backed process. This skill helps you evaluate ingredient synergies and identify incompatibilities before bench testing, predict stability challenges based on chemical composition and storage conditions, and navigate regulatory requirements across multiple markets simultaneously. You'll optimize product feel, texture, and performance while maintaining stability, troubleshoot failed batches through root-cause analysis, and document formulations with proper percentages, function codes, and technical rationale.
by asklokesh
You can submit your cosmetics formulation concept and receive comprehensive analysis across three critical dimensions: ingredient compatibility (interactions, solubility, pH stability), regulatory compliance (EU, US, China restrictions and claim substantiation), and market positioning. The skill processes ingredient concentrations, functional claims, and target markets simultaneously to flag compatibility issues, regulatory gaps, and stability risks before costly development work begins.
by asklokesh
Upload store-level POS data, inventory reports, and competitor shelf audits to receive data-backed recommendations for shelf optimization, promotional strategy, and product assortment. The skill analyzes sell-through rates, inventory turnover, seasonal demand patterns, and competitive positioning across retail channels—then delivers specific actions to increase in-store performance, reduce stockouts, and improve market share in your category.
by asklokesh
This skill rapidly processes contracts to identify commercial risks, extract key deal terms, and flag compliance gaps. You'll accelerate contract lifecycle management (CLM) workflows by automating risk assessment, reducing manual review time, and ensuring no critical terms slip through. Perfect for legal teams needing fast, structured contract analysis across multiple document types.
by asklokesh
You can conduct thorough, defensible skin assessments that integrate visual analysis, tactile evaluation, client history, and contraindication screening into a documented consultation protocol. This skill guides you through systematic evaluation of skin conditions, helps identify when physician referral is necessary, and supports informed treatment planning that protects both you and your clients while staying within your scope of practice.
by asklokesh
You develop standardized, evidence-based treatment protocols for medical spa procedures (laser therapy, chemical peels, microneedling, injectables support) that integrate physician oversight requirements and regulatory compliance. For each procedure, you generate detailed client assessment frameworks, pre- and post-care instructions with clinical rationale, contraindication screening workflows, and outcome measurement systems that track results across client populations.
by asklokesh