Collection Sales Template

Want to understand what’s really working in your Shopify store? The Collection Sales spreadsheet provides the data you need to make smarter choices for growth.

You can use the template to understand:

• Top and bottom performers
• Average order value per collection
• Discount effectiveness
• Return rate analysis

You can also analyze the following customer behavior:

• Popular product categories: Collections with high Total Order Counts and Gross Quantity Sold indicate popular product categories that attract a larger customer base.
• Purchase patterns: Analyzing which collections are frequently purchased together (though not directly available in this data, it can inspire further analysis) can inform product placement and cross-selling strategies.
• Sensitivity to price/discounts: Collections with a significant increase in sales during discount periods might indicate price-sensitive customer segments interested in those specific product types.

How to load the Collection Sales template?

• After installing the Mixtable Analytics Spreadsheet app, click the Create Spreadsheet button.
• Select the Collection Sales pre-built template from the list.

Data included in the Collection Sales template

The Collection Sales template contains the following default data points:

• Collection Title
• Total Order Count
• Gross Quantity Sold
• Net Quantity Sold
• Returns
• Discounts
• Net Sales

In addition to the default data pulled from Shopify, you can map extra columns with desired data. Here’s how:

• 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 a metric.

• Select a time range, if necessary.

The data will begin to populate the column.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.