Customer Acquisition Cost Analyzer
Operations & HR Finance
Quick Answer
Enter your marketing spend and customers acquired by channel. Paste into Claude or ChatGPT. Get CAC by channel with efficiency ranking and spend reallocation recommendations.
What You Get
A CAC analysis by channel covering spend efficiency, CAC per channel with comparison to blended CAC, channel quality assessment beyond just cost, reallocation recommendations, and a framework for ongoing CAC monitoring.
Who Is This For
Marketing teams optimizing channel allocation, CFOs challenging marketing spend efficiency, and growth leaders preparing channel performance reports for investors.
About This Template
Most companies know their blended CAC but few understand it at the channel level. Blended CAC hides the reality that some channels are extremely efficient while others destroy value. This template guides marketing and finance teams through entering their spend and customer acquisition data by channel, then uses AI to calculate CAC by channel, identify the most and least efficient acquisition sources, and produce specific recommendations to reallocate spend toward higher-efficiency channels.
Fill In Your Details
Your company name
e.g. Q2 2026 or trailing 12 months
e.g. Outbound sales: $180,000 spend, 42 customers acquired
e.g. Paid search: $65,000 spend, 28 customers acquired
e.g. Content and SEO: $35,000 spend, 18 customers acquired
e.g. Partner referrals: $20,000 spend, 22 customers acquired
e.g. Events and conferences: $45,000 spend, 8 customers acquired
e.g. $35,000 LTV across all customers
Any differences in customer quality by channel e.g. partner referrals have 30% lower churn than outbound
Gather these details then use them to fill in the prompt below.
AI Prompts
Generate CAC analysis by channel
Paste this prompt into Claude or ChatGPT with your channel data filled in.
You are a growth analyst evaluating customer acquisition cost efficiency by channel. Using the data below, produce a comprehensive CAC analysis. Company: [company_name] Period: [period] Channel 1: [channel_1] Channel 2: [channel_2] Channel 3: [channel_3] Channel 4: [channel_4] Channel 5: [channel_5] Average LTV: [average_ltv] Channel quality notes: [quality_notes] Produce: 1. CAC by Channel β calculate CAC for each channel (spend divided by customers acquired) 2. Blended CAC β total spend divided by total customers 3. LTV/CAC by Channel β efficiency ratio for each channel 4. Channel Efficiency Ranking β rank channels from most to least efficient 5. Quality-Adjusted Analysis β if quality notes provided, adjust the ranking for customer quality differences 6. Reallocation Recommendation β specific spend shifts to improve blended CAC 7. Channels to Eliminate or Scale β which channels to cut and which to double down on 8. CAC Monitoring Framework β what to track monthly to manage CAC proactively Flag any channels where LTV/CAC is below 3x as they are destroying value.
Sample Output
This is an example of what AI produces when you use this template.
CAC by Channel Ranking
Partner referrals: $20,000 divided by 22 customers equals $909 CAC, LTV/CAC 38.5x. Content and SEO: $35,000 divided by 18 customers equals $1,944 CAC, LTV/CAC 18.0x. Paid search: $65,000 divided by 28 customers equals $2,321 CAC, LTV/CAC 15.1x. Outbound sales: $180,000 divided by 42 customers equals $4,286 CAC, LTV/CAC 8.2x. Events: $45,000 divided by 8 customers equals $5,625 CAC, LTV/CAC 6.2x. Blended: $345,000 divided by 118 customers equals $2,924 CAC, LTV/CAC 12.0x.
Reallocation Recommendation
Immediate action: cut events budget from $45,000 to $15,000 β keep only the 1-2 events with demonstrable pipeline attribution and eliminate the rest. Reallocate $30,000 to partner program investment. Partner referrals at $909 CAC with 30 percent lower churn (per your notes) are your most efficient and highest-quality acquisition channel by a significant margin. Investing $30,000 more in the partner program could generate 33 additional customers at partner CAC β versus 7 additional customers at events CAC. Expected impact: blended CAC reduces from $2,924 to approximately $2,650, and customer quality improves as the mix shifts toward lower-churn partner referrals.
Related Resources
Prompts
AI Workflows
Software