How to Build an Ecommerce Dashboard That Works

You have Shopify's dashboard. Google Analytics. Your Meta Ads manager. A QuickBooks login. Maybe a shipping dashboard too. Each one shows you a piece of the picture, and none of them show you the whole thing.

The result: you check five tools every morning, mentally combine the numbers, and still feel uncertain about whether your business is actually doing well.

A good ecommerce dashboard fixes this. It puts your most important numbers in one place, updates automatically, and tells you when something needs attention. Here is what it should include and how to build one.

What a Good Dashboard Answers

Before picking metrics, think about the questions you ask every day:

• Did we make money today? (Revenue minus all costs)
• Are ads working? (ROAS by platform, total ad spend)
• Is cash running low? (Cash balance, cash runway)
• What products are selling? (Top sellers, margins by product)
• Is anything broken? (Failed payments, shipping delays, high refund rates)

If your dashboard does not answer these five questions at a glance, it is not working.

The 4 Sections Every Ecommerce Dashboard Needs

1. Financial Overview

This is the top section. At a glance you should see:

• Revenue (today, this week, this month, with comparison to previous period)
• Net profit (revenue minus ALL costs, not just COGS)
• Cash balance (how much money you have right now)
• Cash runway (how many months you can operate at the current burn rate)

Most ecommerce platforms only show revenue. The profit number requires connecting your accounting data (QuickBooks or Xero), because only your accounting software knows about rent, payroll, software costs, and other operating expenses that Shopify never sees.

2. Ad Performance

This section answers "are my ads working?" without logging into three platforms.

• Total ad spend (across Meta, Google, TikTok combined)
• Blended ROAS (total revenue divided by total ad spend across all platforms)
• Ad spend as percentage of revenue (is it sustainable?)
• Per-platform breakdown (which platform performs best)

3. Product and Customer Health

This section tells you what is selling and who is buying:

• Top products by revenue and margin (not just revenue, margin matters more)
• Average order value (trending up or down?)
• Repeat purchase rate (are customers coming back?)
• Customer acquisition cost (how much does each new customer cost?)

The danger of only looking at top products by revenue is that your highest-selling product might have the lowest margin. If you are spending ad dollars promoting a product that barely breaks even, you are busy but not profitable.

4. Alerts and Action Items

This is what separates a useful dashboard from a data dump. Alerts tell you when something needs attention:

• Revenue dropped more than 20 percent compared to the same day last week
• A product's margin dropped below your threshold
• Ad spend exceeded its budget
• Cash runway dropped below 3 months
• A shipping delay rate spiked

Without alerts, you have to manually scan every number every day and hope you catch the problems. With alerts, the dashboard tells you what to focus on.

Common Dashboard Mistakes

Showing Too Many Numbers

If your dashboard has 40 metrics, you do not have a dashboard. You have a spreadsheet with better formatting. Limit the main view to 8 to 12 key metrics. Put everything else behind a click.

Not Including Costs

A revenue-only dashboard gives you a false sense of security. "We did $50,000 this month!" means nothing if you spent $45,000 to make it happen. Always show revenue alongside costs and profit.

Updating Manually

If you have to copy numbers from Shopify into a Google Sheet every morning, you will stop doing it within two weeks. A dashboard must update automatically from your data sources.

No Time Comparison

A number without context is useless. "$12,000 in revenue today" means nothing unless you know whether that is up or down from last week, last month, and last year. Always show comparison periods.

Mixing Vanity Metrics with Business Metrics

Instagram followers, website sessions, and email open rates are interesting but they do not tell you if you are making money. Keep vanity metrics out of your financial dashboard. They belong in a separate marketing dashboard.

How to Build One

Option 1: Spreadsheets (Free, High Effort)

You can build a dashboard in Google Sheets that pulls from Shopify's export files, ad platform CSVs, and your accounting exports. This is free but requires manual updates and breaks whenever a data source changes its format.

Best for: Very early-stage stores with one sales channel and a tight budget.

Option 2: BI Tools (Moderate Cost, Technical Setup)

Tools like Looker Studio (free) or Metabase (open source) can connect to databases and APIs to create custom dashboards. The upfront setup requires technical knowledge, and maintenance is ongoing.

Best for: Businesses with a data-savvy team member who can build and maintain custom integrations.

Option 3: Purpose-Built Ecommerce Dashboards

Tools built specifically for ecommerce connect to your platforms out of the box and display the metrics that matter for store owners. No setup required beyond connecting your accounts.

Nummbas takes this approach: you connect your ecommerce platform, ad accounts, accounting software, and operations tools, and it builds your financial dashboard automatically. It includes the four sections described above (financial overview, ad performance, product health, and alerts) plus AI-powered insights that explain what your numbers mean.

Best for: Store owners who want a ready-made dashboard that covers finances, ads, and operations without building anything custom.

Start With the Right Questions

The metrics you track should come from the questions you need answered, not from what the tools happen to show you. Start with the five questions at the top of this guide, build a dashboard that answers them, and ignore everything else until those answers are clear.