Build Sales Dashboard Report

What This Sidekick Query Does

Create a comprehensive sales dashboard report for my Shopify store:

Key Metrics to Include:

  Total revenue (today, this week, this month, this year)
  Number of orders and average order value (AOV)
  Conversion rate (sessions to orders)
  Revenue vs previous period (% change)
  Gross profit margin


Breakdowns:

  Revenue by day — line chart data for last 30 days
  Top 10 products by revenue and by units sold
  Top 5 collections by revenue
  Revenue by hour of day — when do customers buy most?
  Revenue by day of week — best and worst days
  New vs returning customer revenue split
  Average discount amount and discount usage rate


Alerts & Insights:

  Products with declining sales (vs previous period)
  Products with increasing return rates
  Unusual spikes or drops in traffic/sales
  Best-performing discount codes


Format:
Present as a structured report with:

  Executive summary (3-4 key takeaways)
  Detailed metrics with period comparisons
  Actionable recommendations based on the data


Generate this report for the period: [LAST 30 DAYS / LAST QUARTER / CUSTOM RANGE]

Expected Output

Tips to Improve Results