Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
customers
Report Customer Order Frequency Distribution
Bucket all customers by lifetime order count to show the real shape of the buyer base, from one-time to highly frequent.
π Prompt
Bucket every customer by lifetime order count, using order history through today. Buckets: 1 order 2 orders 3-5 orders 6-10 orders 11+ orders Per bucket: Number of customers % of total customer base Total lifetime revenue from the bucket % of total lifetime revenue the bucket represents Average revenue per customer in the bucket Analysis: What % of customers are still 1-order buyers, and what % of total revenue do they represent vs their share of the customer base? Same comparison for the 11+ order bucket β how much revenue concentration sits in the most frequent buyers? Output format: Table: order-count bucket, customer count, % of customers, total revenue, % of revenue, avg revenue per customer Deliverables: The table A clear statement of the Pareto shape of the business: what % of customers generate what % of revenue One idea for moving customers from the 1-order bucket into the 2-order bucket, since thatβs usually the biggest and most reachable group
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