Interpret Shopify analytics by defining the metric, date basis, filters and attribution question before comparing totals. Keep order activity, sales reporting and payment movement distinct. Use the worksheet below to make a report reproducible, investigate differences and identify which conclusion the selected evidence can support before changing a campaign or judging the store’s performance.
What does the sales number actually include?
Open the report used for the decision and write its metric name exactly. Record the selected date range, time zone, filters and dimensions. Ask whether the business question concerns orders placed, product activity, payments received or another outcome. Select a report appropriate to that question before interpreting a large number on a dashboard.
Shopify gross sales are calculated before taxes, shipping, discounts and sales reversals. Documentation. Shopify gross sales include pending, cancelled and unpaid orders. Documentation. Shopify gross sales exclude test and deleted orders. Documentation. These definitions matter when someone treats a sales figure as money already received. Keep the report’s actual meaning in the working record and use the relevant payment evidence for a cash-receipt question.
Shopify defines net sales as gross sales less discounts and sales reversals. Documentation. Shopify total sales include taxes, duties, shipping charges and fees in addition to net sales. Documentation. Choose the definition that answers the intended business question and keep it consistent through the comparison. If one colleague uses net sales and another uses total sales, identify the difference before investigating a supposed missing transaction.
Why might two exports disagree?
Shopify sales reports and order exports use different reporting bases. Documentation. Shopify includes test orders in order exports but excludes them from sales reports. Documentation. Compare the underlying scope rather than assuming one file is wrong. Retain the original report names and export settings. A spreadsheet that renames both columns revenue can hide an important distinction that was visible in the source.
Shopify distinguishes returns in sales reports from refunds in the Payments finance report. Documentation. When a customer return or refund is relevant, identify which event the report records and when it appears. Keep the operational record and the payment record connected through an actual order reference. Avoid creating a single catch-all adjustment merely to make an unrelated report agree.
Grouping and date ranges can leave only part of an order and return in a report. Documentation. Shopify explains that changing report dimensions can change filter results. Documentation. Review the grouping and filters alongside the date range. A daily summary and an order-level view may answer different questions even when the start and end dates look the same. Record any changed settings before comparing the resulting totals.
An original report-definition worksheet
Use this practical checklist to document one recurring report or one investigation. Complete it with the actual report settings and evidence references. It is an original decision aid that makes a later comparison repeatable.
| Reporting field | What to record | Question before interpretation |
|---|---|---|
| Business question | Decision the report is intended to support | What would change because of this result? |
| Metric | Exact field name and definition | Which activity or value does it represent? |
| Time basis | Range, time zone and relevant event date | Are the compared periods genuinely aligned? |
| Filters | Included and excluded records | Which transactions can disappear from the view? |
| Dimensions | Order, product, channel or time grouping | How does grouping affect the selected question? |
| Attribution basis | Model and rule documented for the selected report | What relationship is being credited? |
| Comparison | Other report and its own definition | Is the comparison like-for-like? |
| Conclusion | Supported observation and remaining uncertainty | Which action is justified by the evidence? |
Attach a representative order reference to a discrepancy investigation. Trace it through the views under comparison and note which part of its history appears in each. This is often a more useful starting question than repeatedly exporting larger totals without understanding their definitions.
Preserve report revisions. If the team changes a filter or metric definition, record the change and its intended effect. A trend comparison across different definitions should remain visibly qualified in the working analysis rather than being presented as an uninterrupted series.
How should attribution be discussed?
Write the attribution question before choosing a channel comparison. Ask whether the business wants to understand the source credited by a particular report, the journey recorded for an order or the effect of a proposed marketing change. Keep those questions separate in the reporting brief.
For the selected report, request the documented model, included interactions and relevant reporting window. Record those details on the worksheet before interpreting a channel label as a complete explanation of the purchase. If the model or coverage is unclear, keep that part of the conclusion open and identify the documentation needed.
Compare the same attribution basis across the periods being assessed. If the definition changes, explain that change alongside the result. A useful report should let another person understand what was credited and under which rule, instead of relying on the analyst remembering how the dashboard was configured.
Keep a proposed campaign experiment distinct from an attribution observation. Define the intended change, the comparison and the evidence needed before concluding that a campaign caused a sales movement. The report-definition worksheet helps organise that decision without assigning unsupported causal meaning to a channel total.
Hypothetical example: a return falls outside the comparison
Imagine a team compares an order export with a sales report for a selected period. A relevant order was created earlier and later changed through a return or refund. The two files appear to disagree. This hypothetical example gives the investigation a concrete record to trace.
Locate the order reference and write its relevant event dates. Inspect the metric definitions in both views, then check whether each event falls inside the selected period and grouping. Retain the original files and record any settings changed during the investigation.
If the difference is explained by reporting scope, document that explanation against the order reference. If it remains unresolved, state the exact missing evidence and assign a follow-up. Avoid changing the working spreadsheet until its treatment of the source definitions is understood.
What should the business decision say?
Summarise the observation in terms of the defined metric, period and scope. Explain the action it supports and any evidence still needed. Keep payment settlement questions with the appropriate provider records rather than treating a sales report as a bank reconciliation.
For settlement boundaries, use Shopify payouts. Keep broader platform constraints with Shopify in Zambia. Discuss the store reporting brief through online stores and get started with the report definitions and business decisions you need to make.
By Spout Team. AI-assisted drafting by Codex using the linked primary documentation.