Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
orders
Report Items per Order Trend
Track average number of line items and units per order over time as a proxy for cross-sell and bundle effectiveness.
📋 Prompt
Track average items per order for [LAST 6 MONTHS], grouped by month. Per month: Average number of distinct line items (unique products) per order Average total units per order (accounting for quantity) % of orders that contain only a single item % of orders that contain 3 or more items Context: Overlay any bundle launches, cross-sell widget changes, or upsell offer changes made during the window (list any known dates), so shifts in the trend can be tied to a cause Compare items-per-order for discounted orders vs full-price orders Output format: Table: month, avg distinct items, avg total units, % single-item orders, % 3+ item orders Deliverables: The table A read on the trend direction — is basket size growing, shrinking, or flat — and, if there’s a known change (bundle launch, new cross-sell placement) in the window, whether the trend shifted around that date One number to headline: current % of orders that are still single-item, since that’s the most direct measure of untapped cross-sell opportunity
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