Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
timing
Report Revenue by Day of Week
Compare revenue, order count, and AOV across each day of the week to spot the strongest and weakest sales days.
📋 Prompt
Break down orders, revenue, and AOV by day of week for [LAST 90 DAYS]. Per day (Monday-Sunday): Total revenue across all weeks in the period Average revenue per occurrence of that day Order count AOV % of weekly revenue that day typically represents Analysis: Rank days from strongest to weakest by average revenue Is the gap between the strongest and weakest day large enough to justify shifting email sends, ad spend, or promotions toward specific days? Has any discount code or campaign historically been run on the weakest day, and did it noticeably close the gap? Output format: Table: day of week, avg revenue, order count, AOV, % of weekly revenue Deliverables: The table, ranked strongest to weakest day A concrete recommendation: which day to prioritize for a scheduled promotion or email send to lift the weakest day’s performance
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