Shopify sales by market, in a 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.

Everything you need to analyze Shopify Markets

Mixtable's analytical 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.

One row per market

Order count, gross and net sales, discounts, refunds, and average order value for every Shopify Market you have set up.

A ready-made template

The Sales by Market template builds the whole comparison in one step, using your store's own Markets list.

Country-level detail

Filter supported sales metrics by customer country when a market spans many countries and you need the finer split.

Market health, not just size

AOV, discount amounts, and refund amounts per market show whether a region is healthy or just busy.

Watch a market ramp

Fixed and rolling date ranges track how a newly opened market grows month over month.

Formulas on top

Compute share of revenue per market, growth rates, or refund ratios, like any spreadsheet.

Every market, same metrics, one sheet

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.

  • Order count, gross sales, discounts, refunds, net sales, and AOV per market
  • Markets come from your own Shopify Markets setup
  • Sort by any metric to rank regions
  • Share-of-revenue is one formula away
Compare your markets

When the market is too big, go by country

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.

  • Supported order-backed metrics filtered by customer country
  • Split a multi-country market into its real contributors
  • Compare neighboring countries before opening a dedicated market
  • Combine country and date filters freely
Go country by country

Is the new market healthy, or just busy?

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.

  • Average order value per market
  • Discount amounts show where growth depends on promotions
  • Refund amounts and counts show where products come back
  • Watch the ratios move as the market matures
Check market health

From market analysis to market prices, one spreadsheet

Market analytics usually ends with a pricing or content decision. Mixtable handles those too: market-specific prices and translations are editable in worksheets in the same spreadsheet, with every change previewed before it syncs to Shopify.

  • Edit market-specific prices and compare-at prices in bulk
  • Manage translations for international storefronts
  • Analytics columns stay read-only analysis views
  • Price and content edits sync only when you approve them
Edit market prices

The market metrics you can put in a worksheet

Analytical worksheets cover supported metric and filter combinations. These are the core metrics for Markets analysis.

Net sales per market Gross sales Order count Average order value Discount amounts Refund amounts Market filter Customer country filter Fixed date ranges Rolling date ranges Share-of-revenue formulas Month-by-month layouts

Mixtable vs other ways to analyze Shopify Markets

Shopify Markets runs your international selling. Here is how the options compare for judging it.

Analysis taskMixtableShopify analyticsExporting to ExcelBI platforms
Same metrics for every market Yes, one row each Yes, fixed 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.

From install to a markets report in minutes

No exports, no pipelines. Your Markets setup is the starting point.

1

Connect your store

Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.

2

Open Sales by Market

The template builds one row per Shopify Market with sales, discounts, refunds, and AOV.

3

Set the date range

Compare a quarter, a season, or keep a rolling window that updates itself.

4

Drill into countries

Use the customer country filter where a market is too broad to act on.

5

Decide and act

Add share and growth formulas, then adjust market prices or translations in the same spreadsheet.

Shopify Markets analytics questions

How do I see sales for each Shopify Market?

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.

How does Mixtable know which market an order belongs to?

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.

Can I break a market down by country?

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.

Can I compare average order value across markets?

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.

Can I track a newly opened market over time?

Yes. Fixed date ranges compare periods precisely, and rolling windows like last 30 days keep a live view of the ramp without rebuilding anything.

Is this the same as sales by channel?

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.

Are the numbers converted to one currency?

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.

Can I fix market pricing based on what I find?

Yes. 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.

See which markets earn their keep

Open Mixtable for your store and compare every Shopify Market on the same numbers.