Customer retention rate
SQL query for LightSpeed eCom
Calculate the percentage of customers who made repeat purchases.
SELECT COUNT(DISTINCT customer_id) AS total_customers, COUNT(DISTINCT customer_id) / COUNT(DISTINCT customer_id) AS retention_rate FROM orders WHERE order_date BETWEEN ‘start_date’ AND ‘end_date’
LightSpeed eCom data model
Orders
Carts
Products
Customers
Discount Coupons
Subscriptions
Categories
Customer Groups
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed