What Is the Sales Attributed to Each Custom Collection Report?
The Sales Attributed to Each Custom Collection report in Data Export shows sales associated with manually curated Shopify collections, such as Gift Guides, New Arrivals, Clearance and Staff Picks. It brings collection attribution, order count and sales amounts into one view for your selected date range.
Use it to review which curated product groups contribute sales, how discounts and returns affect those sales, and which collections deserve another merchandising review. Collection attribution describes how sales are grouped in this report; it does not establish that a shopper visited a collection page before buying.
Report Overview
- Report period
- The date range you select when generating the report.
- Data included
- Custom collection attribution, collection names, order count and sales components.
- Best for
- Reviewing manual collection performance and preparing merchandising exports.
- Export formats
- Excel, CSV, TXT and PDF.
- Automation
- Schedule email delivery daily, weekly or monthly.
What Can You Learn from Custom Collection Sales?
1. Which curated collections contribute sales
Review net sales and order count together to compare the product groups you maintain by hand. Use matching date ranges for a useful comparison.
Example: For example, staff Picks shows higher net sales than Gift Guides over the same four weeks.
What you can do: Review Staff Picks for another homepage placement test.
2. Where discounts reduce retained sales value
Compare gross sales, discounts and net sales to see which collections depend heavily on markdowns. These fields describe sales value, not profit.
Example: For example, clearance has strong gross sales but a large discount amount.
What you can do: Review the collection’s discount strategy before repeating the promotion.
3. Which collections need a returns review
Use the Returns field alongside net sales to identify curated groups that merit a closer look. The report does not identify why customers returned products.
Example: For example, new Arrivals has more returned sales value than another similarly sized collection.
What you can do: Investigate the products and customer feedback behind that collection.
What Should You Check First in This Report?
Check the grouping and sales basis before choosing which collection to promote next.
- Attribution and collections: Confirm how a product in more than one manual collection is treated before adding rows together.
- Net sales: Use this to review sales value after discounts and returns; do not treat it as margin.
- Discount and returns: Check which deduction has the larger effect on each collection.
- Order count and total sales: Review activity and sales amounts together, keeping shipping, tax and duties in mind.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing homepage collection placements | Compare attributed net sales and order count before testing a different collection position. |
| Evaluating a seasonal gift guide | Filter the campaign period and review the collection’s reported sales and returns. |
| Checking a clearance promotion | See how discounts affect the collection’s gross and net sales. |
| Investigating collections with high returns | Identify groups that need a separate product or return-reason review. |
| Preparing a weekly merchandising update | Export collection results or schedule a recurring email for the team. |
How to Create This Report in Data Export
Start with the premade collection report and adapt it to the review you need.
- Open Data Export in Shopify and find the premade Sales Attributed to Each Custom Collections report.
- Open the report and review the collection attribution field and the included sales columns.
- Choose your date range and apply a collection filter if you want to study one curated group. Adjust fields as needed.
- Save the report and generate it. Review the results, then export in your preferred supported format.
- Set an optional daily, weekly or monthly email schedule for yourself or your merchandising team.
Make the Most of This Report
Use these checks to keep recurring collection reviews consistent.
01 / PERIOD
Compare equal windows: Use matching date ranges when reviewing seasonal or promotional collection performance.
02 / OVERLAP
Check shared products: Confirm attribution behavior for products in multiple collections before summing collection totals.
03 / INTERPRETATION
Keep sales separate from profit: Net sales excludes product costs and cannot show collection profitability on its own.
04 / DELIVERY
Choose a useful format: Use Excel or CSV for further analysis and PDF for a shareable review.
Frequently Asked Questions
Which collections does this report cover?
It is designed for custom or manual collections: product groups you curate by hand, such as Staff Picks or Gift Guides.
Does it show that customers bought through a collection page?
No. Sales attributed to a collection should not be read as proof of a collection-page visit or a marketing referral. Use the report to review grouped product sales.
Can I add all collection totals to get store sales?
Confirm the attribution rule first, especially where products belong to several collections. Ask Data Export support how overlapping membership is handled before using collection totals as a store-wide total.
Can I export and schedule this report?
Yes. Export it as Excel, CSV, TXT or PDF, and schedule daily, weekly or monthly email delivery.
Does net sales tell me which collection is most profitable?
No. The default fields do not include product costs or profit. Use net sales to compare sales after discounts and returns.