Returning Customer Revenue
returning_customer_revenue
Overview
Returning Customer Revenue refers to the total revenue generated from customers who have made more than one purchase.
Returning Customer Revenue = Total Order Revenue from Returning Customers
The calculation is based on data from the Orders table.
Note
Triple Whale classifies all customers as either new or returning, while the main sales platform may leave some unclassified, potentially leading to discrepancies between the two.
Insights and Actions
Returning Customer Revenue is a key indicator of customer loyalty and the effectiveness of retention strategies. Efficiently leveraging Returning Customer Revenue data can guide strategic business decisions:
- Enhance Customer Loyalty Programs: Strengthen or introduce loyalty programs to encourage repeat purchases, increasing returning customer revenue.
- Personalize Marketing Efforts: Use purchase history data to tailor marketing messages and offers, enhancing relevance and encouraging repeat business.
- Optimize Product and Service Offerings: Analyze the preferences of returning customers to adjust your offerings, ensuring they meet the needs and desires of your most loyal customer base.
- Focus on Customer Satisfaction: Implement feedback loops and customer satisfaction surveys to identify areas for improvement, directly impacting repeat business and revenue.
Example Use
Prompt
What was the returning customer revenue for the last 7 days?
Response

Query
WITH
returning_customers_cte AS (
SELECT
ot.customer_id AS customer_id
FROM
orders_table AS ot
WHERE
ot.is_new_customer = FALSE
AND ot.event_date BETWEEN '2024-09-18' AND '2024-09-24'
GROUP BY
ot.customer_id
)
SELECT
SUM(
IF(od.is_new_customer = FALSE, od.order_revenue, 0)
) AS returning_customer_revenue
FROM
returning_customers_cte AS rc
JOIN orders_table AS od ON rc.customer_id = od.customer_id
WHERE
od.event_date BETWEEN '2024-09-18' AND '2024-09-24';
Updated 18 days ago
Did this page help you?