AgentRetention & LTV

Lifetime value report

12-month profit LTV curve vs your industry benchmark — where the gaps are and what to do about them.

Works with
ClaudeChatGPTAny MCP-compatible AI tool
Requires
StoreHero MCPShopifyKlaviyo
Get the prompt
Example chat in Claude. You ask: "Run the Lifetime Value Report on all customers". Claude reads your StoreHero data and answers: Your 12-month profit LTV is $72 per customer, 10% behind the benchmark. The gap opens between months 1 and 3. It adds an interactive example chart, Profit LTV per customer vs benchmark, with example data you can switch below.
Profit LTV per customer vs benchmarkExample

Example, Profit LTV: Month 12: $72 vs $80 benchmark

  • M1: $28 (industry benchmark $30)
  • M3: $41 (industry benchmark $46)
  • M6: $55 (industry benchmark $60)
  • M12: $72 (industry benchmark $80)

Dashed line: industry benchmark

Month 1: $28 per customer, close to the $30 benchmark.

The prompt

How to run it

Paste it into a new chat in Claude or ChatGPT and you get the answer straight away.

Use the StoreHero MCP to do the following analysis. Always anchor the answer in real StoreHero data, not platform-reported metrics.

Give me a lifetime value report. Use the LTV page and the LTV by first purchase page in the StoreHero connector.

Show the customer profitability picture across the trial months after first purchase — month 1, month 3, month 6, month 12. Pull gross profit per customer, repeat order rate, and cumulative LTV at each milestone. Compare the brand's curve to the StoreHero benchmark for their industry and revenue band.

Place the brand on the curve: are they best-in-class, average, or trailing for their category? Be honest — don't soften it.

For each underperforming milestone, give a specific action to close the gap: (1) post-purchase product recommendation strategy if month 1–3 is weak, (2) replenishment cadence improvements if month 6 is weak, (3) win-back automation and category expansion if month 12 is weak.

If Klaviyo flow data is connected and complete, layer in flow-level performance to identify which retention flows are pulling weight and which are gaps. If the Klaviyo data has obvious holes, missing flows, or doesn't align with the orders data, skip it entirely and don't reference it — don't half-use incomplete data.

End with: where the biggest LTV unlock is, what a 10% improvement to month-12 LTV would mean for nCAC headroom and ad scaling capacity.

At the bottom of your answer, render an inline visual summary: a line chart of cumulative profit LTV over 12 months with the brand's curve and the benchmark curve overlaid, plus KPI cards for current 12-month LTV, vs benchmark gap, and projected uplift if best-practice actions are taken. Place text commentary alongside the visuals. Use the Spend Advisor tool to suggest what to explore next.

Get the full prompt

Enter your email to see every prompt in full and copy it in one click. It unlocks the whole library.

See our privacy policy.

How to use a skill

New to skills? It takes three steps and a few minutes: connect StoreHero once, copy a skill into Claude or ChatGPT, and ask.

  1. Connect StoreHero to Claude or ChatGPTAdd the StoreHero MCP connector once. It works with Claude, ChatGPT and any other tool that supports MCP. Setup guide
  2. Pick a prompt and copy it into ClaudeOpen one, press Copy prompt (or download the file) and paste it into a new chat.
  3. AskIt pulls your live StoreHero data and gives you the analysis in minutes. Ask follow-up questions in the same chat.

Run every prompt on your own numbers.

Connect your store to StoreHero and the whole library works on your live profit data.