Dynamic Promotional Elasticity Analyzer
Analyze promotional elasticity patterns to optimize discount strategy and forecast demand
What You Can Do
You can quantify how customer segments respond to different discount depths and promotional timing by analyzing historical sales data. This skill helps you forecast demand under various discount scenarios, identify which product categories or customer groups are price-elastic versus price-inelastic, and recommend optimal promotional calendars that balance revenue maximization with efficient inventory clearance without training customers to expect constant discounts.
Features
Identifies price sensitivity across product categories, customer segments, and promotional mechanics using historical transaction data
Projects incremental volume lift and revenue impact for proposed discount depths and promotional windows
Recommends timing, frequency, and discount depth to prevent customer expectation of constant promotions while maximizing clearance
Compares promotional effectiveness across channels, customer cohorts, and product tiers to identify high-response segments
Builds business cases for flash sales, threshold discounts, and bundling strategies with ROI projections
Analyzes why past promotions underperformed or overperformed relative to targets with root cause insights
Tests multiple promotional strategies (timing windows, discount combinations, inventory targets) to find optimal mix
Flags calendar conflicts, margin erosion risks, and customer expectation management issues in proposed promotional plans
Example Output
Example 1: Elasticity Analysis Output
- Product Category: Winter Apparel
- Price Elasticity Coefficient: -1.45
- Interpretation: A 10% discount drives 14.5% volume increase; promotional margin lift requires only 32% incremental volume
- Optimal Discount Depth: 20% (maximizes revenue with minimal margin erosion)
Example 2: Demand Forecast
- Scenario: 25% discount, 2-week window, email + site banner
- Baseline Weekly Sales: 2,500 units
- Forecasted Lift: +38% incremental volume
- Revenue Impact: +$45K total (after margin loss), ROI: 3.2x
Example 3: Promotional Calendar Recommendation
- Q4 Strategy: Early October flash sale (35% off clearance, 48 hours), Black Friday tiered (15-25% off core), January deep clearance (40% off seasonal)
- Rationale: Spacing prevents margin damage; flash creates urgency; tiered protects core margin; seasonal clearance aligns with natural demand cliff
What's Included
- SKILL.md: Complete skill documentation with use cases and framework
- Elasticity Analysis Template: Data input structure and calculation methodology for price sensitivity quantification
- Promotional Scenario Model: Spreadsheet-based framework for modeling demand under different discount/timing combinations
- Promotional Calendar Builder: Planning checklist with optimal timing windows, frequency guidelines, and conflict-checking criteria
- Business Case Framework: ROI calculation template and margin-impact analysis for proposed promotions
Who It's For
- Pricing Analysts — Building data-driven promotional strategies and optimizing discount calendars
- Merchandising Managers — Planning seasonal promotions and evaluating clearance timing
- E-Commerce Directors — Balancing revenue goals with customer expectation management across channels
- Retail Planners — Forecasting inventory clearance requirements and promotional calendar gaps
- Revenue Managers — Quantifying margin impact of proposed discounts and identifying profitable promotional windows
Best For
- Seasonal promotional calendar planning (Q1, Q4, clearance windows)
- Evaluating discount depth for flash sales, threshold offers, or bundled promotions
- Analyzing underperforming or overperforming past promotions with root cause identification
- Building business cases and ROI projections for specific promotional strategies
- Comparing promotional effectiveness across product categories, customer segments, or sales channels
You might also like
You can systematically analyze vendor performance data across multiple KPIs (sales, turn rate, on-time delivery, quality, margin contribution), identify root causes of underperformance, benchmark vendors against category standards, and develop specific improvement plans with calculated financial impact. This skill translates raw vendor metrics into compelling business cases for vendor investments, contract negotiations, or corrective actions, replacing intuition-based feedback with data-driven strategic conversations.
by cowork-os
You can upload sales velocity, margin, inventory, and competitive data to receive structured assortment analysis grounded in category management principles. The skill identifies low-performing SKUs for elimination, unmet customer demand (white space), and right-sizing opportunities—then delivers actionable recommendations with financial impact projections to justify decisions to leadership.
by cowork-os
This skill transforms raw sales, inventory, and market data into actionable assortment insights. You'll rank SKUs by velocity, margin, and trend trajectory to identify underperformers worth pruning. Discover whitespace gaps—missing size/color/price tier combinations that competitors stock but you don't. Model the financial impact of proposed assortment changes, projecting revenue and margin shifts before implementation.
by cowork-os
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
by cowork-os
You can strategically analyze store layouts and visual displays to identify optimization opportunities that drive unplanned purchases and improve customer navigation. This skill helps you create cohesive visual narratives aligned with brand guidelines, develop seasonal and campaign-driven display concepts, and audit existing installations against performance benchmarks to maximize conversion rates and basket size.
by cowork-os
You can upload sales data, margin metrics, and customer behavior patterns to uncover hidden performance trends across your product portfolio. Claude analyzes sales velocity, margin contribution, and customer engagement to surface optimization opportunities—identifying which SKUs to promote, bundle, or rationalize. The skill generates actionable category strategies, reorder rate analysis, and competitive positioning recommendations tailored to your digital channels and seasonal opportunities.
by cowork-os
This skill processes complex FMCG sales datasets to identify demand patterns, seasonal volatility, and promotional impact on your category. You can forecast future demand with confidence, optimize your SKU mix to eliminate dead inventory and stockouts, and align assortment resets with historical seasonal cycles—enabling data-driven buying decisions that balance shelf constraints, supplier minimums, and margin targets.
by cowork-os
You can rapidly assess current planogram performance against sales data, identify underperforming SKUs and space inefficiencies, and generate detailed shelf layout recommendations that balance profitability, velocity, and compliance. Claude processes your category mix, fixture dimensions, regulatory constraints, and competitive positioning to produce actionable planograms ready for retail operations review and store execution.
by cowork-os