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

  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