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
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
- 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