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