Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
customers
Report New vs Returning Customer Revenue Split
Split revenue and order volume between first-time and returning customers to see how reliant the store is on new acquisition.
📋 Prompt
Split total revenue between new and returning customers for [LAST 30 DAYS / LAST QUARTER], grouped by [WEEK / MONTH]. Per period: Revenue from customers placing their first-ever order (new) Revenue from customers who have ordered before (returning) % of revenue from each group Order count and AOV for each group Trend: is the returning-customer revenue share growing or shrinking over the window? Output format: Table: period, new customer revenue, returning customer revenue, % new, % returning, AOV new, AOV returning Deliverables: The table A 3-4 sentence read on the trend: is the store becoming more or less dependent on new-customer acquisition, and is that healthy given the current repeat purchase rate? Flag if returning-customer AOV is meaningfully higher or lower than new-customer AOV, since that changes how much a repeat customer is actually worth
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