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
Run in Sidekick
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

  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