Shopify Sales Tracker in Google Sheets: Daily Sales, Trends, Alerts

Shopify Sales Tracker Without Context Is Useless

If your store did $5,000 today, is that good? Depends on what it normally does, what changed recently, what promotion is running, and whether that revenue came from healthy orders or a coupon that should have been turned off.

I would rather see today beside the last 30 days. A slow day might be normal, a spike might be a problem, and a drop might be noise. Or it might be the first sign something broke. And thirty days of daily data is what puts the number in context without requiring a weekly sit-down to figure it out.

The Coupon That Looked Like a Good Day

I had a coupon stay active when it should have been turned off. Someone shared the deal, orders started flying in, and the daily sales number looked great.

Until I realized the product was moving at 70% off. Inventory draining, margin wrecked, and what looked like a strong sales day was actually a cleanup problem.

That is why the tracker should not show only revenue. I want discounts, units sold, top SKUs, order count, and refunds beside the daily number. The question is not "did revenue go up." It is: is this the kind of sales day we actually wanted?

The same logic applies to listing changes. When we updated a listing (images, title, pricing), I wanted to see the days before the change against the days after. Monthly reports are too slow for that and a single-day number is too thin. The tracker gives the before-and-after window.

Tuesday Is Slow. Here Is What To Do With That.

Your Shopify sales tracker follow a weekly rhythm. Sundays and Mondays run higher: people have more time, or they remembered something over the weekend and got around to buying it Monday. Tuesdays and Wednesdays run slower. That is ecommerce.

The better question is whether the slow days can be improved. And if your average Tuesday is $5,000, can a targeted promotion move it to $5,500 without killing margin?

So if you run a small offer on a naturally slow day, when other sellers are not advertising, you capture share at lower cost. Other sellers hit the same Tuesday dip and do nothing with it.

And your tracker makes the Tuesday floor visible. That specific number is buried in a weekly average.

The Fields Worth Including

Start with a daily row, not a giant dashboard.

The notes column matters more than people think. Without it, a sales dip three weeks from now has no explanation. With it, your account manager can see that the drop started the day after a price test and connect the dots without a meeting.

If you pull Shopify order data through our Shopify-to-Google Sheets connection, each row lands at the line-item level. The tracker aggregates those rows into one daily summary. The Shopify sales report article covers the column structure of the source data this tracker is built on top of.

Alerts That Tell You Where to Look

Bad alerts train people to ignore the tracker.

Google Sheets conditional formatting handles the visual version of this without scripting. Set vs_prior_7_day_avg to turn red below 75% and green above 115%. My account manager sees the color before reading a number. That is the entire alert system: no automation required, no false alarms, no drama on a normal slow Tuesday.

The point of an alert is to tell your team where to look. Not to create a crisis every time Shopify has a natural down day.

The Compass Your Account Manager Checks Every Morning

My account manager opens the tracker every morning. Not to celebrate a good day or panic over a bad one.

Just to check whether the store is still on course.

The compass analogy: if you check your direction every 30min on a long drive, a small drift is a small correction. Check every 5 hours and you could be completely off course.

The daily tracker is the same principle: small deviations caught early stay small.

What my account manager looks at first is how today compares to the same day last week, and whether the last seven days are trending in the right direction against the seven days before that. Those two comparisons answer whether to act or wait, without requiring a meeting.

Different Time Windows Answer Different Questions

Your daily tracker catches fires. It is not the only window that matters.

Your 30-day daily view is for short-term monitoring:

• a promotion launched
• a listing changed
• a campaign started

The daily view of the Shopify sales tracker shows what happened on the specific days around that event. This is the window that catches anomalies (like the 70% off coupon) before they become expensive.

Your weekly comparison is for mid-term momentum. A product down 12% week-over-week for three consecutive weeks is a different situation than a product that had one bad week. The weekly view shows the direction of travel, not just today's position.

Monthly comparison is for seasonality. Comparing this October to last October tells you whether the business is growing or just riding the seasonal wave. Monthly numbers absorb daily noise and show the real trend line.

The tracker in Google Sheets handles the first two windows well. Pulling 90 days of daily order data through the connection gives your team the rows to build whatever comparison window you need alongside the daily view.

When the Tracker Adds No Value

If you check Shopify once a week and that cadence fits your business, daily tracking adds overhead without payoff. Under roughly $30K a month in Shopify revenue, the signal-to-noise ratio of daily monitoring is low enough that weekly review is the right call.

We are the wrong call if you need automated alerts pushed to Slack or email when a threshold is crossed. Our connection pulls the data and a person opens the sheet and makes the call. If you need a system that pages someone automatically, that is a monitoring tool, not a Google Sheet.

If inventory is driving the daily sales pattern, the Shopify inventory management tab lives in the same workbook. A day where one SKU spiked can trigger a stock check without switching tools. If you need to understand which campaigns drove which orders alongside the daily revenue view, Shopify marketing attribution covers the UTM-level layer. If margin is part of the daily call (whether a promotional day actually paid off after cost), Shopify COGS tracking and Shopify PPC reporting sit alongside the tracker in the same workbook.

The tracker has one job: show whether something changed enough that your team should look. If you add enough fields to make it answer every question, it becomes the sheet nobody wants to open. Start with the daily row and add only what helps your team catch problems faster.