Cohort LTV Reader
Read retention by acquisition cohort against what each cohort cost, and say plainly when it is too early to judge.
Works across your stack
Supported AI platforms
8 supported clients. Connector requirements are shown separately below.
Add the LTV calculation skill to your AI client
Set up the Adspirer "Cohort LTV Reader" skill for me. If you can run commands: npx adspirer-skills add ltv-calculation If not: fetch https://www.adspirer.com/skills/ltv-calculation.md and follow it. Then read the skill and ask me what you need to get started.
Paste it into Claude, ChatGPT, Cursor, Codex, Gemini, or any agent — it works out how to install itself.
Or install it yourself
npx adspirer-skills add ltv-calculation Writes SKILL.md to .claude/skills/ in the current project. The bundled references, scripts, and assets ship with the ZIP. Download ZIP →
Upload the ZIP in Claude → Settings → Skills. The bundle preserves every reference, script, and asset.
Install the Adspirer plugin first: Cowork tab → Customize (left sidebar) → Plugins → Browse Plugins → search "Adspirer" → Install. Requires Claude Max, Team, or Enterprise. Then upload this ZIP as a skill.
In ChatGPT, open Plugins → Skills → Create → Upload from your computer. ChatGPT scans the skill before making it available. Availability and upload permissions depend on your workspace plan and admin settings.
npx adspirer-skills add ltv-calculation --agent cursor Writes the skill to .cursor/rules/ in the current workspace, so Cursor loads it on every session.
npx adspirer-skills add ltv-calculation --agent codex Appends the skill to AGENTS.md, which Codex reads on every session — so it persists instead of living in one conversation. The append is idempotent; re-running it will not duplicate the block.
npx adspirer-skills add ltv-calculation --agent gemini Appends the skill to .gemini/GEMINI.md, which the Gemini CLI reads on every session. Connect Adspirer as an MCP server first so the live ad-account steps can run.
npx adspirer-skills add ltv-calculation --agent windsurf Writes the skill to .windsurf/rules/ in the current workspace, so Windsurf loads it on every session.
npx adspirer-skills add ltv-calculation --agent other Writes SKILL.md to adspirer-skills/ in the current folder — point any agent at that file. No shell? Fetch the raw file with curl -fsSL https://www.adspirer.com/skills/ltv-calculation.md, which prints the skill instead of installing it.
Starter prompt
Client setup guide →Use the Cohort LTV Reader skill. I’m working on [campaign or account] and want to understand [goal or problem] for [date range]. Check that Adspirer and PostHog are connected, start by looking without changing anything, and explain the story in plain language. Show me the evidence and ask before making any live change.Where it helps
When to use the LTV calculation skill
A per-cohort read on payback and retention by channel — or an honest statement that the account is too young to answer it yet.
Use case 1
A budget increase is being considered
Scaling on platform ROAS alone can double spend on customers who do not stay.
Use case 2
Acquisition costs have drifted up
The question is whether the customers being bought still pay back, not just whether they convert.
Use case 3
Channels look similar on day one
Two sources produce the same conversion cost but very different retention.
See it in a campaign
LTV calculation examples
The numbers, account, and recommendation will be yours. These show the kind of story the skill helps you work through.
Newer cohorts quietly worse
Blended numbers look stable because older cohorts carry the average.
The skill compares cohorts at equal age, which is what exposes the decline the totals were hiding.
Too early to judge
The oldest cohort is a few weeks old on a monthly billing cycle.
The skill declines to project and states the date the question becomes answerable.
Keep reading: Meta Ads setup docs ·Claude ad management ·PPC reporting tools guide
Keep building the workflow
Agent skills related to LTV calculation
Anomaly Triage
Follow the clues behind a sudden campaign change, explain what is happening in plain language, and route the next step to the right person.
Client-Ready Monthly Report
Produce a client-ready monthly report: performance vs goals, what changed and why, wins and learnings, next month's plan — clear, honest, and defensible.
The Attribution Detective
Account for the gap between platform, analytics and backend numbers, and say which source answers which question.
Before you install
Frequently asked questions
What is the LTV calculation skill?
It is an Agent Skill — a folder of instructions your AI assistant loads when you ask it to do this job. It follows the open Agent Skills specification, so the same package works across different assistants. Read retention by acquisition cohort against what each cohort cost, and say plainly when it is too early to judge. Unlike a prompt you paste in, the skill carries its own procedure, checks, and stop conditions, so the assistant works the same way every time you run it.
Which AI assistants can run it?
Claude, Claude Code, Claude Cowork, ChatGPT, Codex, Cursor, Gemini and Windsurf. Download the ZIP and upload it in assistants that accept skill folders, or point the assistant at the raw SKILL.md file. The install card above has the exact step for each one.
What do I need to connect before I run it?
Adspirer and PostHog are required, because the skill reads live account data rather than guessing. The skill confirms the connection before it touches a real account, and tells you plainly if something is missing.
Do I need an Adspirer account, and is there a free tier?
The skill itself is free to download and MIT-licensed. To let it read or change real ad accounts you need Adspirer connected: the free tier includes 15 tool calls a month, Plus is $49/mo for 150, Pro is $99/mo for 600, and Max is $199/mo for 3,000. You can install the skill and read what it does before signing up for anything.
Can it change my campaigns without asking?
No. Any new campaign Adspirer creates is created paused, enabling a paused or live campaign needs your confirmation, and destructive actions are gated behind an explicit confirmation flag. Spend, publishing, and live changes wait for your approval every time — installing a skill or a connector is not itself approval to act.
How do I get the best results from it?
Give it the specifics it asks for up front — the account or campaign, the date range, the goal, and what "good" looks like for this business. Let the first pass run read-only so you can check the evidence before anything changes. The starter prompt above is a working template; edit the bracketed parts and paste it in.
How is this different from just asking the assistant directly?
A plain prompt gets you a plausible answer from whatever the model already knows. This skill makes the assistant pull real numbers from your accounts and analytics, follow a fixed procedure, show its evidence, and stop at the points where a person should decide. That is the difference between a confident guess and a ltv calculation you can act on.
Ready to run it against real campaigns? Connect Google, Meta, Amazon, LinkedIn, TikTok, or ChatGPT Ads to your assistant on the free tier — nothing spends or publishes without your approval. Create a free Adspirer account →