download dots
AI PromptsCategoriesCalculators

💎 Work Out What a Customer Is Worth

Build the calculator you keep rebuilding in a spreadsheet, then put it on a link anyone can use. These prompts turn a formula into a working app: clean inputs, a result people trust, a saved record of every calculation, and an assistant that explains what the number means. Useful on your own desk, and useful in public as the page that brings people to you.
  • Tested prompts
  • Edit for your use case
  • Works across models
  • Save in Taskade
Work Out What a Customer Is Worth

Copy

I do not know what a customer is worth so I have no idea what I can spend to get one. Build me a lifetime value calculator. Let me enter, per customer segment, the average order value, the gross margin percentage, the average number of purchases per year and the average number of years a customer stays. Work out lifetime revenue and lifetime gross profit, and make clear that the profit figure is the one to make decisions on. Let me enter my acquisition cost per segment and show the ratio between value and cost, plus the payback period in months. Show segments ranked by lifetime profit rather than by revenue or by volume. Add an AI agent that reviews the segments and tells me plainly where I am overspending to acquire customers who are not worth it, and where I could afford to spend far more. Automate a scheduled quarterly recalculation using actual order data and an alert when a segment repeat rate falls. Two logins: an owner who sees all segments, and a marketer who sees the acquisition figures.

Run this prompt with AI
STATUS · LIVE
v1

01 / Spark - intelligence awakens

Work Out What a Customer Is Worth

Work out lifetime value by segment on margin, compare it to acquisition cost, and find your most valuable customers.

Start with AI
// the spark catches · intelligence awakens · the answer unfolds

Knowing what a customer is worth tells you what you can afford to spend winning one. This works it out from real numbers and compares it to what you actually pay.

What's Included

  • Lifetime value by segment not one blended figure that hides everything.
  • Acquisition cost beside it which is the comparison that matters.
  • Margin-based rather than revenue-based so the number is honest.
  • An assistant that names your most valuable segment.

How To Use

  1. Calculate on margin, not revenue, or you will overspend on acquisition.
  2. Split by segment. The average customer usually does not exist.
  3. Compare against acquisition cost. Alone the number is just interesting.
  4. Recalculate quarterly. Repeat rates move faster than you think.

Feed it into the ROI calculator, and act on it with CRM prompts.

Related from the blog

Discover more

More Calculators Prompts

View all Calculators Prompts