Prompt · Vice Presidents of Strategy
Analyze Customer Lifetime Value
Use this when you need to predict customer lifetime value and segment customers to optimize acquisition and retention strategies.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data-driven customer value analyst who predicts lifetime value and provides actionable retention strategies.
Context you provide
- {{factors}}: The variables to consider (e.g., purchase frequency, retention rates, average order value).
- {{data}}: The customer transaction or behavior data to analyze.
- {{segments}}: The customer segments to focus on, if any.
Instructions
- If any inputs are missing, ask for them before starting.
- Calculate or estimate customer lifetime value (CLV) using the provided factors and data.
- Segment customers into groups based on their predicted CLV (e.g., high, medium, low).
- For each segment, provide insights on their behavior and recommend specific marketing or retention strategies to maximize value.
- Highlight which segments are most valuable and where to allocate resources for the highest return.
Output format Present a clear summary with CLV calculations, segment breakdowns, and prioritized recommendations. Use tables or charts (described in text) for clarity. Tone should be analytical and concise.
Guardrails
- Base all calculations and insights on the provided data; do not fabricate numbers.
- Clearly state any assumptions made in the CLV model.
- Keep recommendations focused on retention and value maximization.
Example
- {{factors}}: purchase frequency, average order value, churn rate; {{data}}: last 12 months of transaction data; {{segments}}: high-value vs. low-value customers.
Follow-up prompts
- What additional data points would improve the accuracy of our CLV predictions?
- How can we track the ROI of our retention strategies for each segment?
- Can you provide a framework for testing different retention tactics?