A store sales dashboard is a handful of agreed numbers from a single source of truth: net sales, number of orders, average order value, returns and traffic sources. The order of work is definitions first, then data, and the tool last. If every Monday you stitch together numbers from your store panel, marketplaces and ads in Excel, and before the holiday season you want to see sales daily in one place, below you will find these three steps in order.
Table of contents
What should a store sales dashboard show?
The first screen only needs a few metrics, and the rest can go lower down as details. This set works well to start with:
- net sales, meaning revenue after returns and coupons are deducted,
- number of orders,
- average order value,
- returns,
- traffic sources and conversions,
- ad spend.
It is best to base your definitions on the WooCommerce Analytics reports documentation. Gross Sales is the selling price times quantity, excluding returns, coupons, taxes and shipping. Net Sales is Gross Sales minus returns and coupons. Total Sales goes one step further and adds taxes and shipping. Average Order Value is Net Sales divided by the number of orders. One important detail: a return shows up as a negative value on the day of the return, not on the day the order was placed.
Definitions first: what “sales” means in your company
Before you build a sales dashboard, settle three things. Do you count net, or with shipping? By order date or by payment date? And what do you do with returns? The store panel, GA4 and accounting will show different numbers. That is normal, since each of them measures something else. The trouble starts when nobody knows which version ended up in the report. So write a short definitions cheat sheet once and pin it to the dashboard. Then everyone reads the numbers the same way.
What data should an online store sales report combine?
A complete online store sales report pulls data from the store, marketplaces, invoices, traffic and ad costs. In practice, that means five sources:
- orders from WooCommerce,
- marketplace orders gathered in one place, for example because a WooCommerce and BaseLinker integration merges them with the store,
- invoices from the ERP system,
- traffic and conversions from GA4, provided that GA4 setup in your store counts purchases correctly,
- ad campaign costs.
They are tied together by a shared key: order number, date and sales channel. Every number needs one source of truth, otherwise you will count the same order twice: once from BaseLinker and once from the store.
Three dashboard levels: from the WooCommerce panel to a custom app
You choose the level based on the number of sales channels and how fresh you need the numbers to be.
Level 1: the WooCommerce Analytics panel
If you sell mainly through your own store, the built-in panel is usually enough. It has filters, segmentation, CSV export and a dashboard you can set up around your key metrics.
Level 2: a Data Studio store dashboard
With several channels, Data Studio fed by exports or a spreadsheet works well. According to the Google Data Studio documentation, in April 2026 Looker Studio went back to this name, the old address redirects to the new domain, and existing reports do not need to be touched. The tool is free. You bring data in via an export, a spreadsheet, a database or a connector.
Level 3: a report in your own system
When the numbers need to refresh on their own and connect with stock levels, the report moves into a custom application, and data flows into it through system integration via API.
A sales dashboard in Excel is a good interim stage where it is easy to agree on definitions. With daily refreshes, though, it takes a lot of manual work.
Comparison: which level to choose
The simplest way to choose is by data sources and the time you can realistically spend on maintenance.
| WooCommerce panel | Data Studio | Custom application | |
|---|---|---|---|
| Data sources | store only | exports, spreadsheets, databases, connectors | all systems via API |
| Refresh | live in the store | depends on how data is fed in | automatic |
| Maintenance work | minimal | regular data updates | maintaining integrations |
| Best for | sales mainly in the store | several channels | many channels and a warehouse |
Why do the numbers in a dashboard not match?
Different definitions, dates and sources are usually to blame. The most common mismatches:
- order date instead of payment date,
- returns booked on a different day than the order,
- tax and shipping included in Total Sales,
- cancelled and unpaid orders,
- attribution in GA4 different from the store panel,
- different time zones across systems.
Next to every number on the dashboard, note where it comes from and how you calculate it.
Sales dashboard before the holiday season
Before the peak, switch to a daily view and a comparison with the same period a year earlier. Already in November, set the date range to the whole season, the interval to daily and the metrics broken down by sales channel. Organic traffic is well complemented by monthly Search Console reports, because they show whether the visibility of seasonal categories is growing.
Start by writing down the definitions, then connect the sources, and only then choose the tool level. A well-built sales dashboard ends the Monday ritual of stitching panels together: one place and the same numbers for everyone, calculated by the same rules.
Frequently asked questions
Is a sales dashboard in Excel enough?
To start with, yes, especially for agreeing on definitions and the layout of metrics. With several channels and a daily view, however, manual copying takes a lot of time and mistakes come easily. At that point Data Studio or a report fed via API works better.
Why do sales in WooCommerce differ from GA4?
Because the two systems count different things at different moments. The store saves orders in its database. GA4 counts events in the browser and assigns them to channels according to its own attribution rules. On top of that come returns, cancellations and blocked tracking scripts.
How many metrics should go on the first screen of a business dashboard?
A few metrics that answer one question are enough: how are sales going? Put breakdowns by product, category and campaign lower down, so the sales dashboard stays easy to read.






