What Is the Sales Over Time Report?
The Shopify Sales Over Time report groups your store's sales by calendar date, giving you one row per day for the range you choose. Each row totals that single day's activity: how many orders came in and how those orders added up across gross sales, discounts, returns, net sales, shipping, tax, duties, and total sales.
Because the report is aggregated to the date, it is a daily trend line, not an order list. One row is a whole day, not a single order. That is the main thing to keep straight: if you need to see individual orders arranged in time, that is the Orders Over Time report. Sales Over Time answers the day-level question instead, which day earned what.
Merchants reach for this report when the question is about consistency and direction over a stretch of days: whether revenue is holding steady, climbing, or slipping, and which specific dates drove the change. It reads the money side of each day rather than the fulfillment or product side.
Which Fields Are Included in the Sales Over Time Report?
These columns let you judge both how busy a day was and how much of that day's revenue actually stuck after discounts and returns.
You can adjust the pre-made report by adding, removing, or reordering columns and by setting any date range you want to study, so the daily view matches the way you track revenue.
Important Insights You Can Find in This Report
Was a strong month built on a few big days or on steady daily demand?
Scan the Total Sales column down the range and watch how Order Count moves with it. A month can hit the same total two very different ways: a handful of spike days carrying everything, or consistent demand across most days. Concentration in a few dates usually ties back to a promotion, a drop, or a payday pattern, and it means your revenue is fragile if those triggers don't repeat. Steady daily demand is safer to forecast and stock against. Knowing which one you have changes how confidently you can plan the next period.
On your highest-revenue days, is Net Sales keeping up with Gross Sales?
Line up Gross Sales and Net Sales on your best days and see how far apart they sit. When a big Gross Sales day shows a much smaller Net Sales figure, the day's Discount and Returns columns are eating the difference. That is common on promotion days, and it tells you whether a busy day was also a profitable one. If your top revenue dates are consistently your widest gross-to-net gaps, the promotions driving traffic may be buying volume you keep very little of.
Do the dips fall on predictable dates rather than at random?
Because the rows are ordered by date, you can read the sequence for repeating soft spots: the same weekday sagging each week, a slump right after every promotion ends, or a quiet stretch between paydays. A dip that lands in the same place repeatedly is a pattern you can act on with timing, scheduling a send or a promo to cover it, rather than a one-off you can only react to.
THE ANALYST'S READ: The Signal Most Merchants Miss
Watch what the Returns column is doing relative to the dates around it. In this report, a return is counted on the day the order is cancelled or refunded, not the day the original sale was made. So a date with very few orders can still show a meaningful Returns figure, and a heavy return day can quietly pull down Net Sales and Total Sales for a day that was otherwise ordinary.
This matters because it can make a good sales day look weaker than it was, or blur where a real problem started. If you see Net Sales soften on a date without a matching drop in Order Count or Gross Sales, the returns landing that day may trace back to sales from an earlier stretch, not to that day's performance. It is worth checking whether return spikes cluster after a specific promotion, product, or shipping window a week or two earlier. Reading returns as their own timeline, rather than assuming they belong to the day they appear on, keeps you from misreading a normal selling day as a bad one.
How Can You Automate the Sales Over Time Report?
Open Report Pundit, open the pre-made Sales Over Time report, and press Save. The columns are already set. From there you can schedule it to email automatically on a daily, weekly, or monthly cadence, so the daily trend arrives without you rebuilding it. The same schedule can auto-send to your team, VA, or accountant.
You can also export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive so the numbers land where you already work.
Frequently Asked Questions
What does one row in the Sales Over Time report represent?
One row is one calendar date. Every value in that row, from Order Count to Total Sales, is the combined total for that single day, not an individual order.
How is Sales Over Time different from Orders Over Time?
Sales Over Time gives you one aggregated row per date, so it reads as a daily revenue trend. Orders Over Time keeps a row for each order (with Order ID, Order Name, and quantity) arranged in time. Use Sales Over Time for day-level totals and Orders Over Time when you need to see the individual orders behind a day.
How is Sales Over Time different from the Last 30 Days Sales Summary?
They share almost the same daily columns, but Sales Over Time lets you pick any date range you want, while the Last 30 Days Sales Summary is locked to a rolling 30-day window. Use the summary for a fast recent-performance check, and Sales Over Time when you want to compare longer stretches or specific historical periods.
Does the Sales Over Time report break sales down by hour?
No. This report is grouped at the date level, so the smallest unit is a full day. If you want to see which hours or weekdays sales concentrate in, that is the Weekly Sales Pattern report.
Why can the Returns column show a value on a date with almost no orders?
Returns are counted on the day an order is cancelled or refunded, not the day the sale was originally placed. So a quiet order day can still carry returns that trace back to sales from earlier in the range.
Can I schedule the Sales Over Time report to arrive automatically?
Yes. You can set the pre-made report to email on a daily, weekly, or monthly schedule, and send it to your team or accountant on the same cadence, so the day-by-day view reaches your inbox already built.