Product Performance Report Builder

Build a detailed product performance report for my Shopify store that evaluates every product across multiple performance dimensions.

Store Context:

  Store URL: [YOUR_STORE_URL]
  Total active products: [PRODUCT_COUNT, e.g., 250]
  Product categories: [CATEGORIES, e.g., tops, bottoms, accessories, shoes]
  Reporting period: [TIME_PERIOD, e.g., last 90 days]
  Comparison period: [COMPARISON_PERIOD, e.g., previous 90 days]
  Cost data available: [COST_DATA, e.g., yes in Shopify, yes in spreadsheet, not tracked]


Report Sections:


  Product Ranking Table:
Create a sortable table for all products with columns:
    
      Product name, SKU, category, and vendor
      Units sold and revenue in [TIME_PERIOD]
      Units sold and revenue in [COMPARISON_PERIOD]
      Growth rate (period over period percentage change)
      Conversion rate (product page views to purchases)
      Average selling price (accounting for discounts)
      Gross margin if [COST_DATA] is available
      Return rate and return reason summary
      Current inventory quantity and days of stock remaining
    
  
  Performance Quadrant Analysis:
Plot products on a 2x2 matrix:
    
      Stars: high revenue, high growth (invest more)
      Cash cows: high revenue, low/negative growth (maintain)
      Question marks: low revenue, high growth (evaluate potential)
      Dogs: low revenue, low/negative growth (consider discontinuing)
      List top 5 products in each quadrant with recommended actions
    
  
  Category Performance Summary:
For each category in [CATEGORIES]:
    
      Total revenue and percentage of store revenue
      Average order value when category products are in cart
      Best and worst performing product in category
      Category growth trend over last 6 months
      Inventory health (overstock vs understock assessment)
    
  
  Product Lifecycle Analysis:
    
      New products (launched in last 30 days): early performance indicators
      Growing products: consistent upward sales trend
      Mature products: stable sales, potential for refresh
      Declining products: downward trend requiring intervention
      End of life: candidates for clearance or removal
    
  
  Pricing Analysis:
    
      Revenue by price tier (under $25, $25-50, $50-100, $100+)
      Impact of discounting on units sold vs margin
      Products most frequently discounted and their full-price conversion rate
      Price elasticity observations based on historical price changes
    
  
  Action Items:
    
      Top 10 products to promote more aggressively (high margin, growing)
      Top 10 products to discount or bundle (slow movers with excess inventory)
      Products to reorder immediately (fast sellers with low stock)
      Products to discontinue (low sales, high return rate, low margin)
      New product gap analysis based on category performance patterns