What Is the Shopify Weekly Sales Pattern Report?
The Weekly Sales Pattern report groups your Shopify net sales into recurring time windows, mapping each sale to its Hour of Day and Day of Week across the date range you select. Instead of a single revenue line moving forward through the calendar, it shows the repeating rhythm underneath: which hours on which weekdays consistently bring in money.
This is where merchants often confuse two things. A calendar trend answers "how did revenue move from March 1 to March 31." This report answers a different question: "across all those Fridays and all those Tuesdays, when do buyers actually check out." Because the data is aggregated by weekday and hour rather than by date, it surfaces the demand cycle a date-by-date view hides.
Merchants use it to decide when to run ads, when to send email and SMS, and when to have support or retail staff on hand, so effort lines up with the hours customers are already buying.
Which Fields Are Included in the Shopify Weekly Sales Pattern Report?
These four fields let you locate revenue precisely within the week and read how it is distributed across hours and days.
You can customize the pre-made report by adding, removing, or rearranging fields, for example adding order count alongside Net Sales to see whether a window is many small orders or a few large ones.
Important Insights You Can Find in This Report
Which day-and-hour windows consistently pull the most net sales?
Reading Day of Week and Hour of Day together against Net Sales shows the specific windows worth your budget, not just the best day in isolation. A day can rank first overall while most of its revenue lands in a two or three hour band. Once you know the real window, you can schedule paid ads, email, and SMS to hit shortly before it rather than spreading spend evenly across the day.
Is a high-revenue day driven by one peak hour or by steady demand?
Hold a single Day of Week and read Net Sales across every Hour of Day. Two days can earn the same total but behave very differently: one spikes in a single hour, another sells steadily from morning to night. A sharp spike suggests a flash-style window to defend with inventory and staffing, while a broad plateau calls for all-day coverage. Treating them the same over-allocates effort to one and starves the other.
Do weekday and weekend buyers shop at different times?
Compare the shape of the Hour of Day curve on weekdays against weekend days. When weekday revenue clusters around lunch and evening but weekend revenue stretches across the afternoon, one email send-time cannot serve both. This split is a signal to set different send-times and different support hours by day type instead of using a single daily schedule.
THE ANALYST'S READ: The Signal Most Merchants Miss
Because every value here is pooled across the whole date range, a one-off event can masquerade as a recurring pattern. A single Black Friday sitting inside a short range can make "Friday, evening" look like a permanent hot window when it was really one campaign day. Before you commit ad budget or staffing to a window, check whether it holds across several weeks or collapses once you widen the range or exclude promo periods. The true baseline rhythm is the one that repeats. It is also worth remembering the report ranks windows by Net Sales, so a window that is genuinely busy by order volume can look weaker if a few refunds landed in it. If a window's timing feels right but its revenue looks low, add order count and confirm before you act.
How Can You Automate the Shopify Weekly Sales Pattern Report?
Open the pre-made Weekly Sales Pattern in Report Pundit. The columns are already set, so you save it and it is ready. To build your own version, add the four fields in Custom Reports, set your date range, apply any filter you need, and save.
From there you can schedule it to email automatically on a daily, weekly, or monthly cadence, so the pattern refreshes without rebuilding it. Export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive. You can also auto-send it to your team, your VA, or your accountant on the same schedule.
Frequently Asked Questions
What does the Shopify Weekly Sales Pattern report measure?
It measures net sales grouped by hour of day and day of week. Rather than tracking revenue forward through the calendar, it pools every sale by weekday and hour so you see the repeating times when customers buy.
How is this different from the Shopify Sales Over Time report?
Sales Over Time shows revenue day by day across the calendar, so you see trends, growth, and dips over a period. Weekly Sales Pattern collapses that same activity into recurring weekday and hour windows, so you see the rhythm rather than the timeline. Use Sales Over Time to track movement, and Weekly Sales Pattern to time actions.
Why does the report use net sales instead of total sales?
Net sales is gross sales minus discounts and returns, so each window reflects the product revenue you actually kept, not the headline figure before adjustments. That makes windows comparable without shipping and tax inflating some hours over others.
Does the report show order counts or only revenue?
The pre-made version shows Net Sales for each window, not order count. If you want to know whether a hot window is a few large orders or many small ones, you can customize the report to add an order count field.
Can I schedule the Shopify Weekly Sales Pattern report to run automatically?
Yes. You can schedule it to email on a daily, weekly, or monthly cadence and export it to Excel, CSV, PDF, Google Sheets, or Google Drive, so the current pattern reaches you and your team without manual work.