Task IntentAnalytics
Analyze Product Performance
Deep-dive into individual product and collection performance with profit margins, sell-through rates, and inventory health metrics.
What This Sidekick Query Does
Deep-dive into individual product and collection performance with profit margins, sell-through rates, and inventory health metrics.
Prompts
Copy, adapt, and run this directly in Shopify Sidekick.
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
Deep-dive into individual product and collection performance with profit margins, sell-through rates, and inventory health metrics.
Tips to Improve Results
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