Shopify Total Discount Amount Analytics

Total Discount Amount analytics is essential for managing and adjusting your sales strategies. With Mixtable Analytics, you can see:

• Discount amounts for Products and Product variants;
• Discount amounts for Collections.

Through Discount Analytics, you can measure the effectiveness of your sales campaigns and whether and to what extent they have led to attracting new customers and revenue.

How to add Total Discount Amount data to your worksheet

If you have already created a Mixtable workbook for your Shopify store, you can quickly add the Total Discount Amount to an existing worksheet.

Note: 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.

Here’s how to get started:

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 Total Discount Amount metric.

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

  • 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 Total Discount Amount for a dynamic 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 particular month (e.g., April 2025).

Optional - Total Discount Amount for a Customer Segment

Mixtable Analytics & Reports allows you to filter the Total Discount Amount data based on the customer segments you have created in Shopify. Here's how to do it:

• From the Shopify Sync Settings window, choose Analytics

• Then, select the Total Discount Amount metric

• Select the time range for which you want the Total Discount Amount to be calculated.

  • 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 Total Discount Amount 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 particular month (e.g., July 2024)

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

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 - Total Discount Amount by Country

Another option for filtering Total Discount Amount data is according to the customer's country. Use this feature to calculate your international store performance. Here's how to do it:

• From the Shopify Sync Settings window, choose Analytics.

• Then, select the Total Discount Amount metric.

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

  • 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 Total Discount Amount for a dynamic 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 particular month (e.g., June 2024)

• Use the Filter orders based on customer's country to select the country for which to show the Total Discount Amount.

You are ready!

Well done! Now that you have Total Discount Amount 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.