On-Demand Weekly Performance Report (Not Auto-Scheduled)

I want a full weekly performance report for my Shopify store, pulled on demand from live store data. Note: Sidekick cannot schedule recurring deliveries to email/Slack/Sheets or trigger real-time alerts — it can only build and run the report when I ask. For a recurring delivery, I’ll wire this report’s output into Zapier/Make separately.

Store URL: [YOUR_STORE_URL]
Week to report on: [DATE_RANGE, e.g., this week vs. last week]

Please build a ShopifyQL report/query showing:


  This week’s total revenue, order count, and AOV vs. the previous week (% change).
  Top 10 products by revenue and top 10 by units sold this week.
  Traffic source breakdown (sessions and conversion rate by source) for this week vs. last week.
  New vs. returning customer split for orders this week.
  Any products that went out of stock this week.
  Currently active discount codes and their redemption count this week.


Format the output as a single structured report I can read in one sitting. Save it as a reusable skill (e.g., /weekly-report) so I can rerun it every Monday by asking for it — do not propose an external scheduling tool, cron job, or automated delivery pipeline.