Use case for Mixtable Analytics Spreadsheet
Net sales, orders, average order value, discounts, and refunds for every Shopify Market you sell in, using the market Mixtable infers from each order and your Markets setup. See which countries earn their setup cost.
Sales by Market - Acme Apparel From Shopify Trusted by thousands of Shopify stores
What you can do
Mixtable's reporting worksheets compare your Shopify Markets on the metrics that decide international strategy, using the market inferred primarily from each order's shipping or billing country.
Order count, gross and net sales, discounts, refunds, and average order value for every Shopify Market you have set up.
The Sales by Market template builds the whole comparison in one step, using your store's own Markets list.
Filter supported sales metrics by customer country when a market spans many countries and you need the finer split.
AOV, discount amounts, and refund amounts per market show whether a region is healthy or just busy.
Fixed and rolling date ranges track how a newly opened market grows month over month.
Compute share of revenue per market, growth rates, or refund ratios, like any spreadsheet.
Reporting worksheets cover supported metric and filter combinations. These are the core metrics for Markets analysis.
In the spreadsheet
Market Comparison - Q2 From Shopify International selling creates a comparison problem: each market has its own currency presentation, pricing, and noise. The Sales by Market template computes the same store metrics per market, using the market Mixtable infers from order country data and your Markets setup.
Guide: Sales by Market template EU Market - By Country From Shopify A market like the European Union hides a lot of variation. The customer country filter computes supported sales metrics for a single country, so you can see which members of a market actually buy, and which ones just add shipping complexity.
Guide: Go country by country Market Health - Q2 From Shopify Revenue alone flatters young markets. AOV, discount amounts, and refund amounts per market tell you whether a region buys at full price and keeps what it buys, or whether growth is rented with promotions and paid back in returns.
Guide: Shopify Markets sales analytics EU Prices - Edit Side Sync 2 changesPreview Market analytics usually ends with a pricing or content decision. With Mixtable Spreadsheet Editor, you can make that change right there: market-specific prices and translations are editable in worksheets in the same spreadsheet, with every change previewed before it syncs to Shopify.
Guide: Edit market pricesCompare
Shopify Markets runs your international selling. Here is how the options compare for judging it.
| Analysis task | Mixtable | Shopify analytics | Exporting to Excel | BI platforms |
|---|---|---|---|---|
| Same metrics for every market | Yes, one row each | Yes, in reports | Manual country mapping | Yes, after modeling |
| Country-level splits inside a market | Yes, country filter | Partially | Manual pivots | Yes, after modeling |
| AOV, discounts, and refunds per market | Yes, same sheet | Across reports | Manual joins | Yes, after modeling |
| Share and growth formulas per market | Yes, it is a spreadsheet | No | Yes, manually | Query languages |
| Edit market prices where you analyze them | Yes, same spreadsheet | Separate screens | No | No |
| Stays current without re-exporting | Yes, dynamic ranges | Yes | No | Yes, via pipelines |
| Setup time | Minutes, from a template | None | Every single time | Days to weeks |
Comparison reflects typical Markets analysis workflows. Market attribution is inferred from the order's country; Mixtable analytics covers supported metric and filter combinations.
Getting started
No exports, no pipelines. Your Markets setup is the starting point.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
The template builds one row per Shopify Market with sales, discounts, refunds, and AOV.
Compare a quarter, a season, or keep a rolling window that updates itself.
Use the customer country filter where a market is too broad to act on.
Add share and growth formulas, then adjust market prices or translations in the same spreadsheet.
Questions
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open the Sales by Market template. Each of your Shopify Markets becomes a row with order count, gross and net sales, discounts, refunds, and average order value, live from your store.
Mixtable infers the market primarily from the order's shipping country, with billing country and other order details used as fallbacks or tie-breakers against your Shopify Markets setup. This is an analytical estimate, not Shopify's recorded routing, and an ambiguous order can remain unassigned.
Yes. The customer country filter computes supported sales metrics for a single country, which is how you split a multi-country market like the EU into its real contributors.
Yes. AOV is one of the per-market metrics, alongside discounts and refunds, so you can judge whether a market is healthy rather than just large.
Yes. Fixed date ranges compare periods precisely, and rolling windows like last 30 days keep a live view of the ramp without rebuilding anything.
No, and the two views complement each other. Markets answer where orders come from geographically; channels answer how they were placed, online store, POS, or apps. Mixtable has a separate view for channels.
Metrics are reported in your store's currency, the same way Shopify reports store-level analytics, so markets are comparable in one unit instead of a mix of local currencies.
Yes. With Mixtable Spreadsheet Editor, market-specific prices and compare-at prices are editable in bulk in the same spreadsheet, and translations for international storefronts can be managed there too, with changes previewed before syncing.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and compare every Shopify Market on the same numbers.
