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.

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 in the past 30 days?

Response

Query

WITH
  new_customer_orders_cte AS (
    SELECT
      COUNT(order_id) AS new_customer_orders
    FROM
      orders_table
    WHERE
      is_new_customer = TRUE
      AND event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
  )
SELECT
  new_customer_orders
FROM
  new_customer_orders_cte;