Analytics πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick analytics timing

Report Revenue by Hour of Day

Break down order volume and revenue by hour of day to time flash sales, emails, and support staffing.

πŸ“‹ Prompt
Run in Sidekick
Break down orders and revenue by hour of day for [LAST 30 DAYS], in the store’s local timezone.

Per hour (0-23):

  Number of orders
  Revenue
  % of daily order volume that hour represents, averaged across the period


Also include:

  Same breakdown split into weekday vs weekend, since the hourly pattern often differs
  The 3 highest-volume hours and 3 lowest-volume hours


Output format:

  Table: hour, orders, revenue, % of daily volume
  Weekday vs weekend comparison table


Deliverables:

  Both tables
  The best hour to schedule a flash sale or app-generated push notification, and the best window to schedule marketing emails so they land right before a historically high-converting hour
  The lowest-volume hours, useful for scheduling maintenance windows or app updates with minimal customer impact

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions