What Is the Sales & Customer Metafields Report?
The Sales & Customer Metafields report brings customer sales and saved profile details into one view. Review orders, net quantity, gross sales, discounts and net sales alongside a customer metafield value, such as preferred size, skin type or account type.
Use it to compare spending across customers who share a saved detail, without manually matching separate customer and sales exports. Choose the sales period you want to review, then export the results or schedule delivery for a recurring review.
Report Overview
- Report type
- Customer.
- Report period
- Your selected sales date range.
- Data included
- Customer name and email, a customer metafield value, and five order and sales measures.
- Best for
- Comparing customer spending by saved preference or account type.
- Export and delivery
- Excel, CSV or PDF; scheduled email or Google Sheets/Drive delivery, subject to your report settings.
What Can You Learn from Customer Metafields and Sales?
1. Which saved customer groups contribute more sales
Group net sales by a selected metafield value to compare segments such as retail and wholesale accounts. Check customer counts too: a larger group can generate more total sales without spending more per customer.
Example: For example, wholesale accounts contribute more net sales than retail accounts during the same month.
What you can do: Review the leading group before planning account-specific offers.
2. Where customer preferences connect with demand
Saved preferences can help you understand the customers behind revenue. A preference field describes a customer; it does not identify which products or sizes they actually purchased.
Example: For example, customers with sensitive skin recorded in their profiles contribute the most net sales.
What you can do: Prepare relevant messaging, then check product sales before changing your assortment.
3. Which customers merit a closer retention review
Review orders alongside net sales to find customers placing multiple orders in the selected period. High sales from one large order suggest a different follow-up from several smaller purchases.
Example: For example, one trade account places four orders while another places one larger order.
What you can do: Prioritize account follow-ups using both order count and spending.
What Should You Check First in This Report?
Check these details before comparing groups or totaling an export.
- Metafield selection: Confirm the definition and value format. Keep blank values visible so customers without saved details are not overlooked.
- Sales period: Use the same date range and filters for every comparison.
- Net sales and discounts: Review deductions before interpreting gross sales as customer value; neither measure shows profit.
- Customer rows and order counts: Check whether customers repeat across rows before adding sales or orders. Do not treat an order count within one period as lifetime purchase history.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Comparing retail and wholesale accounts | Review orders and net sales by a saved account type. |
| Planning campaigns around preferences | Compare sales associated with saved skin types, styles or other customer details. |
| Reviewing high-value accounts | Find customers with substantial net sales or multiple orders in the chosen period. |
| Checking incomplete customer profiles | See where blank metafield values limit customer grouping. |
| Preparing a recurring customer sales review | Deliver the same selected fields and period settings on a schedule. |
How to Create This Report in Data Export
Start with the premade report, then review the customer detail and sales period.
- Open Data Export and go to Prebuilt Reports, then Customer reports.
- Open Sales & Customer Metafields and review the available columns. Confirm the customer metafield you want to include.
- Set your sales date range. Apply an available metafield-value or customer-tag filter if needed.
- Generate a preview, check a few customer records and save the report.
- Choose an export format or schedule daily, weekly or monthly delivery using the destinations available in your settings.
Make the Most of This Report
Use these checks to keep customer comparisons useful and exports easy to share.
01 / GROUP CONSISTENTLY
Standardize values such as “Wholesale” and “wholesale” before treating them as separate customer groups.
02 / CHART THE EXPORT
In Excel or Google Sheets, total net sales by metafield value with a pivot table, then add a bar chart.
03 / CHECK VALUE TIMING
Confirm whether the report uses current profile values before using it to describe customer attributes at the time of purchase.
04 / SHARE SELECTIVELY
Remove names and emails from shared summaries when only group totals are needed. Limit access to sensitive customer preferences.
Frequently Asked Questions
Can I compare Shopify sales by customer metafield?
Yes. Select the customer metafield and review sales alongside its values. For a group comparison, summarize net sales by value in Excel or Google Sheets after checking for repeated customer rows.
Does this show every customer metafield automatically?
The report includes one Customer Metafield Value, not every customer metafield. Check which metafield definition is selected, and ask support about adding others.
Does higher spending prove a quiz increased sales?
No. The report shows an association between saved details and sales. It does not establish that completing a quiz or form caused a purchase.
Can I export or schedule this report?
Use Excel, CSV or PDF for downloads. You can schedule delivery by email or to Google Sheets/Drive where available in your report settings.
Can I identify returning customers from Orders?
An order count greater than one indicates multiple orders within the chosen period. It does not identify every returning customer, since earlier purchases may fall outside that period.