What Is the Returning Customers Report?
The Returning Customers report lists Shopify customers who have purchased from your store more than once. It brings their names, customer IDs, order counts, total spent, email addresses, and phone numbers into one export so you can review repeat buyers without opening individual customer records.
Use the customer-level view to compare purchase frequency, identify higher-spending repeat buyers, and prepare lists for loyalty reviews or customer follow-up. Order Count and Total Spent help you choose whom to review; the name and contact fields help you work with the resulting list.
This report describes repeat customers rather than individual purchases. Its default fields do not include order dates, products purchased, or marketing consent, so those details need a separate check before you plan a campaign or decide that a customer has stopped buying.
Report Overview
- Report type
- Customer Reports, focused on customers with more than one purchase.
- Reporting basis
- Customer-level records. Check the date-range settings before treating Order Count or Total Spent as figures for a selected period.
- Data included
- Eight fields covering customer identity, purchase count, spending, and contact details.
- Best for
- Repeat-buyer reviews, loyalty planning, and preparing customer lists.
- Export and delivery
- Excel, CSV, TXT, or PDF; scheduled email delivery daily, weekly, or monthly.
What Can You Learn from Returning Customer Data?
1. Which customers buy more frequently
Sort Order Count to compare repeat buyers by purchase frequency. A customer with several orders may warrant a different loyalty approach from someone who has just made a second purchase.
Example: For example, customer with eight orders appears above a customer with two.
What you can do: Create separate review lists for frequent buyers and newer repeat customers.
2. Which repeat buyers have spent more
Total Spent helps you prioritize customers by recorded spending. Review it alongside Order Count so you can distinguish frequent purchasers from customers whose spending comes from fewer purchases.
Example: For example, customer with three orders has spent more than one with seven.
What you can do: Use both measures when setting criteria for a VIP review.
3. Where contact details need attention
Email and Phone let you check whether your repeat-buyer list has contact information. A blank field signals a record to review, while a populated field still needs a consent check before marketing use.
Example: For example, repeat buyer has a phone number but no email address.
What you can do: Review incomplete records before passing the list to a customer-facing team.
What Should You Check First in This Report?
Review these details before using or sharing the export.
Order Count: Confirm that the list reflects repeat buyers and review the count thresholds you plan to use.
Total Spent: Check the report’s currency and calculation settings before assigning spending tiers.
Customer ID: Use this field to match records; names alone can be shared by different customers.
Email and Phone: Look for missing details and check marketing consent separately before outreach.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Planning loyalty rewards | Use Order Count to identify customers who have purchased repeatedly. |
| Reviewing VIP candidates | Compare Total Spent and Order Count before deciding whom to recognize. |
| Preparing a repeat-buyer contact list | Export customer names, IDs, email addresses, and phone numbers for review. |
| Checking customer record completeness | Identify repeat-buyer records with missing email addresses or phone numbers. |
| Sharing a regular customer review | Schedule the report so your team receives an updated export on a consistent timetable. |
How to Create This Report in Data Export
Start with the Returning Customers premade report in Data Export.
- Open Data Export in your Shopify admin and find the Returning Customers premade report.
- Open the report and review the eight default fields, including Order Count and Total Spent.
- Review the date-range settings and available filters. Confirm how these settings affect the customer counts and spending figures, then sort the list as needed.
- Save the report and download it in Excel, CSV, TXT, or PDF for your intended use.
- Optionally schedule daily, weekly, or monthly email delivery to the people who need the customer review.
Make the Most of This Report
Use these checks to keep customer exports useful and consistent.
01 / COUNTING
Count customers by ID. Use Customer ID when matching exports; one person may share a name with another customer.
02 / DATE SETTINGS
Confirm the reporting basis. A selected date range does not establish that customer totals cover only that period. Check the settings first.
03 / CONTACT DETAILS
Check consent separately. Email and Phone show stored contact details; neither field establishes permission to send marketing messages.
04 / FILE SHARING
Share only useful columns. Remove unnecessary contact details before distributing a report intended solely for purchase-count or spending reviews.
Frequently Asked Questions
Who appears in the Returning Customers report?
The report focuses on customers who have purchased from the store more than once. Order Count helps you review their recorded purchase frequency.
Can I use this report to calculate the returning-customer rate?
The returning-customer list alone is insufficient. You also need the relevant total customer population and a consistent period and definition to calculate a rate.
Does this report identify customers who have stopped buying?
The default fields do not include a last-order date. Add or obtain suitable order-date data before using the list to identify lapsed customers.
Are Order Count and Total Spent limited to my selected dates?
Check how the report applies date settings to these customer fields before interpreting the figures. Confirm whether they represent the selected period or cumulative customer totals.
Can I export and schedule this report?
Yes. Download the report in Excel, CSV, TXT, or PDF, and schedule email delivery daily, weekly, or monthly.