Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
discounts
Report Discount Impact on Margin
Quantify how much gross margin discount codes and automatic discounts are giving away, by code and by product.
π Prompt
Report how much gross margin my active and recent discounts are costing me, for orders placed in [LAST 30 DAYS / LAST QUARTER]. Per discount code / automatic discount: Number of orders it was applied to Total discount amount given Revenue from those orders (net of the discount) Estimated margin $ on those orders (using product cost-per-item) before and after the discount Discount as a % of the pre-discount order value Comparison: Compare AOV and margin % of discounted orders vs full-price orders in the same window Rank discounts by total margin dollars given away, highest first Flag any discount code whose orders have a margin % low enough that the store may be losing money after fulfillment costs Output format: Table: discount name, order count, total discount $, revenue, estimated margin $, margin % vs full-price baseline Deliverables: The ranked table Name the single discount code costing the most margin dollars this period One recommendation per flagged discount: keep as-is, tighten the terms (lower %, add a minimum order value, shorten expiry), or retire it β based on whether itβs driving net-new revenue or just discounting orders that would have happened anyway
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions