Prompt: Analyze My Customer Acquisition Cost

This prompt analyze customer acquisition cost gives you a full CAC breakdown by channel with trends and optimization recommendations. Knowing your CAC is table stakes. Knowing your CAC by channel, by month, and by customer segment is where the real decisions live.

The Prompt

You are a marketing finance analyst. Analyze my customer acquisition costs.

Monthly data (paste as many months as you have):

| Month | Total Marketing Spend | Channel 1 Spend | Channel 1 Customers | Channel 2 Spend | Channel 2 Customers | Channel 3 Spend | Channel 3 Customers | Total New Customers |
| [paste your rows] |

Business context:
- Average customer value: [monthly revenue per customer]
- Average customer lifetime: [months]
- Customer lifetime value (LTV): [total]
- Target CAC: [what you want to pay per customer]
- Business model: [subscription / one-time / retainer]
- Include any operational costs in CAC: [e.g., sales team salaries, onboarding costs]

Analyze:

1. OVERALL CAC:
- Blended CAC (total spend / total customers)
- CAC by channel
- Trend: rising, falling, or stable over the time period
- LTV:CAC ratio and what it means for your business health

2. CHANNEL EFFICIENCY:
- Rank channels by CAC (best to worst)
- Rank channels by volume (most customers to least)
- The efficiency vs scale tradeoff: cheapest channel may not be scalable
- Which channel deserves more budget and which deserves less?

3. TREND ANALYSIS:
- Is CAC increasing or decreasing over time? By how much per month?
- Seasonal patterns in acquisition costs
- Are any channels getting more expensive faster than others?
- At what point does spending more on a channel start producing diminishing returns?

4. PAYBACK PERIOD:
- How many months until a customer covers their acquisition cost?
- By channel: which channels have the fastest payback?
- Cash flow implication: can you afford the payback period?

5. OPTIMIZATION RECOMMENDATIONS:
- Top 3 specific actions to reduce blended CAC
- Budget reallocation: move $X from [channel] to [channel] because [reasoning]
- The CAC ceiling: at what CAC does the business stop making money?

6. MISSING DATA:
What data would I need to make this analysis more precise? What am I probably not tracking that I should be?

Show all calculations. I want to verify the math and learn to do this analysis myself.

The LTV:CAC Ratio

A healthy ratio is 3:1 or higher. Below 3:1, you are spending too much to acquire or not earning enough per customer. Above 5:1, you might be under-investing in growth.

Section 6: Missing Data

This section is surprisingly valuable. Most businesses discover they are not tracking something critical. The most common gap: not separating new customer costs from existing customer retention costs. Those are different budgets solving different problems.

Build These Systems

Ready to implement? These step-by-step tutorials show you exactly how:

• How to Build a Customer Sentiment Analysis for Tickets - Analyze ticket sentiment to prioritize frustrated customers automatically.
• How to Build a Review Sentiment Analysis Dashboard - Analyze review sentiment trends to identify improvement areas.
• How to Build a CPA Tracking and Alert System - Track cost per acquisition in real-time and alert when CPA exceeds targets.