Retail Performance Analytics for Cosmetics Brands
Analyze retail sales, inventory, and competitor data to optimize cosmetics shelf placement and pr...
What You Can Do
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.
Features
Compare sales velocity, margin contribution, and inventory turnover by geography, channel (Sephora, Ulta, department stores), and product line
Identify underperforming SKUs and recommend consolidation, repricing, bundling, or discontinuation based on sell-through and space efficiency
Generate category-specific recommendations for linear feet allocation, vertical positioning, and planogram adjustments to maximize visibility and adjacency
Measure pre/post lift, margin impact, cannibalization rates, and ROI by promotion type (GWP, discount, bundle) to inform future campaigns
Map competitor assortment, pricing, and shelf presence to identify white space opportunities and defensive positioning tactics
Analyze historical trends to predict category peaks (holidays, summer, back-to-school) and recommend inventory build and promotional timing
Pinpoint slow-moving stock and overstock situations that consume working capital, with rebalancing recommendations by location
Example Output
Example 1: Underperforming SKU Diagnosis
Input: Q3 sales data showing matte lipstick in shade 'Burgundy Wine' selling at 0.8x velocity vs. category average across 500 doors.
Output:
- Problem: Positioned on secondary shelf; competitors' burgundy shades on eye level
- Recommendation: Relocate to primary plano (eye level, 6 linear feet); bundle with lip liner in complementary shade
- Expected lift: 35-50% velocity increase based on similar repositioning case studies
Example 2: Seasonal Reset Strategy
Input: Historical sales showing summer prestige skincare demand peaks in May; current inventory build timeline is January.
Output:
- Months to act: March (promotional prep), April (inventory staging)
- Shelf plan: Expand hydrating moisturizer/SPF category to 40% of skincare linear; reduce heavy winter creams to 15%
- Promotion: Launch "Summer Glow" bundle (moisturizer + sunscreen + sheet mask) 4 weeks before peak demand
- Vendor order: 120% of May-June 2024 volumes to account for 25% YoY growth trend
Example 3: Competitive Positioning Gap
Input: Shelf audit showing competitor X has 3 shades of cream blush; your brand has 1 SKU in the same price tier.
Output:
- Gap analysis: Competitor captures 65% of cream blush category; your brand 12%
- Action: Expand assortment to 3 shades within 90 days; negotiate additional 2 linear feet
- Pricing: Match competitor on lead shade; position premium shade at +$3 for perceived quality lift
- Expected share gain: 8-12 percentage points in category within one season
What's Included
- SKILL.md: Complete skill definition and usage guidelines
- Retail Data Analysis Template: Structured worksheet for organizing POS data, inventory levels, and competitor audits by store and product
- Store Performance Dashboard Framework: Key metrics to track (sell-through %, inventory turns, margin/unit, velocity index) with calculation formulas
- SKU Rationalization Checklist: Step-by-step decision tree for evaluating which underperformers to reposition, bundle, reprice, or discontinue
- Shelf Placement Recommendation Template: Output format for planogram changes including linear feet allocation, vertical positioning, and adjacency notes
Who It's For
- Cosmetics Brand Managers — Own P&L accountability for in-store performance and need data-driven shelf strategy
- Retail Operations Directors — Optimize inventory allocation and promotional effectiveness across store networks
- Category Managers — Manage assortment and competitive positioning within retail channels (Sephora, Ulta, department stores, independent)
- Supply Chain Planners — Forecast demand seasonally and rebalance inventory to reduce stockouts and overstock
- Marketing Managers — Evaluate promotional ROI and plan launches with data-backed timing and placement strategy
Best For
- Quarterly store performance reviews and trend identification across geographies and channels
- SKU assortment decisions—consolidations, discontinuations, and new shade/product launches
- Promotional planning and evaluation (GWPs, discounts, bundles) to maximize lift and margin
- Seasonal category resets and inventory positioning (holiday, summer, back-to-school)
- Competitive shelf audits and white-space analysis for market share expansion
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 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.
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 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