Shopify Collection Analytics
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 Manual or Automated Collections worksheet. Here is how to do it:
- In an existing Mixtable workbook, click the (+) button to add a new worksheet.
- From the Add Worksheet window, choose Shopify data worksheet > Manual Collections or Automated Collections.
Net Sales / Gross Sales analytics per Shopify collections
Here’s how to map Net Sales or Gross Sales per collection into your Mixtable spreadsheet:
- In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
- Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Net Sales or Gross Sales metric from the drop-down list.
-
Select the time range that you want the sales 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 sales 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 sales data for a specific year (e.g., 2024) or a specific month (e.g., May 2024).
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 spreadsheet:
- In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
- Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Net Quantity Sold or Gross Quantity Sold metric from the drop-down list.
-
Select the time range that you want the sold quantity 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 sold quantity 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 sold quantity data for a specific year (e.g., 2024) or a specific month (e.g., May 2024).
Orders Count analytics per Shopify collections
Here’s how to map Orders Count per collection into your Mixtable worksheet:
-
In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
-
Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Orders Count metric from the drop-down list.
-
Select the time range that you want the order count 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 - get 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 data will be recalculated daily as the date range window moves forward.
- Calendar year and month - show the data for a specific year or a specific month.
Total Refund Amount analytics per Shopify collections
Here’s how to map Total Refund Amount per collection into your Mixtable worksheet:
-
In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
-
Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Total Refund Amount metric from the drop-down list.
-
Select the time range that you want the refund amount 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 - get the refund 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 or a specific month.
Refund Count analytics per Shopify collections
Here’s how to map Refund Count per collection into your Mixtable worksheet:
-
In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
-
Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Refund Count metric from the drop-down list.
-
Select the time range that you want the refund count 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 — get the refund count for a dynamic time period in the past, e.g., the last 7 days or the 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 or a specific month.
Total Discount Amount analytics per Shopify collections
Here’s how to map Total Discount Amount per collection into your Mixtable worksheet:
-
In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
-
Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Total Discount Amount metric from the drop-down list.
-
Select the time range that you want the discount amount 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 - get the 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 or a specific month.
Percent of Orders Refunded analytics per Shopify collections
Here’s how to map Percent of Orders Refunded per collection into your Mixtable worksheet:
-
In your Manual or Automated Collection worksheet, select an empty column (or insert a new one).
-
Then click Set Sync from the column header.
-
From the Shopify Sync Settings window, choose Analytics
-
Then, select the Percent of Orders Refunded metric from the drop-down list.
-
Select the time range that you want the Percent of Orders Refunded 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— get the percentage of refunded orders for a dynamic time period in the past, e.g., the last 7 days or the 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 or a specific month.
Optional - filter 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.
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.
Analyze Shopify data in a spreadsheet
You are ready! Well done! Now that you have Shopify collection data in an online spreadsheet, you can use any spreadsheet function to analyze the data, such as:
Find out more about the Mixtable suite of products here.
