Analyze Product Performance

What This Sidekick Query Does

Analyze product performance across my Shopify store:

Per-Product Metrics:

  Revenue and units sold (last 30 days vs previous 30)
  Profit margin (revenue - cost of goods if available)
  Conversion rate (product page views → add to cart → purchase)
  Return/refund rate
  Average rating and review count


Product Rankings:

  Top revenue generators — the 80/20 (which 20% of products drive 80% of revenue?)
  Rising stars — products with biggest growth % this month
  Declining products — biggest revenue drops this month
  Best converters — highest view-to-purchase rate
  Worst converters — high traffic but low purchases (optimization opportunities)
  High return products — quality or expectation issues


Collection Performance:

  Revenue by collection
  Average product performance per collection
  Collections with inventory issues (overstock/understock)


Inventory Health:

  Days of inventory remaining per product
  Dead stock (no sales in 60+ days)
  Products frequently out of stock (lost revenue estimate)


Recommendations:

  Products to promote more (high margin + good reviews)
  Products to discount/clearance (slow moving)
  Products needing page optimization (high traffic, low conversion)
  Restock priorities based on sell-through rate

Expected Output

Tips to Improve Results