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
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
- 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