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

Report First-Time vs Repeat Customer AOV Comparison

Directly compare average order value between first-time buyers and repeat buyers to size how much more a returning customer is worth per order.

📋 Prompt
Run in Sidekick
Compare AOV between first-time and repeat customers for orders placed in [LAST 90 DAYS].

What to calculate:

  AOV for orders that are a customer’s 1st order
  AOV for orders that are a customer’s 2nd order
  AOV for orders that are a customer’s 3rd or later order
  % difference between 1st-order AOV and 3rd+-order AOV
  Same comparison, but for units per order instead of dollar value


Breakdown:

  Top 5 products bought most often in 1st orders vs top 5 products bought most often in 3rd+ orders — does what customers buy shift as they become repeat buyers?


Output format:

  Table: order sequence (1st / 2nd / 3rd+), AOV, avg units, order count
  Two top-5-products lists


Deliverables:

  The table and product lists
  One clear number: how much more (in $ and %) a repeat customer’s order is worth on average vs a first-time customer’s, since that’s a useful input for how much can be spent on retention marketing per customer

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