Filter Shopify Analytics by Customer Country

Use the Customer’s country analytics filter when you want a metric to count only the orders placed by customers based in one country. For example, you can calculate Net Sales for Canada, Orders Count for the United States, or Total Refund Amount for the United Kingdom.

What “customer’s country” means

This filter matches the country on each customer’s current default address in Shopify. It is not the shipping address on the order, the billing address, or where the customer lived at the time they ordered.

Three consequences are worth knowing before you rely on it:

• A customer who moves is counted under their new country for every order they have ever placed
• An order shipped somewhere else, such as a gift, still counts under the customer’s own country
• Orders from customers with no default address on file do not match any country filter

That makes this a good way to understand your customer base by location. For questions about where goods physically went, work from the shipping fields on an Orders worksheet instead.

Why country-level numbers change decisions

A single worldwide total hides the fact that customers in different countries behave differently. Sizing conventions, seasons, and buying habits all vary, and a product that sells well to customers in one country can attract refunds from customers in another.

Filtering by country lets you answer questions your store-wide report cannot:

• Which products your customers in each country actually buy, so you can localize your merchandising
• Which countries your refund activity is concentrated in, as a starting point for investigation
• Whether a country’s customer base is large enough to justify translated content or paid ads
• Which countries carry the highest discount dependence

Customer country is a filter, not a breakdown. It limits which orders contribute to a metric; it does not change your worksheet rows or create one row per country.

Add a country-filtered analytics column

Start with a Shopify data worksheet that supports the metric you want to use, such as a product, variant, collection, customer, or order worksheet.

1. Select an empty column or insert a new one. Empty columns have a non-green header; a green header means the column is already linked to Shopify data
2. Click the button in the column header
3. Choose Analytics
4. Under Which metric?, select the metric you want to calculate
5. Under Over what time period?, choose the timeframe for the calculation
6. Under Limit which orders count, click + Add filter
7. Select Customer’s country
8. Search for and select the country
9. Click Save Column

The new column calculates the selected metric using only orders that match the country filter.

Note: Filters vary by metric. Customer’s country appears only when the selected analytics metric supports it.

Compare several countries side by side

Add a separate analytics column for each country you want to compare. Keep the metric and timeframe identical in every column and change only the country filter.

For example, add these columns to a Products worksheet:

• Canada Net Sales, last 12 months
• United States Net Sales, last 12 months
• United Kingdom Net Sales, last 12 months

Rename each column clearly so the metric, country, and timeframe stay obvious to anyone who opens the spreadsheet later.

Because this is a normal worksheet, you can then add a formula column that calculates each country’s share of the total, or flags products whose ranking differs sharply between countries. Those are usually the products worth a closer look when you plan regional merchandising.

Customer country and Shopify Markets are different

Use Customer’s country when you want to restrict one analytics calculation to customers based in a single country.

Use a Market breakdown in a Pivot Table worksheet or Time Series worksheet when you want a row for each Shopify Market, which Mixtable infers from the order’s own country rather than the customer’s saved address. A Shopify Market can cover several countries, so Market reporting shows how your commercial setup is performing, while the country filter groups results by where your customers say they live.

Useful metrics to filter by country

Depending on the worksheet and metric availability, you can filter metrics such as:

• Net Sales, Gross Sales, and Total Sales
• Net Quantity Sold and Gross Quantity Sold
• Orders Count and Average Order Value
• Total Discount Amount
• Total Refund Amount and Refund Count
• Profit and margin metrics when cost data is available