Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
discounts
Report Discount Code Usage and ROI
Rank every active and recent discount code by usage, revenue generated, and incremental value versus its cost.
π Prompt
Report usage and performance for every discount code used in [LAST 90 DAYS]. Per code: Times used (order count) Total discount $ given Total order revenue generated AOV of orders using the code vs store-wide AOV in the same period % of uses by new customers vs returning customers Days remaining until expiry, if the code is still active Ranking: Top 10 codes by total revenue generated Top 10 codes by total discount $ given away Codes with very low usage (under [5] uses) relative to how long theyβve been active β likely candidates to retire or promote harder Output format: Table: code, uses, discount $ given, revenue generated, AOV, % new customers Deliverables: The ranked tables Identify the single best-performing code (highest revenue relative to discount given) and the single worst-performing code (lowest usage or lowest revenue relative to discount given) so a call can be made on which to keep, retire, or promote
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