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 quotes by deconstructing cost structures, identifying hidden costs and margin compression points, and modeling multiple pricing scenarios. The skill enables you to forecast margin impact across volume tiers, develop proactive negotiation strategies grounded in vendor financials, and build data-backed proposals that improve both your margins and vendor sustainability—transforming reactive price-pushing into strategic partnership analysis.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level 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
Transform raw sales data into strategic insights by decomposing performance variance into specific drivers, benchmarking category health against targets, and quantifying the financial impact of merchandising decisions. You'll uncover hidden patterns in customer behavior, identify performance bottlenecks, and build executive-ready business cases backed by rigorous data analysis—moving beyond dashboards to actionable strategy.
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 develop strategic visual merchandising plans that integrate business objectives, customer behavior analysis, and brand guidelines into actionable retail presentations. This skill guides you through spatial psychology, color theory, product hierarchy, and sales velocity analysis to create zone-specific placement strategies, seasonal displays, and fixture specifications that drive conversion and average transaction value. You'll analyze competitor approaches, align visual hierarchy with margin targets, and build frameworks for multi-location consistency.
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 convert raw pricing data into defensible, actionable price recommendations by analyzing competitor behavior, demand elasticity, inventory health, and seasonal factors simultaneously. This skill helps you balance revenue maximization against competitive positioning and inventory velocity, enabling you to prioritize which SKUs to adjust first and justify price changes to stakeholders with quantitative rationale.
by cowork-os