Analytics πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick analytics collections

Report Collection Performance

Rank every collection by revenue, conversion rate, and average order value to see which are pulling their weight.

πŸ“‹ Prompt
Run in Sidekick
Rank all collections by performance for [LAST 30 DAYS].

Per collection:

  Sessions to the collection page (if available)
  Revenue from orders containing a product from that collection
  Units sold from the collection
  AOV of orders touching the collection
  Conversion rate: collection page sessions β†’ orders including a product from it
  Number of products currently in the collection


Ranking:

  Top 10 collections by revenue
  Bottom 5 collections by revenue among collections with 5+ products (so it’s not just penalizing small collections)
  Revenue per product in the collection (total collection revenue Γ· product count) β€” flags collections punching above or below their size


Output format:

  Table: collection, sessions, revenue, units, AOV, conversion %, product count, revenue per product


Deliverables:

  The full table
  Flag any large collection (10+ products) with low revenue per product β€” a sign it needs merchandising attention, better product photography, or pruning
  Flag any small collection with high revenue per product β€” a candidate for expansion with more SKUs

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