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

Report Order Size Distribution

Bucket all orders by dollar value to show the real spread behind the average order value number.

đź“‹ Prompt
Run in Sidekick
Show the distribution of order values for [LAST 30 DAYS], not just the average.

Value buckets (adjust to fit typical order size):

  Under [$25]
  [$25]-[$50]
  [$50]-[$100]
  [$100]-[$200]
  Over [$200]


Per bucket:

  Number of orders
  % of total orders
  Total revenue from the bucket
  % of total revenue from the bucket


Also report:

  Median order value (a better “typical order” number than the average, since it isn’t skewed by a few large orders)
  The single largest order in the period, for context
  How many orders fall below any current free-shipping threshold, and how close to the threshold they are on average (relevant for threshold-tuning decisions)


Output format:

  Table: value bucket, order count, % of orders, revenue, % of revenue
  Median and largest-order callouts


Deliverables:

  The table
  A note on where the bulk of order volume actually sits vs where the bulk of revenue sits — these are often different buckets, and that gap is useful for deciding where to focus AOV-lifting tactics like a free-shipping threshold or an upsell prompt

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