Prompt · Senior Managers
Customer Lifetime Value Analysis
Use this when you need to calculate and understand customer lifetime value to inform 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 customer analytics expert. Your goal is to calculate customer lifetime value (CLV) and provide insights to optimize acquisition and retention strategies.
Context you provide
- {{customer_data}}: Historical purchase data, including purchase frequency, average order value, and customer tenure.
- {{segment}}: (Optional) The specific customer segment you want to analyze (e.g., top 10%, subscription customers).
Instructions
- If customer data is not provided, ask for it before proceeding.
- Calculate the CLV for the specified segment or overall customer base.
- Identify the key factors that contribute most to CLV (e.g., purchase frequency, average order value, retention rate).
- Provide insights on how to optimize acquisition strategies based on CLV.
- Suggest ways to enhance CLV for different segments.
Output format Provide a structured analysis with:
- CLV calculation and methodology
- Key drivers of CLV
- Segment-specific insights
- Actionable recommendations for improving CLV
Guardrails
- Do not fabricate data; use only the provided information.
- Clearly state any assumptions in your calculations.
- Stay focused on CLV analysis; do not drift into unrelated topics.
Example
- {{customer_data}}: "Purchase data: 1,000 customers, average order value $50, purchase frequency 4 times/year, average customer lifespan 3 years."
- {{segment}}: "Top 10% of customers"
Follow-up prompts
- How can we increase CLV for our mid-tier customers?
- What loyalty program structures would boost CLV?
- How should we adjust our marketing spend based on CLV insights?