Shopify Sales by Market Spreadsheet Template

The Sales by Market template creates a Pivot Table worksheet with one row per Shopify Market. It gives international and regional commerce teams a quick way to compare demand, discounting, refunds, and order value across the markets where customers placed orders.

What Market reporting tells you

Selling internationally means running several businesses at once, each with its own pricing, currency, shipping costs, and expectations. A single worldwide total hides all of it.

Use it to see:

Which Markets are large enough to justify local pricing, translation, or paid ads
Which look strong on sales but weaken once discounts and refunds are counted
Where average order value is high enough to absorb international shipping
Whether a Market you opened months ago has produced anything at all

For deeper Market analysis, including trends over time, see Shopify Markets Sales Analytics.

Metrics included

The worksheet contains:

Market
Total Order Count
Total Gross Sales
Total Discounts
Total Refund Amount Excluding Tax
Total Net Sales
Average Order Value

The metrics initially cover all time.

Create the Sales by Market spreadsheet

Install Mixtable Analytics Spreadsheet
Open your Mixtable dashboard and click Create spreadsheet at the top of the page. If you haven't created a spreadsheet yet, click Browse all templates below the dashboard's suggestions instead. In the Create spreadsheet window, find Sales by Market under Analytics & Reporting, or type its name in the search box, and click it. Mixtable creates the spreadsheet and fills it with data from your Shopify store.

Compare Shopify Market performance

Use the report to answer questions such as:

Which Shopify Markets generate the most orders and sales?
Which markets depend most heavily on discounts?
Where do refunds have the largest effect on retained revenue?
Which markets have the highest Average Order Value?
Are newer markets beginning to contribute meaningful order volume?

Total Gross Sales shows merchandise revenue before discounts and refunds. Total Net Sales shows the amount left after those adjustments. Looking at both helps distinguish strong demand from strong retained revenue.

Compare markets fairly

Large markets will usually lead on total sales simply because they process more orders. Add context before making decisions:

Compare Average Order Value alongside Total Order Count
Divide discounts by Gross Sales to compare promotion intensity
Divide refund totals by Gross Sales to compare refund impact
Use the same fixed date range for every market
Compare equivalent selling seasons when markets have different calendars

Market results can reflect currency, pricing, product availability, shipping options, tax rules, and local customer behavior. Treat the worksheet as a starting point, then investigate the operational reason behind a difference.

Add a market trend

The template compares cumulative market results. To see when performance changed, add a Time Series worksheet and choose Market under Break down by. Pick the Measure to track (Net Sales, Gross Sales, Orders Count, Net Quantity Sold, Total Refund Amount Excluding Tax, or Average Order Value), then choose By day, By week, By month, or By year under Time periods. A Market time series tracks one measure, so create one worksheet for each measure you want to follow.

You can also create Market sales mix from the ready-made Reporting worksheet library. Learn more in Shopify Markets Analytics.