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 app, click the Create a Workbook 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:
- Select an empty column (or insert a new one).
- Click the Link button from the column header.
- From the Shopify Sync Settings window, choose a metric.
- Select a time range, if necessary.
The data will begin to populate the column.
Analyze store data with spreadsheet functions
Operating in the Mixtable app allows you to use spreadsheet functions to analyze and manage your data, such as:
Find out more about the Mixtable suite of products here.
