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