Measurement Planning
Ecommerce dashboard design
An ecommerce dashboard should help a team decide what to do today and explain what happened after the numbers settle. Start with decisions, definitions and data …
An ecommerce dashboard should make key store measures easy to scan, compare and investigate. Start with the decisions it must support, then set clear definitions, a visual hierarchy and useful drill-downs. A screen of impressive charts is less useful if nobody knows which figure to trust or who will act on it.
Designing an Effective Ecommerce Dashboard: A Step-by-Step Approach
- Identify the decisions the dashboard must supportAlign metrics with daily operational or strategic actions (e.g., inventory restock, campaign optimisation)
- Define each metric clearly with source, time zone and calculationEnsure transparency—e.g., specify whether 'sales' means gross or net revenue
- Separate leading indicators from confirmed outcomesUse traffic and stock levels as signals; use reconciled sales and returns as final measures
- Label report sources and methodologies explicitlyAvoid combining unlabelled totals from different systems like Shopify Analytics and Google Analytics
- Include drill-downs and ownership for actionable insightsEnable investigation from headline figures to specific products, channels or checkout steps
Separate operating signals from outcomes
See the dedicated guide on separating leading indicators from confirmed outcomes.
| Question | Suitable view | Caution |
|---|---|---|
| Is the store trading normally? | Orders, sales and payment or checkout incidents | Same-day data may change |
| Is a product at risk? | Demand, stock and fulfilment capacity | Traffic is not a sale |
| Did a change help? | Comparable periods and affected products | Seasonality and measurement changes matter |
| Is the result final? | Reconciled sales, returns and finance view | Different reports can count differently |
Shopify notes that sales reports can differ across reports, exports or dashboards because of timing or reporting logic. Treat a difference as a reason to check each measure’s basis, rather than assume one dashboard is wrong.
Design for differences between reports
Shopify separates returns and refunds: sales reports include returns, while the Payments finance report includes refunds. If both appear in a dashboard, label them separately and state each report basis. Otherwise, readers may treat two different measures as competing versions of the same number.
The timing of a refund can also affect how a figure appears. Shopify says a pending refund can leave a positive amount in the Sales by channel report; when the refund is complete, the amount appears as negative. A visual treatment that identifies refund status and report helps readers interpret that change without mistaking it for an unexplained sales movement.
Comparisons between Shopify Analytics and another tracking service can differ for reasons beyond a dashboard calculation. Shopify identifies differences in how page reloads, unique visitors and sessions are counted, as well as reporting time zones; Google Analytics may not count visitors without JavaScript and cookies or those using blocking extensions. Name the system behind each view, and avoid combining unlike counts into one unlabelled total.
Shopify Sales Reports vs. Payments Finance Report: Key Differences
- ReturnsIncluded in Sales report
- RefundsIncluded in Payments finance report
- Refund Status ImpactPending refund shows as positive; completed refund appears as negative in Sales by channel report
- Tracking MethodologyGoogle Analytics may not count visitors without JavaScript, cookies or those using blocking extensions
Using Shopify Analytics vs. Google Analytics: Pros and Cons
- Pros of Shopify AnalyticsTightly integrated with store operations; accurate for checkout and payment data; consistent reporting logic for sales and refunds
- Cons of Shopify AnalyticsMay not capture all user interactions if JavaScript is blocked; limited to Shopify ecosystem
- Pros of Google AnalyticsBroader tracking of user behaviour across websites; useful for marketing attribution and funnel analysis
- Cons of Google AnalyticsCan undercount unique visitors due to ad blockers, no cookies, or disabled JavaScript; timing differences in reporting
Make the definition visible
Every headline metric needs a source, time zone and calculation. Decide whether “sales” means orders placed, paid revenue, net sales after returns or another finance measure. Display the chosen definition near the number. Do not place two similar figures side by side without explaining their different jobs.
Use a drill-down from a red signal to the product, channel or checkout step that can be investigated. Add an owner and an action threshold where a decision is expected.
Review the dashboard after a trading incident. Did its labels and drill-downs help the team investigate the issue? Refine them where needed.
Key Ecommerce Dashboard Metrics and Definitions (Shopify)
- Orders
- Number of orders placed on a given date
- Gross Sales
- Product price × quantity before taxes, shipping, discounts, or sales reversals
- Average Order Value (AOV)
- Gross sales (excluding adjustments) − discounts (excluding adjustments) ÷ number of orders
- Gross Profit
- Net sales − product cost
Match each view to its comparison
Shopify sales reports include views of sales over time, by product and by channel. Use these as distinct ways to inspect a result: a time-based view shows movement across periods, while product and channel views reveal how the total is distributed. Label the grouping clearly so readers know what each chart compares.
For a layout, give the overall measure a clear position, then place its time trend and breakdowns nearby. Keep the selected period and grouping visible in the view title or control, rather than making the reader infer them from the chart. Shopify also provides average order value over time, which can be presented as its own trend rather than mixed into a sales total.
Give headline figures a usable glossary
Use the report’s own terminology in labels and supporting text. Shopify defines orders as the number placed on a given date; gross sales are product price multiplied by quantity before taxes, shipping, discounts and sales reversals. Gross sales include pending, cancelled and unpaid orders, but not test or deleted orders, so the label should not imply that it means paid revenue.
If the dashboard includes average order value, show how it is calculated rather than treating it as self-explanatory. Shopify’s definition uses gross sales, excluding adjustments, minus discounts, excluding adjustments, divided by the number of orders. This helps readers distinguish it from a sales total and understand which parts of the calculation affect it.
A profit measure also needs a clear name and basis. Shopify defines gross profit as the total profit made on the product during the report period, calculated by subtracting product cost from net sales. If readers see both sales and profit figures, keep their labels distinct and make the calculation available beside the figure or in a glossary.
Explain adjustments that can change a reported amount. Shopify defines discounts as line-item discounts plus the order-level discount share; discounts applied to an entire order are proportionally applied across their sales. Sales reversals are order adjustments that result in a negative monetary value, so a negative figure should not be presented without a label that clarifies what it represents.
In this guide
- Separating leading indicators from confirmed outcomesProduct-page visits, add-to-cart events and checkout starts can warn of a change before sales settle. They are signals to investigate, not sales in another name.
- Showing data freshness in a store reportA report without an update time can make yesterday’s incomplete data look final. Show when each source was last processed and whether the current period may still change.
- Removing metrics that do not inform a trading decisionEvery daily dashboard metric should answer a question or trigger an action. If it only fills space, move it to a detailed report or retire it.
