Customer Acquisition Cost Tracking Analysis

Project Overview

Marketing teams often increase spending across multiple channels with the assumption that higher investment will automatically lead to more customers. In reality, growth depends less on how much is spent and more on how efficiently customers are acquired

This project analyzes customer acquisition cost (CAC) data to evaluate marketing performance across campaigns and channels. Using Excel and Power Query, the analysis focuses on understanding acquisition efficiency, identifying cost drivers, and highlighting opportunities to improve return on marketing investment.

Project Objectives

The primary objectives of this analysis are to:

1. Measure customer acquisition efficiency across marketing channels

2. Identify high-performing and underperforming campaigns

3. Track trends in CAC, revenue, and conversion rates over time

4. Understand the relationship between marketing spend and customer growth

5. Support data-driven decisions for optimizing marketing strategy

Tools Used:

1. Excel - For Data Analysis, DAX, Visualization and Storytelling.

2. Power Query - For Data Cleaning and Transformation.

3. Power BI - For Wireframe Design

4. Medium - Report Writing

Report

Key Insights

1. High-level ROI is driven by substantial scale:

The analysis of over 39,000 campaigns revealed a staggering $24B in revenue generated from a $611M spend, resulting in an average ROI of 4,390.8%. This indicates a highly efficient marketing engine at a massive scale.

2. Cost-per-acquisition varies significantly across channels:

While Google Ads and Social Media dominate in volume, the CAC (Customer Acquisition Cost) fluctuates between channels. Influencer marketing shows a unique ability to drive high-value conversions, though often at a different cost structure than automated ad platforms.

3. Demographic targeting is a key driver of efficiency:

Marketing efficiency is not uniform across age groups. Certain segments show much higher conversion rates for every dollar spent, suggesting that "blanket" marketing spend is less effective than age-defined targeting.

4. Ad spend and revenue show a strong correlation, but with diminishing returns:

While increasing spend generally leads to higher revenue, the data identifies specific "tipping points" where the Cost Per Click (CPC) rises without a proportional increase in conversion, indicating budget saturation in certain channels.

5. Engagement metrics serve as leading indicators for CAC:

There is a direct link between high engagement rates (likes/shares) and lower acquisition costs. Campaigns that resonate emotionally or socially tend to lower the overall CAC by organic amplification, reducing the reliance on paid reach.

Recommendations

1. Reallocate budget to high-performing "Power Channels":

Prioritize spending on Google Ads and Social Media while scaling Influencer partnerships that demonstrate the lowest CAC. Shifting funds away from stagnant channels will optimize the overall portfolio ROI.

2. Implement demographic-specific bidding strategies:

Tailor ad spend intensity based on the conversion profiles of different age groups. By bidding more aggressively for high-converting demographics and reducing spend on low-resonance segments, the business can lower its average CAC.

3. Optimize creative content to drive organic engagement:

Focus on developing "shareable" content that boosts engagement metrics. Since higher engagement correlates with lower acquisition costs, investing in creative quality can significantly reduce the required paid media spend.

4. Set CAC thresholds to prevent budget waste:

Establish clear CAC ceilings for each channel. When a campaign exceeds these predefined limits due to rising CPCs or market saturation, the system should trigger an automatic budget pause or a creative refresh.

5. Leverage seasonal trends for peak acquisition

Align heavy marketing spend with historical periods of high conversion and lower competition. Timing the largest budget outlays to match consumer readiness ensures a more favorable Revenue-to-Spend ratio.

Conclusion

This analysis demonstrates that customer acquisition success depends on efficiency, not just spending. By using Excel and Power Query to track CAC, revenue, and conversion performance, this project provides actionable insights that support smarter marketing decisions and sustainable growth.