What Is the Sales Attributed to Each Smart Collection Report?
The Sales Attributed to Each Smart Collection report in Data Export shows sales attributed to individual Shopify smart collections. It brings together order count, gross sales, discounts, returns, net sales, shipping, taxes, duties, and total sales for the reporting period you select.
Smart collections group products using conditions, such as tags, vendor, product type, or price. Use this report to review those automatically maintained groups, compare their sales results, and prepare a collection-level export for merchandising reviews. The figures describe attributed sales; they do not establish that a customer visited a collection page before buying.
Report Overview
- Reporting period
- Choose the date range for your sales review.
- Data included
- 12 fields covering collection attribution, order count, and sales-related amounts.
- Best for
- Reviewing rule-based product groups used in navigation and campaign landing pages.
- Export formats
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly.
What Can You Learn from Smart Collection Sales?
1. Which automated groups lead on net sales
Compare net sales across your rule-based collections to choose groups for a closer merchandising review.
Example: For example, a seasonal collection has higher net sales than a vendor-based collection.
What you can do: Review the leading group’s product selection before your next storefront refresh.
2. Where discounts change the sales picture
Read Discount alongside Gross Sales and Net Sales to see which collections depend more heavily on promotions.
Example: For example, a sale-tagged collection leads on gross sales but falls behind on net sales.
What you can do: Review its promotional pricing before repeating the offer.
3. Which collections need a returns review
Compare reported return amounts across collections to identify groups worth investigating at product level. The report does not explain why items were returned.
Example: For example, a product-type collection shows a larger return amount than in the previous review period.
What you can do: Investigate the products and return reasons behind that group.
4. How order count adds context to revenue
Read Order Count with sales amounts to distinguish groups generating many orders from groups generating revenue through fewer orders.
Example: For example, a premium-price collection has fewer orders but higher total sales than another group.
What you can do: Consider both order activity and sales value when choosing collection placement.
What Should You Check First in This Report?
Start with these checks before sharing a ranking or changing a collection’s presentation.
- Collection scope: Confirm the collection labels, attribution settings, filters, and date range match the groups you intend to review.
- Net Sales: Use it to compare sales after the reported reductions; read Gross Sales, Discount, and Returns alongside it.
- Order Count: Add order activity to your revenue comparison without treating it as units sold or unique customers.
- Total Sales: Review shipping, taxes, and duties alongside this amount before interpreting differences between collections.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing seasonal smart collections | Compare sales attributed to seasonal product groups over a selected period. |
| Choosing collections to feature in navigation | Use net sales and order count to inform which groups deserve a closer review. |
| Checking a promotion across tagged products | Read discounts and net sales together for the affected smart collection. |
| Investigating collections with high return amounts | Identify collection groups that need a product-level returns investigation. |
| Preparing a recurring merchandising review | Export the same collection view or schedule it for regular team delivery. |
How to Create This Report in Data Export
Start with the premade collection report rather than assembling the fields individually.
- Open Data Export in Shopify and find the premade “Sales Attributed to Each Smart Collections” report.
- Open the report and review its collection attribution and sales fields.
- Set your date range and apply relevant filters, such as a single collection. Adjust the columns if your review needs a different view.
- Save the report and export it as Excel, CSV, TXT, or PDF.
- Optionally schedule daily, weekly, or monthly email delivery to yourself or the merchandising team.
Make the Most of This Report
Keep collection reviews consistent with these four practical checks.
01 / PERIOD
Compare like periods: Use equal-length reporting windows when reviewing seasonal or promotional collections.
02 / SCOPE
Keep the group clear: Filter to one smart collection when investigating a specific pricing or merchandising question.
03 / ATTRIBUTION
Check before adding: Confirm how overlapping collection membership is handled before summing rows or presenting revenue shares.
04 / DELIVERY
Match the format: Use Excel or CSV for further analysis and PDF for a readable team snapshot.
Frequently Asked Questions
What is a smart collection in this report?
A smart collection is a product group maintained through conditions, such as product tags, vendor, product type, or price. This report focuses on sales attributed to those automated groups.
Does attribution prove that a collection page drove a purchase?
No. The report groups attributed sales by collection. It does not include a browsing path or conversion journey proving that a collection page caused the sale.
Can I add collection rows to get storewide sales?
Confirm the attribution settings and treatment of products in multiple collections first. Reconcile the result with your store sales report before using a summed collection total.
Does Net Sales show collection profit?
No. Net Sales is a sales measure. The report does not include product costs or a profit field.
Can I export and schedule this report?
Yes. Export as Excel, CSV, TXT, or PDF, and schedule daily, weekly, or monthly email delivery. Save your date range, filters, and selected fields before setting up the schedule.