New Customer Revenue

new_customer_revenue

Overview

New Customer Revenue refers to the total amount of revenue derived from new customer orders.

📘

New Customer Revenue = Total Order Revenue from New Customers

The calculation is based on data from the Orders table.

Insights and Actions

New Customer Revenue is pivotal for gauging the success of efforts to attract first-time buyers and the revenue they contribute. Efficiently leveraging New Customer Sales data can guide strategic business decisions:

• Assess Marketing Campaign Effectiveness: Evaluate which marketing strategies and channels are most successful in attracting new customers by correlating them with spikes in new customer sales.
• Optimize Customer Acquisition Cost (CAC): Use insights from new customer sales to assess the return on investment in acquisition strategies and refine spending to improve CAC.
• Enhance Onboarding Experience: Tailor the onboarding process for new customers based on insights into their purchasing behavior to increase satisfaction and retention.
• Identify High-Value Customer Segments: Analyze new customer sales data to identify which segments are most lucrative and target similar demographics in future campaigns.

Example Use

Prompt

What was my new customer revenue Sep 24, 2024?

Response

Query

SQL

SELECT  
  SUM(ot.order_revenue) AS new_customer_revenue  
FROM  
  orders_table AS ot  
WHERE  
  ot.is_new_customer = TRUE  
  AND ot.event_date = '2024-09-24';