Skip to main content
Metrics type: Supporting Metrics • Category: Ecommerce Platform

​
At a glance

Top N discount codes ranked by redemption count in the 30D window. The marketing-cost-of-promotion view: which codes are doing the work?

​
Calculation

Calculated automatically from your Shopify data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

A US activewear DTC brand on Shopify Plus, runs welcome + seasonal codes. 30D window 12 Apr 26 to 12 May 26. Six things to notice:
  1. WELCOME10 is the workhorse. 1,820 redemptions, mostly one-per-customer, ~41% of all code-using orders. AOV 134vsfull−price 134 vs full-price ~87 confirms the welcome-cohort skews to bigger baskets (per AOV with/without Discount).
  2. FRIENDS25 is expensive. 25% off, 640 redemptions, 19,200cost.That′s2619,200 cost. That's 26% of total discount-spend on a single mid-month campaign. Was the resulting incremental revenue >19,200? If yes, profitable; if no, it cannibalised existing-customer spend.
  3. FREESHIP is free in name only. 9,400ofwaivedshippingcost.Thebrand′stypicalshippingcostis9,400 of waived shipping cost. The brand's typical shipping cost is 7-8 per parcel; FREESHIP saved customers ~$10 each. The brand absorbed this. Worth tracking against full-price-with-shipping AOV.
  4. INSTASARAH is leaking. Public influencer code, 320 redemptions. If only ~150 customers came from Sarah’s posts, the other 170 found the code on RetailMeNot or from social-sharing. Influencer codes should be private (one-per-link or unique-per-post).
  5. TRAINING20 was strategic. Category-specific code; lifted training-product orders without cannibalising other categories. Worth repeating quarterly.
  6. BIRTHDAY is automation. 180 redemptions from Klaviyo birthday flow. Lower AOV ($89) than WELCOME10, expected (birthday gifts are lower-budget impulse).
Total cost-to-revenue ratio: 74,100ofdiscountsonroughly74,100 of discounts on roughly 580,000 of revenue from the 4,442 code-using orders = 12.8% discount load. For comparison, the brand’s full-price cohort is 79% of orders at no discount cost. Pair with Discount % of Revenue for the headline ratio.

​
Sibling cards merchants should reference together

Top Discount Codes is the per-code drill-down. Companions:

​
Reconciling against the vendor’s own dashboard

Where to look in Shopify Admin:
Shopify Admin → Discounts for the code list, then Analytics → Reports → “Discounts” for usage and value
The Discounts admin page lists all codes with status; the Discounts report shows orders-using-code with sum of discount value. Combine for a per-code view that should match this card to within sync-lag tolerance. Other Shopify Admin views:
  • Reports → Sales attributed to a marketing campaign: campaign-level rather than code-level.
  • Apps like Reactivate, Klaviyo, Smile.io: their reports show flow-attributed discount usage; subset of total.
Why our number may legitimately differ from Shopify Admin: Cross-connector reconciliation:

​
Known limitations / merchant FAQs

Why is my welcome code dominating the list? Welcome codes get high volume because they’re attached to email signup; nearly every new customer can redeem one. They’re typically your largest single line of discount-cost. The question is whether the cohort they bring is profitable; pair with New Customers. My affiliate / influencer code is leaking. What can I do? Affiliate codes shared on coupon-aggregator sites like Honey, RetailMeNot, Capital One Shopping become public quickly. Three remediations:
  1. One-per-customer limit: prevents repeat-redemption by code-shoppers.
  2. Trackable-link-only redemption: requires the click-through to attribute, not the code alone.
  3. Auto-rotation: change codes periodically; lifetime of a public code is short.
Why does FREESHIP look so cheap? FREESHIP appears low-cost because the discount value is the shipping waived (typically $7-15), not 10-25% of the basket. But the unit-economics impact may be larger if it converts low-AOV browsers into low-AOV buyers (the brand absorbs shipping on small orders). Why doesn’t my BFCM site-wide discount appear here? Site-wide automatic discounts may not have a “code”. They show up as “AUTOMATIC” or with the internal discount name. Look for the campaign name rather than a code string. Are stacking codes inflating the redemption count? Yes, if your store allows code-stacking. A customer using WELCOME10 + FREESHIP on one order shows two redemptions. To avoid, configure Shopify to block stacking (one-discount-per-order), or use Shopify Functions for custom logic. My birthday code shows lower AOV. Why? Birthday codes are emotional gifts (low-friction, often impulse-redeemed). Customers tend to use them on personal-treat baskets, not their normal full-basket shopping. Lower AOV is structural and expected. **How do I evaluate “is this code profitable?” For each code:
  1. Incremental customers: customers who wouldn’t have bought without the code. Estimate via lift testing or conservative assumption (e.g. 60-80% of welcome-code customers are incremental; 10-20% of existing-customer reactivation codes are).
  2. Discount cost per redemption: total $-discount / redemptions.
  3. LTV uplift from incremental: incremental_customers × LTV.
  4. ROI: (LTV uplift - discount cost) / discount cost.
If ROI > 1, profitable; if 0-1, breaking even; if negative, you’re paying customers to buy what they would have bought anyway. My subscription store, do recurring billings count? If the original purchase used a code, recurring billings inherit it as a discount line item. Each billing counts as one redemption here. Subscription-heavy brands see code redemption counts that scale with subscriber count, not new-customer count. Action playbook for managing discount codes:
  1. Monthly audit: review top-10 codes for cost-to-incremental-revenue ratio.
  2. Sunset under-performers: codes with high cost and no incremental revenue should expire.
  3. Tighten leaky codes: public influencer codes need stricter rules.
  4. A/B test welcome code depth: 10% vs 15% on welcome flow; the higher-discount may not bring more first-time customers, just cost more.
  5. Replace generic codes with personalised: “WELCOME10” gets shared; one-time-per-customer auto-generated codes don’t.
  6. Cap usage limits: every campaign code should have a usage cap (per customer + total) to prevent runaway redemption.

​
Tracked live in Vortex IQ Nerve Centre

Top Discount Codes is one of hundreds of KPI pulses Vortex IQ tracks across Shopify and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.