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 workbook 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:

• The worksheet needs to be showing product or collection information. E.g., Products - Complete, Product - Basic, Manual Collections, Automated Collections
• Choose an empty column (or insert a new one) and click the Set Sync button from the column header.

• 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

  • For all time - 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 Set Sync 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.

• With Mixtable you can use spreadsheet functions to operate with the data, such as:

  • sort data ascending or descending,
  • find-replace,
  • filter,
  • and using formulas.