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

  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