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

Report Repeat Revenue from Loyal Buyers

Isolate the revenue coming from customers with 3+ past orders to show how much of the business is recurring-like, without a formal subscription program.

đź“‹ Prompt
Run in Sidekick
Break out how much of my revenue comes from repeat buyers, treating customers with 3 or more lifetime orders as a proxy for “recurring-like” revenue even though I don’t run a subscription program.

Segments:

  1st-time buyers (this is their only order to date)
  2nd-order buyers
  3+ order buyers (“loyal” segment)


Per segment, for [LAST 90 DAYS]:

  Revenue
  % of total revenue
  Number of customers
  Average orders per customer in the window
  Average days between orders (for the 3+ segment specifically)


Trend:

  Compare the 3+ segment’s revenue share this period vs the prior period — is recurring-like revenue growing as a share of the business?
  Average revenue per 3+ order customer over the trailing 12 months, as a stand-in lifetime-value number for this segment


Output format:

  Table: segment, revenue, % of total, customer count, avg orders per customer
  Trend line for 3+ segment revenue share over the last [6] periods


Deliverables:

  Both outputs
  One number to headline: what % of current revenue is coming from customers who’ve now bought 3+ times
  Note whether the average gap between orders for the 3+ segment suggests a natural reorder cycle worth building a win-back flow or subscription offer around

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