shopify-admin-discount-roi-calculator

Purpose

Evaluates the true return on investment for each discount code and automatic discount by measuring revenue generated, number of orders, average order value with vs. without discount, customer acquisition attributed to discounts, and whether discounted orders cannibalized full-price sales. Goes beyond discount-hygiene-cleanup (which finds broken/unused codes) to answer "was this discount worth it?" Read-only — no mutations.

Prerequisites

• Authenticated Shopify CLI session: shopify store auth --store <domain> --scopes read_orders,read_discounts
• API scopes: read_orders, read_discounts

Parameters

Safety

ℹ️ Read-only skill — no mutations are executed. Safe to run at any time.

Workflow Steps

1. OPERATION: discountNodes — query Inputs: first: 250, select discount details (title, code, type, value, usageCount, startsAt, endsAt), pagination cursor Expected output: All discount codes and automatic discounts

2. Filter to discounts with usageCount >= min_uses and active within lookback window

3. OPERATION: orders — query Inputs: query: "created_at:>='<NOW - days_back days>' discount_code:<code>", first: 250 for each active discount code, select totalPriceSet, totalDiscountsSet, subtotalPriceSet, customer { id, numberOfOrders }, pagination cursor Expected output: All orders using each discount

4. Also query orders WITHOUT any discount in same period for baseline AOV comparison

5. For each discount, calculate:

   • Total Discount Cost = Σ(totalDiscountsSet for orders with this code)
   • Revenue Generated = Σ(totalPriceSet for orders with this code)
   • Discounted AOV = revenue / orders
   • Baseline AOV = AOV of non-discounted orders in same period
   • AOV Lift/Drop = discounted AOV - baseline AOV
   • New Customer % = orders where customer.numberOfOrders == 1 / total
   • Gross ROI = (revenue - discount_cost) / discount_cost × 100
   • Cannibalization Risk = high if discount AOV < baseline AOV and new customer % < 20%