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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions