New Customer Cost per Acquisition (NCPA)

Overview

New Customer Cost per Acquisition (NCPA) is the total advertising spend (including both channel ad spend and custom ad spend) divided by the total number of orders by new customers.

📘

NCPA = (Ad Spend + Custom Ad Spend) / New Customer Orders

Detailed breakdown

The formula above is derived from the following components:

Ad Spend = SUM(spend) --> Ads table
Custom Ad Spend = SUM(IF(is_ad_spend, amount, 0)) --> Custom Spend table
New Customer Orders = count(1) orders --> Orders table

Insights and Actions

New Customer Cost per Acquisition (NCPA) measures the cost effectiveness of acquiring new customers through advertising. Optimizing NCPA enables more efficient marketing spending, directly contributing to sustainable business growth. Efficiently leveraging NCPA data can guide strategic business decisions:

• Marketing Efficiency: Lower NCPA indicates cost-effective customer acquisition, guiding efforts to streamline marketing strategies.
• Budget Allocation: Use NCPA insights to direct marketing budgets towards channels with the best customer acquisition cost efficiency.
• Campaign Optimization: Evaluate campaign-specific NCPA to pinpoint and scale successful strategies, improving overall marketing ROI.
• Targeting Refinement: High NCPA may signal the need for better targeting; analyzing successful acquisitions can help in reducing costs.
• ROI Analysis: Comparing NCPA against customer lifetime value aids in assessing the long-term profitability of acquisition strategies.

Example Use

Prompt

What's my NCPA for October?

Response