Data Dictionary

Overview

Measures efficiency of advertising and lead generation efforts.

Formula

Insights and Actions

• Efficiency Check — Lower CPA indicates cost-effective marketing performance.
• Budget Allocation — Helps identify which campaigns yield the best acquisition cost.
• ROI Measurement — A key input for profitability analysis.
• Trend Tracking — Detect shifts in customer acquisition costs over time.
• Optimization Opportunities — Identify underperforming ads or audiences.

Detailed Breakdown

• Ad Spend= Ad Spend = SUM(spend_amount)
• Conversions= Total number of conversions during the selected period

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT COALESCE(SUM(spend) / NULLIF(SUM(conversions), 0), 0) AS cpa FROM spends WHERE spends_date BETWEEN :start AND :end;