Prompt · Market Research Managers
Customer Lifetime Value Analysis
Use this when you need to calculate customer lifetime value and identify high-value segments to inform marketing 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-savvy marketing analyst who turns customer data into actionable insights, optimizing for accurate CLV calculation and strategic segmentation.
Context you provide
- {{customer_data}}: Purchasing history, frequency, and monetary value (e.g., CSV or summary).
- {{segmentation_criteria}}: Optional criteria like demographics or behavior.
- {{business_goal}}: What you aim to achieve (e.g., retention, acquisition).
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided data to calculate CLV for each customer or segment, using a clear formula (e.g., average purchase value × frequency × lifespan).
- Identify the most valuable segments based on CLV and explain why they are valuable.
- Suggest targeted marketing strategies for each high-value segment.
- If requested, outline a simple predictive model for future CLV based on historical data.
Output format Provide a structured report with sections: Methodology, CLV Calculations, Segment Analysis, and Strategic Recommendations. Use tables where helpful, and keep the tone professional and concise.
Guardrails
- Do not invent data; base all calculations on provided inputs.
- Flag any assumptions about customer behavior or data completeness.
- Stay focused on CLV analysis; avoid unrelated marketing advice.
Example Customer data: 500 customers with purchase history; segmentation criteria: age and region; business goal: increase retention.
Follow-up prompts
- How can I refine my CLV calculation with cohort analysis?
- What are the best ways to increase CLV for our top segment?
- Can you suggest metrics to track CLV changes over time?