Returning Customer Revenue


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.

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


Show returning customer revenue for December 12, 2023



  SUM(order_revenue) AS revenue
  event_date = '2023-12-12'
  AND is_new_customer = FALSE