Cohort Retention Analyzer

Group customers by kickoff month and turn retention into a curve, fitting decay, projecting LTV and computing NRR, GRR, Magic Number and Rule of 40 with a survivor-bias guard.

Turns the question 'are the customers who started in month X still with us?' into an answer that is a curve, not a single number. It groups customers by their kickoff month, fits retention decay (linear onboarding + exponential steady-state), projects LTV, and computes the SaaS health vitals: NRR, GRR, Magic Number and Rule of 40, with a built-in survivor-bias guard so departed customers stay in the denominator.

$15 one-time
Add to a kit →

Prices include 20% VAT. · Forged on real agency work · one-time, no lock-in

  • Type Skill
  • Category Growth & CRO
  • Delivery Email · instant
  • License One-time
Run preview
forgehouse, cohort-retention-analyzer

Inside the run · no black box

See the actual work before you buy it.

Retention math lies easily, mostly through survivor bias. Anchoring cohorts to first real payment and locking denominators in SQL, the analyzer fits decay curves, projects LTV three ways and scores its own forecasts.

  1. Assigns every customer to a cohort by kickoff month, derived from the date of their first completed payment, so cohorts are anchored to real money rather than signup forms.
  2. Builds the month-by-month retention matrix (M0 through M23) with a survivor-bias guard built into the SQL: the denominator stays locked at the cohort's starting size, so customers who left are never silently dropped from the math.
  3. Fits the retention curve with a hybrid model: linear decay for the first 3 onboarding months, exponential decay for steady state, then computes the cohort half-life, the number of months until half the cohort is gone.
  4. Projects lifetime value per customer three ways (linear, exponential, hybrid) and computes the SaaS health set on top: NRR, GRR, Magic Number and Rule of 40.
  5. Logs every forecast it makes against the actual that arrives a month later and scores the gap with a Brier score, so the model's calibration is continuously measured instead of assumed.
  6. Isolates the top 20% of cohorts by cumulative revenue (the power-law check) and asks what they share, sector, channel, onboarding intensity, turning the best cohorts into a replication target rather than a vanity stat.
Use cases · what happens when you plug it in

One power source. 6 lines out.

cohort-retention-analyzer · core

core active · 6 lines

  1. Answer 'which start-month cohort stayed longest?'

    ✓ answer 'which start-month
  2. Build cohort-based LTV projection for LTV/CAC

    ✓ build cohort-based ltv p…
  3. Report NRR, GRR, Magic Number, Rule of 40

    ✓ report nrr, grr, magic n…
  4. Render a cohort retention heatmap on a dashboard

    ✓ render a cohort retention
  5. Find the top 20% of cohorts driving most revenue

    ✓ find the top 20% of coho…
  6. Calibrate retention forecasts with a Brier score

    ✓ calibrate retention fore…
Benefits · what you walk away with

Yours to keep.

Drag time forward. Watch what stays.

Forever

That's what owning means.

The rented stack

ai writing tool: subscription

expired · access lost

analytics suite: subscription

expired · access lost

design platform: subscription

expired · access lost

(nothing left)

Your forge

  1. Avoid inflated retention claims with a fixed-cohort-size survivor-bias guard

    license: perpetual
  2. Forecast lifetime value with a hybrid decay model instead of naive linear math

    license: perpetual
  3. Track whether your forecasts are actually accurate over time, not just optimistic

    license: perpetual
  4. Surface the few cohorts that quietly produce most of your revenue

    license: perpetual

subscriptions expire · deeds don't

What's included · the full manifest

Everything in the box.

Pick a piece up. Watch it work.

Extended PostgreSQL cohort retention view with materialized refresh and indexes

part 01 of 06 · in the box

6 parts · one working system · ships instantly by email

Who it's for

This wasn't forged for everyone.

  • Not for you if you'd rather rent a tool than own one.
  • Not for you if you want someone else to run your stack.
  • Not for you if you're happy guessing.
Still here? Good.

For founders, RevOps and analytics teams who need defensible retention, LTV and SaaS-health numbers grounded in cohort data rather than survivor-biased averages.

then this was forged for you.

Works with

Universal by design: these run in any AI. Delivered in the open Agent Skills + MCP format (native in Claude); ChatGPT, Gemini, Cursor and Copilot adapt the same files their own way.

  • Claude Native format
  • ChatGPT Adapts via open standards
  • Gemini Adapts via open standards
  • Cursor Adapts via open standards
  • Copilot Adapts via open standards
Questions · still in the air

Catch what's on your mind.

the air is clear. nothing between you and the forge.
catch a spark: the forge will answer

  1. What do I need to feed it to get the cohort curves?

    It works from your customers grouped by their kickoff month with their retention or revenue over time, which is standard subscription data. From that it fits the decay and projects forward, so the input is history, not a forecast you supply.

  2. Why fit a curve at all instead of just averaging retention?

    Because a single average hides the shape: early churn during onboarding behaves differently from the slow steady-state decline. Modeling those two parts separately gives an LTV projection that holds up better than a flat number.

  3. Will the projection be trustworthy if I only have a few months of data?

    A projection is only as defensible as the history behind it, so thin cohorts give wide, uncertain curves. It computes the vitals like NRR and the Rule of 40 from what exists, but it cannot invent maturity you have not lived yet.

  4. How is it delivered?

    By email right after purchase: ready to run, downloaded instantly, no setup wait.

  5. One-time or subscription?

    A one-time purchase; no subscription or hidden fees. VAT (20%) is included.

  6. Can I get a refund?

    As a digital product, it can’t be refunded once downloaded. That’s why we show exactly what’s inside and who it’s for, right here.