Shopify Percent of Orders Refunded Analytics

The Percent of Orders Refunded analytic in Mixtable displays the percent of total orders in your store that have been refunded.

How to add Percent of Orders Refunded data to your worksheet

If you have already created a Mixtable workbook for your Shopify store, you can quickly add the Percent of Orders Refunded to an existing worksheet.

• The worksheet needs to show product or collection information, e.g., Products—Complete, Product—Basic, Manual Collections, Automated Collections.

  • Check the following page if you need to add a new Shopify-linked worksheet with any of this data.

• Choose an empty column (or insert a new one) and click the Link button from the column header.

• From the Shopify Sync Settings window, choose Analytics

• Then, select the Percent of Orders Refunded metric

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

  • For all time - all data since the creation of the store
  • Fixed date range - show data for a specific period between two dates
  • Dynamic date range - calculate the Percent of Orders Refunded 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., April 2024)

Optional - Percent of Orders Refunded for a Customer Segment

Mixtable Analytics allows you to filter the Percent of Orders Refunded data based on the customer segments you have created in Shopify.

• From the Shopify Sync Settings window, choose Analytics.

• Then, select the Percent of Orders Refunded metric

• Select the time range that you want the Percent of Orders Refunded 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 Percent of Orders Refunded 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., June 2022)

• Now, use the Filter orders based on Customer Segment defined in Shopify Admin section to select the customer segment to be used.

Note: The customer segments shown are the ones you have defined in your Shopify Admin. To add or change your segments please use the Shopify Admin, and Mixtable will reflect your changes automatically.

Optional - Percent of Orders Refunded by Country

Another option for filtering Percent of Orders Refunded data is according to the customer’s country. Use this feature to calculate your international store performance.

• From the Shopify Sync Settings window, choose Analytics

• Then, select the Percent of Orders Refunded metric

• 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 Percent of Orders Refunded 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., January 2022)

• Use the Filter orders based on customer’s country to select the country for which to show the Percent of Orders Refunded.

You are ready!

Well done! Now that you have Percent of Orders Refunded data in an online spreadsheet for products or collections, you can use any spreadsheet function to analyze the data, such as:

• sorting ascending or descending,
• find-replacing,
• filtering,
• using formulas, e.g., for inventory management, etc.

Find out more about the Mixtable suite of products here.