New Customer Orders

new_customer_orders

Overview

New Customer Orders represents the total number of orders placed by new customers.

📘

New Customer Orders = Total count of orders by new customers

The calculation is based on data from the Orders table.

Detailed Breakdown

The formula above is derived from the following components:

New Customer Orders = sum(if(is_new_customer, 1, 0)) --> Orders table

Insights and Actions

New Customer Orders is a critical metric for assessing the effectiveness of your acquisition strategies. Efficiently leveraging New Customer Orders data can guide strategic business decisions:

• Evaluate Marketing Campaign Success: Compare new customer orders before and after specific marketing campaigns to gauge their effectiveness in attracting new customers.
• Optimize Acquisition Channels: Identify which marketing channels are generating the most new customer orders and allocate more budget to these high-performing channels.
• Refine Target Audience Profiles: Analyze the demographics and behavior of new customers who placed orders to refine targeting for future campaigns.
• Improve Onboarding Experience: Tailor the shopping and onboarding experience based on insights from new customer orders to encourage repeat purchases and loyalty.

Example Use

Prompt

How many new customer orders were there in the past 30 days?

Response

Query

SQL

SELECT
  COUNT(ot.order_id) AS new_customer_orders
FROM
  orders_table AS ot
WHERE
  ot.is_new_customer = TRUE
  AND ot.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;