What is NewCustomerCount?
The total count of distinct customers appearing in the orders table for the first time. This helps track customer acquisition over a specific period.
Why Track NewCustomerCount?
- Customer Acquisition Tracking:
- Understand how well marketing or outreach efforts are converting new customers.
- Growth Analysis:
- Monitor the growth of the customer base over time.
- Segmentation Insights:
- Allows segmenting orders into those from new versus returning customers.
- Business Health:
- A consistent inflow of new customers often indicates a healthy and expanding business.
Examples
Scenario 1: Weekly Report
- Data: Orders from 1st to 7th of the month.
- Result: 50 distinct customer IDs are identified as new customers.
- Query Output: 50
Scenario 2: Monthly Report
- Data: Orders from the entire month.
- Result: 300 distinct customer IDs are new.
- Query Output: 300
Practical Use Cases
- Marketing Campaigns:
- Determine how many new customers were acquired during a campaign.
- Customer Retention Analysis:
- Compare the percentage of new customers to returning customers.
- Growth KPIs:
- Use NewCustomerCount as a KPI for tracking growth and reach.
- Sales Strategy:
- Tailor strategies to target areas generating higher new customer counts.