Shopify Sales Dashboard: How to Build One and What to Track
A Shopify sales dashboard gives you one view of your store’s key sales numbers, such as total sales, orders, average order value and sales by channel or product. You can build one inside Shopify by customizing the Analytics overview dashboard, then use Shopify’s sales reports for deeper detail, or connect your data to Google Sheets or a BI tool when you need custom calculations. A good dashboard answers your daily questions at a glance: how much you sold, where it came from and whether performance is improving. Choosing the right metrics and tools keeps it useful instead of cluttered.
How to Set Up a Sales Dashboard in Shopify
Shopify’s Analytics overview dashboard is the quickest place to build a sales dashboard, because it already pulls in data from all your sales channels. You can add, remove, rearrange and resize metric cards, and group them into labeled sections that match how you review your business.
- Open Analytics. In your Shopify admin, go to Analytics to see the overview dashboard.
- Choose your metric cards. Add cards for the sales metrics you check most, such as total sales, orders, average order value and sales by channel, and remove cards you rarely use.
- Organize sections. Group cards into sections, such as sales, customers and marketing, and resize the most important ones so they stand out.
- Set a date range and comparison. Pick the period you want to review and compare it with a previous period to spot changes.
- Add targets. Set metric targets for goals such as monthly sales, so you can see progress without calculating it yourself.
The overview dashboard updates within about a minute and includes automatically generated insights. That makes it well suited to daily check-ins, while reports and external tools handle deeper analysis.
Sales Metrics to Include in Your Dashboard
The best metrics are the ones that drive decisions for your store. Many sales dashboards start with these core numbers, defined the way Shopify reports them:
| Metric | What it measures | Why it matters |
|---|---|---|
| Gross sales | Product price multiplied by quantity, before discounts, sales reversals, taxes and shipping | Shows demand before deductions |
| Discounts | Line item discounts plus each order’s share of order-level discounts | Reveals how much promotions cost you |
| Sales reversals | Negative adjustments such as returns, cancellations and order edits | Highlights return and cancellation problems |
| Net sales | Gross sales minus discounts and sales reversals | Gives a truer picture of product revenue |
| Total sales | Net sales plus taxes, duties, shipping charges and fees | Matches the full value customers were charged |
| Orders | The number of orders placed in the period | Tracks sales volume separately from value |
| Average order value | The average value of each order | Shows the impact of bundles, upsells and free shipping thresholds |
| Sales by channel | Sales split by online store, POS, marketplaces and other channels | Shows which channels deserve more investment |
| Sales by product | Sales and units for each product or variant | Identifies best sellers and slow movers |
| Conversion rate | The share of sessions that end in an order | Connects traffic to sales performance |
If you track profitability, add gross margin once product costs are entered in Shopify. New versus returning customer sales and sales by location are also useful when you’re focused on retention or regional growth. Keep in mind that sales reports track the value of goods, not payments received. Sales reversals also appear on the day they’re processed rather than the day of the original order, so a large return can lower a later period’s figures.
Use Shopify Sales Reports for Deeper Analysis
When a dashboard card raises a question, Shopify’s sales reports help you find the answer. Default reports include total sales over time, by product, variant, vendor, discount code, referrer, billing location, currency and sales channel, plus net sales by channel, sales by customer name and average order value over time. You can filter reports, change time ranges and edit columns, then save the changes as a custom report. Custom reports can also start from an empty exploration, or you can ask Sidekick, Shopify’s AI assistant, to generate a report from a plain-language request. Reports can be exported for analysis in spreadsheet programs. Some reports have extra requirements, such as sales by currency needing Shopify Payments, and bundle or subscription reports only showing data when you use Shopify’s own bundle or subscription apps.
When to Build an External Sales Dashboard
Shopify’s dashboard covers most daily needs, but an external dashboard helps when you want calculations Shopify doesn’t offer, data from other platforms or a view you can share without giving access to your store. Google Sheets, Excel, Looker Studio and Power BI are common choices.
| Approach | How it works | Best for | Watch out for |
|---|---|---|---|
| Manual CSV export | Export reports or orders from Shopify, paste them into a raw data sheet and build charts with formulas | Weekly or monthly reviews on a budget | Takes time to refresh and is easy to forget |
| Spreadsheet connectors | Tools such as Coupler.io, Coefficient and Porter Metrics sync Shopify data into Google Sheets or Excel on a schedule | Automated dashboards in a familiar spreadsheet | Refresh options and pricing vary by tool and plan |
| BI and visualization tools | Connect synced data to Looker Studio, Power BI or Tableau for interactive dashboards | Larger stores and teams that blend many data sources | Requires more setup and data modeling |
Some connector tools offer ready-made Shopify sales templates for Google Sheets. These typically include monthly sales, orders, average order value, top products and sales by country, with filters you can adjust.
How to build a sales dashboard in Google Sheets
A spreadsheet dashboard works best when raw data, calculations and charts live on separate tabs. Follow this structure:
- Create three tabs. Add a raw data tab, a metrics tab and a dashboard tab.
- Bring in your data. Paste exported CSVs or connect a sync tool, choosing data such as orders with line items, products and inventory.
- Choose an import mode. Replace the data on each refresh for a clean snapshot, or append new rows to build history.
- Calculate metrics separately. Use formulas such as
SUMIFS,COUNTIFSandQUERYon the metrics tab, so refreshes don’t overwrite your work. - Build visuals. Add scorecards for totals, line charts for trends, bar charts for products and a map for locations.
- Schedule refreshes. Match the refresh frequency to how often you make decisions, such as daily for busy stores or weekly for smaller ones.
Before relying on a new dashboard, compare its totals with Shopify for the same date range. Small differences usually come from how refunds, shipping or taxes are handled, so align your formulas with Shopify’s definitions.
Tips for a More Useful Sales Dashboard
A dashboard only helps if people actually use it. These habits keep it focused and trustworthy:
- Start with questions. Decide what the dashboard must answer quickly, then choose metrics that answer those questions.
- Keep the overview short. Limit the main view to a handful of key charts and move detail into reports or drill-down tabs.
- Always compare periods. Show numbers against the previous period or the same period last year, so changes stand out.
- Use consistent definitions. Agree on whether your team reports gross, net or total sales, and label charts clearly.
- Protect your data. Lock raw data tabs in spreadsheets so formulas don’t break when data refreshes.
- Review regularly. Check daily numbers for problems, weekly trends for planning and monthly results for strategy.
Conclusion
A Shopify sales dashboard turns your store data into a quick, reliable view of how sales are performing. Starting with Shopify’s customizable overview, adding reports for detail and moving to an external dashboard when you need more flexibility gives you the right level of insight as your store grows. We hope this guide helps you build a Shopify sales dashboard that supports better decisions.
