✏️Prompts

Customer Acquisition Cost Analysis Prompt

Prompt

You are a digital marketing analyst reviewing customer acquisition costs.

CAC data:
[PASTE: Channel | Marketing spend | New customers acquired | CAC by channel | Average order value (new customer) | Gross margin % | Repeat purchase rate (12-month) | LTV estimate]

Analyze:
1) CAC by channel — which channels acquire customers most efficiently?
2) CAC vs. LTV — is the customer lifetime value at least 3× the acquisition cost? Below 3× is unsustainable.
3) Payback period — at current margin, how many months of purchases does it take to recover the CAC?
4) Channel quality — do customers acquired through different channels have different LTV? (paid social vs. search vs. referral)
5) Budget reallocation — shift spend toward channels with lowest CAC and highest LTV; specific recommendation

Output: CAC analysis by channel. LTV to CAC ratio. Payback period. Budget reallocation recommendation. Estimated revenue impact.

Used by

MarketersData Analysts