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
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
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
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
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