Skip to content
New this week26 prompts for Sora, Veo and Runway video workflows.
Explore video prompts→
AIPrompt123Prompt library

Search AIPrompt123

Search prompts, categories, platforms and repositories

Analyse customer lifetime value by segment

Analyse customer lifetime value by segment with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

4.8(30 ratings)556 copies
Updated By Site Admin
39 words · v1.2

Fill in the blanks · 1 variable

Claude promptReplace every highlighted token before sending
<task>
Calculate LTV by segment using the data below. Show assumptions for gross margin, churn and expansion. Identify which segment is most valuable after CAC and which is a trap. Flag any segment too small to be reliable.

Data:
{data}
</task>

Think carefully before answering. Keep any reasoning separate and put the final deliverable inside <answer> tags.
Open in Claude

Comments

Share what worked, what broke and which model you used. Comments appear after posting and are moderated for spam.

Saved with an anonymous browser ID. No login needed.

How to use this prompt

  1. 1

    Open Claude and start a new chat. Paste the prompt exactly as written.

  2. 2

    Replace each placeholder ({data}) with your own details. Leave the instructions and the output format untouched.

  3. 3

    Add one concrete example or data point if the model's first answer is vague. Specific input produces specific output.

  4. 4

    Run it once, then ask for a single revision with a specific critique rather than regenerating from scratch.

  5. 5

    Review the result. Every formula, input and tax assumption with an accountant or qualified analyst. This is not financial advice.

Worked example

This is the kind of input the prompt expects and the shape of output it produces. Your result will differ with the model and the details you supply.

Example input

Data: Paste an aggregated sample, never personal data.

Example output

**Base case:** revenue grows 18%, gross margin stays at 71%, CAC payback improves from 11 to 9 months. **Downside:** growth of 6%, churn +1.2 pts, 30-day slower collections. Closing cash falls below the three-month buffer in September. **Key sensitivity:** a 10% change in churn moves annual revenue by roughly 14%, more than any pricing change modelled. **Assumptions:** no new hires beyond plan, no FX movement, no debt drawdown. This is financial modelling, not investment advice. Verify tax treatment with an accountant.

Tips for a better result

  • State the currency, period, tax jurisdiction and decision being made up front.
  • Ask for formulas and a sensitivity table, not a paragraph of reassurance.
  • Treat every output as a model to check, not a forecast to trust.
  • Change one variable at a time and compare the outputs; it is the fastest way to learn what this model responds to.

Common mistakes

  • Treating a plausible model as a prediction.
  • Letting the model assume a growth rate without showing the basis.
  • Acting on AI-generated tax or investment guidance without a licensed professional.
Verified Knowledge · FAQ

Questions about this prompt

Practical answers about running the analyse customer lifetime value by segment prompt.

Related prompts

Same job, a different angle — or the next step in the workflow.

Finance & Trading
Intermediate

Build a trading journal template

This copy-ready finance prompt helps you build a trading journal template with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the details, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ChatGPTClaude
4.9(58)568 copies

Explain compound interest with a table

This copy-ready finance prompt helps you explain compound interest with a table with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ChatGPTClaude
4.8(42)520 copies

Build a 12-month cash-flow forecast

Build a 12-month cash-flow forecast with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ClaudeChatGPT
4.7(35)513 copies

Written and reviewed by Site Admin

Author & Platform Administrator

Administrator and lead editor at AIPrompt123, curating high-performance AI prompts, SEO/AEO/GEO strategies, and developer repositories.

Last reviewed 5 August 2026 · version 1.2 · tested on Claude, ChatGPT, DeepSeek