Shopify Analytics By Customer Country

Are you interested in tracking how many sales you generate from different countries in real-time? Or if there are countries with outlying numbers of refunds? Or if the discounts from a particular market lead to more orders? With Mixtable Analytics, you can now follow all this data from the comfort of a spreadsheet.

How to add Customer Country Analytics to your worksheet

If you have already created a Mixtable spreadsheet for your Shopify store, you can quickly add analytics data to an existing worksheet, such as:

• Net Sales / Gross Sales
• Net / Gross Quantity Sold
• Orders Count
• Orders Net Profit
• Total Refund Amount
• Total Discount Amount
• Refund Count
• Percent of Orders Refunded

Add analytics data column to your Mixtable spreadsheet:

Note: The worksheet needs to be showing product or collection information. E.g., Products (with variants), Products (no variants), Manual Collections, Automated Collections.

To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the button in the column header to open the selection window to choose the data you want to pull in.

• From the Shopify Sync Settings window, choose Analytics

• Then, select the metric you want to see

• Select the time range that you want the data to be calculated for

  • All orders - all sales since the creation of the store
  • Fixed date range - show data for a specific period between two dates
  • Dynamic date range - calculate the data for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the data will be recalculated daily as the date range window moves forward.
  • Calendar year and month - show the data for a specific year (e.g., 2023) or a specific month (e.g., August 2024)

Filter data by Customer Country

Use the Filter orders based on customer’s country to select the country for which to show the analytics metric:

Data comparison

• Use the same Link option to add multiple columns. You can:

  • map sales data from different countries,

  • or add analytics data by customer country for:

    • order count,
    • quantity sold,
    • discounts, and
    • refunds.

You are ready!

Well done! Now that you have data in an online spreadsheet, you can use any Excel function to analyze the data, such as:

• Sort ascending or descending,
• Find-replace,
• Filter,
• Use Excel formulas, e.g., for price changes, etc.

Find out more about the Mixtable suite of products here.