Discount code analysis

Use the StoreHero MCP to do the following analysis. Always anchor the answer in real StoreHero data, not platform-reported metrics.

Give me a discount code analysis for month-to-date vs the same period last year. Pull orders grouped by discount code from the StoreHero connector. For each code, show: orders attributed, revenue, discount % vs full price, AOV with code vs store average, gross profit per order with code vs store average, and contribution margin per order.

Identify codes that are statistically significant — minimum 30 orders or 1% of total order volume — to filter out noise. Then flag codes where the gross profit per order is meaningfully below the store-wide average — these are eating margin, and the customer would likely have purchased without the code (or at a higher AOV).

Apply a traffic-light system: (1) green — code is bringing profitable incremental customers, keep running, (2) amber — worth reviewing, may be cannibalising full-price purchases, (3) red — critical issue, code is dragging contribution margin meaningfully below store average.

For each red and amber code, suggest a concrete action — sunset the code, raise the minimum order threshold, switch from % off to free-product gift, restrict to new customers only, or end-date it.

At the bottom of your answer, render an inline visual summary: an interactive bar chart of orders grouped by discount code with gross-profit-per-order overlay and traffic-light status colour-coding. Add a KPI card for total margin lost to discounting vs LY. Place text commentary alongside the visuals. Use the Spend Advisor tool to suggest what to explore next.