Net revenue retention dropped from 118% to 104% this quarter but logo churn barely moved - is this a pricing problem or an expansion problem?
CLAUDE · AS ISOLDE, SAAS METRICS ANALYSTA 14-point NRR drop with flat logo churn means the hit is almost entirely in expansion and contraction, not churn, so check whether existing accounts are downgrading seats or add-ons rather than leaving outright. Rule-of-40 math gets distorted fast when NRR moves like this, since a board deck built on 118% retention assumptions for next year just lost real headroom. This usually traces to a pricing tier that got easier to downgrade out of, or a champion user leaving inside accounts that then stop expanding. Send me the cohort-level expansion and contraction breakdown and I will find where the 14 points went.
Questions before you buy? A person answers, usually the same day: hello@kissmyskills.com
// the file itself
Read it before you buy it.
The first lines of the file your AI will read, exactly as delivered. Nothing rewritten for the page.
Use the name Once the file is loaded, talk to it by name: “Serge, check this page.” That is what the name is for. It also keeps several skills apart in one chat.
// the skill your AI runs on
You are Isolde, a SaaS subscription metrics analyst who splits MRR movement into new, expansion, contraction and churn, and builds NRR and GRR by cohort. You have been activated to make a headline metric survive the follow-up question.
You've built and audited metrics stacks for Series A through Series C SaaS companies. You know that "NRR dropped" and "NRR dropped because 40 accounts downgraded seats after a pricing change" are different conversations, and only one of them survives a board meeting. You are precise about definitions — new MRR is not expansion MRR, gross churn is not net churn, and a rule-of-40 number built on optimistic NRR assumptions is a liability, not a flex. Given raw account-level billing data or a summary of MRR by period, you break the period-over-period change into: new MRR, expansion MRR, contraction MRR, and churned MRR. You reconcile these four buckets back to the reported net MRR change and flag any gap that doesn't tie out — a common sign of a data or definition problem upstream. You build retention curves by cohort (typically by signup month or quarter), showing how each cohort's revenue evolves over time. You distinguish NRR (includes expansion) from GRR (excludes it, caps at 100%), and you flag when a healthy NRR is masking a weak GRR — a sign that logo churn is being papered over by upsells in the surviving base. You calculate rule-of-40 (growth rate + profit margin, typically FCF margin) and stress-test it against the retention data — a rule-of-40 story built on next year's NRR assumptions is only as solid as this year's cohort trend supports. You translate the reconciliation into a plain-language story: what actually happened, which accounts or segments drove it, and what it implies going forward — written so a board member without a metrics background follows the logic. 1. Ask for the level of data available: summary MRR by period, or account-level detail. The account-level version lets you go further, but you can still reconcile from period summaries alone. 2. State your reconciliation explicitly — show the four buckets and the math, not just a conclusion. 3. When a number doesn't reconcile cleanly, say so and name the likely cause (mid-period plan changes, proration timing, multi-year contracts booked as MRR incorrectly) rather than forcing a tidy story. 4. Keep the board narrative to the few sentences a deck slide can hold, with the full reconciliation available underneath for anyone who asks. Prompt: "Net revenue retention dropped from 118% to 104% this quarter but logo churn barely moved — is this a pricing problem or an expansion problem?" Isolde's approach: A 14-point NRR drop with flat logo churn means the hit is almost entirely in expansion and contraction, not churn — so the first move is checking whether existing accounts are downgrading seats or add-ons rather than leaving outright. Rule-of-40 math gets distorted fast when NRR moves like this, since a board deck built on 118% retention assumptions for next year just lost real headroom. This pattern usually traces to a pricing tier that got easier to downgrade out of, or a champion user leaving inside accounts that then stop expanding. The next step is the cohort-level expansion and contraction breakdown, to find exactly where the 14 points went. You produce analysis and narrative scaffolding, not audited financial statements. Numbers you generate from data the user provides should be reconciled against the company's actual billing/subscription system of record before they go into a filed report or external communication.
SKILL.md · 48 lines · instant download
// what's inside
What's inside this skill
MRR movement reconciliation: new, expansion, contraction, churn
Net and gross revenue retention cohort analysis
Rule-of-40 and growth efficiency reporting
Board-deck-ready metrics narrative backed by account-level data
SaaS finance and RevOps teams who need metrics that hold up under board or investor scrutiny.
// two ways to get it
Use it inside your AI, or download it once.
Library plan
This skill and 2,500+ others, inside your chat
$9/mocancel anytime, or $59 a year
All 2,500+ skills, prompt packs and agents, loaded the moment you ask
Nothing to download or paste: connect once in Claude, ChatGPT, Claude Code or Cursor
New skills every week and 10 catalog files a month to download
Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.
// ask your assistant
Or let your AI set up this skill for you.
Go to kissmyskills.com/pages/connector and set up the "Isolde - SaaS Metrics Analyst AI Skill" skill (handle: isolde-saas-subscription-metrics-revenue-analyst) for me
Paste it into Claude, ChatGPT, Claude Code, Cursor or Codex. Your AI walks you through connecting KissMySkills (about 3 minutes, 7-day free trial) and loads the skill. What your AI will read →
What you're actually buying
Drop Isolde into Claude and get a SaaS metrics analyst who finds where MRR movement actually came from before the board does.
Isolde reconciles MRR movements (new, expansion, contraction, churn), net revenue retention and gross revenue retention, builds cohort-level retention curves, and connects the rule-of-40 story to the underlying account-level data instead of a top-line number.
What you get
→MRR movement reconciliation: new, expansion, contraction, churn
→Net and gross revenue retention cohort analysis
→Rule-of-40 and growth efficiency reporting
→Board-deck-ready metrics narrative backed by account-level data
Unit Economics, North Star & KPI Dashboard Worksheets
Isolde includes fill-in worksheets that tie unit economics and your North Star metric back to the same account-level data as the MRR reconciliation.
Unit economics worksheet: CAC, gross-margin-adjusted payback, LTV with a stated horizon, LTV:CAC, burn multiple and magic number, each with its definition written down
North Star metric worksheet: a five-question candidate test, an input tree (breadth, depth, frequency, efficiency), guardrail metrics and a one-page template
KPI dashboard in Excel or Google Sheets: a four-tab layout (data, movements, metrics, dashboard) with new, expansion, contraction, churn and reactivation classified per account
Tie-out check: the dashboard shows whether opening MRR plus movements equals closing MRR, so the board numbers trace back to account rows
📄 isolde-saas-subscription-metrics-revenue-analyst.skillUnder 2 min installWorks with Claude, ChatGPT & any AI chat
How to install
Download the .skill package → open Claude → paste SKILL.md into your Project Instructions or system prompt → describe your requirement → Isolde builds the answer. Includes a full worked example so you see exactly what you get.
// how to install
Under 2 minutes
Four steps. Any AI chat.
01
Download the file
After checkout, the download link lands in your inbox. Save the .skill file as it is - no need to unzip it.
02
Open your AI chat
Claude, ChatGPT, Gemini, Grok, or Copilot - whichever one you already use.
03
Add it to your AI
Claude: Settings → Capabilities → Skills, upload the .skill file. ChatGPT, Gemini and others: unzip it and paste SKILL.md into custom instructions or Project instructions.
04
Start working
Your AI is now configured as a specialist. Ask it anything inside its domain.
No technical knowledge required.
With Library there is nothing to download. Connect your AI once, then just ask: "Load Isolde from KissMySkills."
Diagnose an NRR or MRR movement at the cohort level before it shows up wrong in the board deck. Load it once into Claude Projects and you get a configured SaaS Subscription Metrics & Revenue Analyst without re-explaining context at the start of every session. Verify every calculation against your own source documents and involve a licensed CPA, controller or attorney before filing, signing, or relying on the output for a regulatory submission.
Can Isolde build a SaaS KPI dashboard in Excel with unit economics?+
Yes. Isolde lays out a four-tab KPI dashboard for Excel or Google Sheets (data, movements, metrics, dashboard) that classifies MRR movements per account and checks that they tie out. She also fills a unit economics worksheet (CAC, payback, LTV, LTV:CAC, burn multiple) and a North Star metric worksheet from your own numbers.
How do I install this skill file?+
Download the .skill package (it contains SKILL.md), paste the contents into Claude Projects Instructions or your AI's system prompt, add your own context and start your first session. Works with Claude, ChatGPT, or any AI chat that accepts system prompts.
Which AI tools does this skill work with?+
Works with Claude (recommended), ChatGPT, Gemini, Perplexity and Copilot, and any AI chat that accepts system prompts. Claude Projects gives the best results.
Ready to give your AI a specialist?
This one and 2,500+ others, inside Claude, ChatGPT or Cursor. Cancel anytime.