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 validate complete cosmetic formulations against multiple organic certification standards (ECOCERT, COSMOS, USDA Organic, Natrue) and regional regulatory requirements (EU, FDA, Health Canada) simultaneously. The skill identifies non-compliant ingredients, flags reformulation risks, and generates compliance documentation to accelerate your development cycle and eliminate costly post-production failures.
by asklokesh
Activate Loki Mode to orchestrate a multi-agent team that autonomously takes any product specification—whether a Markdown PRD, GitHub issue, OpenAPI doc, or Jira ticket—and drives it through to deployment. The system makes decisions independently, coordinates across multiple AI providers (Claude, Codex, Gemini, Cline, Aider), and tracks progress through phases while maintaining state and handling failures gracefully.
by asklokesh
You can generate comprehensive, liability-aware treatment protocols for advanced medical spa procedures including chemical peels, microdermabrasion, laser therapies, and injectable support services. This skill produces state-compliant consent forms, contraindication screening checklists, detailed aftercare instructions, staff training documentation, and recovery timelines that protect both client safety and facility licensure. Each protocol includes clinical language, realistic outcome projections, and emergency response procedures tailored to your specific treatments.
by asklokesh
You can generate comprehensive regulatory roadmaps for cosmetic products across FDA, EU, China, Canada, and other key markets. This skill maps ingredient restrictions, allowed claims, labeling requirements, and safety documentation needs for each jurisdiction, then produces market-specific checklists, technical file templates, and submission packages that accelerate your approval timeline and eliminate costly compliance gaps.
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 systematically evaluate multi-channel DTC cosmetics campaigns to identify optimization opportunities, calculate true customer acquisition costs (CAC) vs. customer lifetime value (CLV) ratios, and pinpoint underperforming assets. This skill helps you move beyond vanity metrics to diagnose root causes of underperformance, segment performance by customer cohort, and recommend specific optimizations that increase ROAS and profitability across paid social, email, search, and influencer channels.
by asklokesh
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 develop complete cosmetic formulations from concept through production scale-up, evaluating ingredient interactions, predicting shelf-life stability, and ensuring compliance with global regulatory requirements. The skill guides you through concentration optimization, supply chain substitutions, and cost reduction strategies while maintaining product performance and safety.
by asklokesh