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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions