What Is the First Time vs Returning Customers Sales Report?
The First Time vs Returning Customers Sales report compares spending and order volume from new buyers and customers who have purchased before. It brings Date, Customer Type, Order Count, and Total Spent into one view for your selected reporting period.
Use it to understand which customer group contributes more sales and whether that balance changes over time. Review dated customer-type totals rather than individual customer profiles, then export or schedule the report for a regular sales review.
Report Overview
- Report period
- Choose the date range for your review.
- Data included
- Date, Customer Type, Order Count, and Total Spent.
- Best for
- Comparing first-time and returning customer sales and order volume.
- Export formats
- Excel, CSV, TXT, or PDF.
- Automation
- Schedule delivery by email daily, weekly, or monthly.
What Can You Learn from First Time and Returning Customer Sales?
1. Which customer group contributes more spending
Compare Total Spent across the two customer types to see the sales mix for your chosen period. A larger share from one group describes the mix; it does not establish which group is more profitable.
Example: For example, in a month, returning customers contribute $18,000 of $30,000 in reported spending.
What you can do: Use the split to decide which customer group needs closer review in your next sales meeting.
2. Whether order volume explains the spending difference
Read Order Count alongside Total Spent. One customer type may contribute more spending because it places more orders, while the other generates more spending per order.
Example: For example, in a week, returning buyers place fewer orders but contribute more Total Spent than first-time buyers.
What you can do: Calculate Total Spent divided by Order Count in Excel for each group, excluding zero-order rows and using consistent settings.
3. How the customer mix changes across dates
Use Date to spot periods when first-time or returning customer sales rise. Compare equivalent periods before treating a change as a lasting pattern.
Example: For example, in a promotion week, first-time customer spending rises while returning customer spending stays steady.
What you can do: Review the promotion calendar alongside the export to investigate the timing without assuming the campaign caused the change.
What Should You Check First in This Report?
Check these details before sharing the comparison or using it to plan your next review.
- Reporting period: Compare complete periods of similar length and account for seasonal or promotional differences.
- Customer Type: Check how first-time and returning orders are classified, especially when comparing this export with another customer report.
- Total Spent: Confirm the calculation and currency settings, including how refunds, discounts, shipping, and taxes are treated.
- Order Count: Keep orders distinct from customers. Multiple orders can come from the same buyer, so this field cannot establish customer retention rate.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing the monthly sales mix | Compare spending and order totals from first-time and returning buyers in one export. |
| Checking sales during a promotion | See which customer group contributed orders and spending on the promotion dates. |
| Preparing a loyalty program review | Track returning-customer sales over equivalent periods as one input to the review. |
| Investigating a change in total sales | Check whether the change is concentrated in first-time orders, returning orders, or both. |
| Preparing a recurring team update | Deliver the same customer-type comparison on a daily, weekly, or monthly schedule. |
How to Create This Report in Data Export
Start with the premade report so the four core columns are already selected.
- Open Data Export in your Shopify admin and find the premade First Time vs Returning Customers Sales report.
- Open the report and review Date, Customer Type, Order Count, and Total Spent.
- Choose your date range, review the results, and apply available filters or column changes as needed.
- Save the report and export it in the format you need, such as Excel for calculations or PDF for a summary.
- Set an email schedule for daily, weekly, or monthly delivery, and check the reporting period before activating it.
Make the Most of This Report
Use these checks to keep recurring exports easy to compare.
01 / PERIODS
Compare complete weeks or months. Keep the date range consistent between scheduled deliveries.
02 / COUNTING
Sum orders as orders. Do not label Order Count as the number of new or returning customers.
03 / SPENDING
Confirm what Total Spent includes before matching it to another sales report or calculating spending per order.
04 / EXPORTS
Use Excel or CSV for further calculations. Keep report settings consistent when sharing comparisons with your team.
Frequently Asked Questions
What is the difference between first-time and returning customer sales?
First-time customer sales come from buyers making their first purchase; returning customer sales come from buyers who have purchased before. Check the report’s classification settings when reconciling it with another report.
Does Order Count show how many unique customers purchased?
No. Order Count measures orders. A buyer can place multiple orders, so you need a customer-level count to measure how many distinct people purchased.
Can I calculate average spending per order for each customer type?
Yes. In an exported spreadsheet, divide the group’s Total Spent by its Order Count for the same period. Use the group totals rather than averaging row-level averages, and exclude zero-order totals.
Does this report show retention rate or customer lifetime value?
The four default fields compare orders and spending by customer type and date. Retention rate requires customer-level tracking, and lifetime value requires a defined customer-level spending period and calculation.
Can I schedule this report by email?
Yes. Save the report and set daily, weekly, or monthly email delivery. Check the selected date range so each delivery covers the period you intend to review.