search

Shopify Collection Analytics

Collections Analytics in Shopify

Grouping products into collections in Shopify allows for easier product browsing and discovery. Analyzing the performance of collections would provide you with a high-level view of your store. With Collection Analytics by Mixtable, you can see net and gross sales, quantity sold, refunds, and discounts - all this from the convenience of an online spreadsheet.

How to add Shopify Collection analytics to a spreadsheet

If you have already created a Mixtable workbook for your Shopify store, you can quickly add a new Collections worksheet. Here is how to do it:

Add а new worksheet:

In an existing Mixtable workbook, click the (+) button to add a new worksheet.

Add a new worksheet for Shopify data

From the Add Worksheet window, choose Shopify data worksheet > Collections.

Shopify collections analytics

Net Sales / Gross Sales analytics per Shopify collections

Here’s how to map Net Sales or Gross Sales per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Net Sales or Gross Sales metric

  • Select the time range that you want the {{object2}} 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 Net Sales or Gross Sales for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the Net Sales or Gross Sales will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Net Sales or Gross Sales for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Net Quantity Sold / Gross Quantity Sold analytics per Shopify collections

Here’s how to map Net Quantity Sold or Gross Quantity Sold per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Net Quantity Sold or Gross Quantity Sold metric

  • Select the time range that you want the {{object2}} 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 Net Quantity Sold or Gross Quantity Sold for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the Net Quantity Sold or Gross Quantity Sold will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Net Quantity Sold or Gross Quantity Sold for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Orders Count analytics per Shopify collections

Here’s how to map Orders Count per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Orders Count metric

  • Select the time range that you want the {{object2}} 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 Orders Count for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the Orders Count will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Orders Count for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Total Refund Amount analytics per Shopify collections

Here’s how to map Total Refund Amount per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Total Refund Amount metric

  • Select the time range that you want the {{object2}} 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 Total Refund Amount for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the Total Refund Amount will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Total Refund Amount for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Refund Count analytics per Shopify collections

Here’s how to map Refund Count per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Refund Count metric

  • Select the time range that you want the {{object2}} 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 Refund Count for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the Refund Count will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Refund Count for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Total Discount Amount analytics per Shopify collections

Here’s how to map Total Discount Amount per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Total Discount Amount metric

  • Select the time range that you want the {{object2}} 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 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 Total Discount Amount will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Total Discount Amount for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Percent of Orders Refunded analytics per Shopify collections

Here’s how to map Percent of Orders Refunded per collection into your Mixtable Collection worksheet.

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.

Add Shopify data to a spreadsheet

  • From the Shopify Sync Settings window, choose Analytics

  • Then, select the Percent of Orders Refunded metric

  • Select the time range that you want the {{object2}} 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 Percent of Orders Refunded will be recalculated daily as the date range window moves forward.
    • Calendar year and month - show the Percent of Orders Refunded for a specific year (e.g., 2023) or a particular month (e.g., August 2024)

Analytics date range

Optional - filter the Collection data based on a Customer Segment

Mixtable Analytics allows you to filter the collection data based on the customer segments you have created in Shopify.

  • To do that, after selecting the analytics metric and the data range, use the Filter orders based on Customer Segment defined in Shopify Admin section to select the customer segment to be used.

Collection data per 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 - Collection data by Country

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

  • After selecting the analytics metric and the data range, use the Filter orders based on customer’s country to select the country for which to show the collection data.

Filter Collection analytics by Country



You are ready!

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

Find out more about the Mixtable suite of products here.

Mixtable is an online spreadsheet, designed from the ground up to bulk edit and analyze Shopify data.

Got a question? We're here to help! Reach out at [email protected], and we'll get back to you promptly.