Reporting
AuraScore 81/100

Omnichannel Merchandising Sell-Through Brief

Synthesise retail category sales, margin yields, and channel performance into a concise executive merchandising brief.

Use this template when preparing monthly or seasonal merchandising reviews for category directors and retail buying teams. It structures sell-through velocity, discount elasticity, and channel variances into high-impact operational recommendations.

Template

Role: Senior Omnichannel Merchandising Analyst with fifteen years of retail analytics experience.

Context

  • Target Product Assortment: {{brand_portfolio}}
  • Evaluated Window: {{reporting_period}}
  • Sales Channels: {{channel_breakdown}}
  • SKU Movement Rates: {{inventory_turnover_data}}
  • Discount & Promo Data: {{promotional_campaign_metrics}}
  • Financial Benchmarks: {{margin_targets}}

Task

Produce an omnichannel merchandising brief that evaluates category sell-through velocity, margin preservation across physical and digital storefronts, and provides clear markdown or replenishment actions for retail leadership.

Method

  1. Normalise sell-through rates across {{channel_breakdown}} to account for baseline footfall versus digital conversion disparities.
  2. Cross-reference {{inventory_turnover_data}} against {{margin_targets}} to flag underperforming lines suffering from excess inventory risk.
  3. Evaluate the net margin impact of {{promotional_campaign_metrics}} within {{brand_portfolio}} during {{reporting_period}}.
  4. Segment category performance into top gross-margin generators, high-velocity traffic drivers, and margin-eroding laggards.
  5. Isolate channel-specific bottlenecks, such as digital cart abandonment peaks or brick-and-mortar stock-outs.
  6. Formulate precise markdown, re-allocation, or promotional exit recommendations to safeguard cash conversion cycles.
  7. Structure immediate inventory balancing interventions across retail distribution centres.

Constraints

  • MUST express all inventory velocity figures as weekly sell-through percentages or weeks of supply.
  • MUST NOT exceed 750 words across the entire brief deliverable.
  • Recommendations MUST directly cite trade-offs between gross margin percentage and volume clearance.
  • Do not include generic retail platitudes; ground every finding in {{brand_portfolio}} data.

Output format

  • Assortment Executive Summary (max 100 words)
  • Cross-Channel Sell-Through Scorecard (structured bulleted comparison)
  • Promotional Elasticity & Margin Assessment (2-3 targeted paragraphs)
  • Inventory Balancing & Replenishment Directives (numbered action items)

Self-review

  • Confirm all 6 context variables are actively integrated in the analysis.
  • Verify that margin variances are tied directly to promotional discount depth.
  • Ensure word count strictly respects the 750-word upper limit.
AuraScore breakdown
81/100Provisional
Instruction clarity15/15 · Strong

Explicit role, a named task, and discrete steps the model can follow.

Context architecture12/12 · Strong

Background, inputs and variables the model needs before it starts.

Constraint engineering10/12 · Adequate

Hard boundaries — what the model must and must not do.

Output specification6/14 · Thin

A named, field-level shape for the response.

Reasoning structure10/10 · Strong

Ordered work items that force analysis before an answer.

Model compatibility10/10 · Strong

Length and structure that travel across frontier models.

Token efficiency7/10 · Adequate

Signal density — instruction weight without padding.

Reusability7/7 · Strong

Documented variables so the scaffold adapts to new inputs.

Robustness3/5 · Adequate

Quality bar, assumptions and behaviour when inputs are thin.

Observed performance1/5 · Thin

How much real usage the template has behind it.

data-analytics
data-reporting
retail-consumer-goods
merchandising
omnichannel
retail-analytics