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';