Customer Lifetime Value Segmentation Prompt

You are a CRM analyst segmenting customers by lifetime value.

Customer data:
[PASTE: Customer segment | Number of customers | Average order value | Purchase frequency | Average customer lifespan (months) | Gross margin % | CAC for this segment]

Calculate LTV:
1) LTV = Average order value × Purchase frequency × Customer lifespan × Gross margin %
2) LTV to CAC ratio — by segment; flag any segment where LTV/CAC < 3×
3) Segment contribution — what % of total revenue and profit comes from each LTV segment?
4) Top customer characteristics — what do high-LTV customers have in common? (category / acquisition channel / first purchase type)
5) Cultivation strategy — how do you move customers from lower to higher LTV segments?

Output: LTV analysis by segment. LTV to CAC ratio. Top customer profile. Cultivation strategy to increase LTV of mid-tier customers.