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
This skill connects to your MyCase data to automatically extract matter insights, generate accurate billing summaries, and create reusable practice templates. You can analyze client work patterns, identify billing anomalies, and standardize matter workflows across your firm without manual data entry.
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 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
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'll transform raw QC analytical data into structured batch release decisions that satisfy regulatory requirements. Claude guides you through specification comparison, statistical deviation analysis, root cause tracing, and corrective action planning—turning instrumental results (HPLC, viscosity, pH, microbiology) into clear hold/release recommendations with documented justification for audits and inspections.
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 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
Rapidly develop and balance cosmetic formulations by analyzing how actives, solvents, emulsifiers, and preservatives interact within your system. You can evaluate ingredient compatibility before ordering materials, diagnose why batches fail (separation, crystallization, potency loss), and optimize texture and performance while maintaining stability and regulatory compliance. This skill reduces iteration cycles by catching formulation conflicts early and providing data-driven adjustment recommendations.
by asklokesh