Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics discounts

Report First-Order Discount Dependency

Measure what share of new customers only convert with a discount code, and whether those customers come back at full price later.

📋 Prompt
Run in Sidekick
Report how dependent first-time purchases are on a discount code, for new customers acquired in [LAST 90 DAYS].

What to calculate:

  % of first orders that used a discount code vs full price
  Average discount % applied on first orders
  AOV of discounted first orders vs full-price first orders


Follow-through check:

  Of customers whose first order was discounted, what % placed a 2nd order?
  Of that 2nd order, what % also used a discount code (still price-sensitive) vs paid full price (discount successfully converted them into a full-value customer)?
  Same follow-through numbers for customers whose first order was full-price, for comparison


Output format:

  Summary: % of first orders discounted, average discount %
  Table comparing discounted-first-order customers vs full-price-first-order customers: repeat rate, % of repeat orders still discounted, average lifetime orders so far


Deliverables:

  The comparison table
  A clear read on whether the current first-order discount is acquiring customers who convert to full-price repeat buyers, or mostly attracting one-time deal-seekers who never return without another discount

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