Signal Sparrow
Platform — Cohorts & LTV

See which channels bring customers that stay.

Acquisition tells you who signed up; cohorts tell you who's still paying six months later. Signal Sparrow tracks retention, LTV and LTV:CAC by the channel that acquired each cohort — read straight from Stripe subscriptions — so you double down on the sources that compound, not the ones that churn.

Retention from StripeLTV:CAC by channelReconciled to the centLive in 30 minutes
Cohorts & LTV, defined

Group customers by how you got them, then watch what they do.

SaaS cohort analysis groups customers by a shared starting point — usually the month and channel that acquired them — and tracks how their revenue behaves over time: retention, expansion, contraction and churn. LTV (customer lifetime value) is the total gross-margin revenue a customer produces before they leave, and LTV:CAC compares that to what you paid to acquire them.

LTV·(monthly ARPA × gross margin) ÷ monthly churn rate
LTV:CAC·LTV ÷ CAC
NRR·(start MRR + expansion − contraction − churn) ÷ start MRR

Signal Sparrow builds every cohort from Stripe revenue sync and keys it to the acquisition channel through revenue attribution — so retention and LTV reflect real subscription revenue, by source.

Net revenue retention112%
Blended LTV:CAC3.8:1
6-month retention29%
Avg. customer lifetime14 mo
Why blended LTV hides the truth

A healthy average can hide a channel that churns in weeks.

One company-wide LTV number tells you nothing about where durable revenue comes from — and retention inferred from page views isn't retention at all.

01

Blended LTV masks the mix

A strong 3.8:1 LTV:CAC can hide a channel retaining at 6 months and another that's gone by month two. Optimizing on the blend funds churn you can't see.

02

Page views aren't retention

Product-analytics tools infer "active" from events and logins. Only Stripe knows who's still paying. Revenue retention and usage retention are not the same number.

03

Expansion gets ignored

LTV that counts the first sale but not upgrades and downgrades undervalues your best channels — the ones whose customers expand — and overvalues cheap, flat ones.

How it works

From first click to lifetime value, by cohort.

  1. Step 01

    Group by acquisition source

    Every Stripe customer is tagged with the channel, campaign and month that acquired them, forming cohorts you can compare side by side.

  2. Step 02

    Track revenue over time

    We follow each cohort's MRR through trial conversion, expansion, contraction and churn — straight from Stripe subscriptions, not inferred from activity.

  3. Step 03

    Compute LTV & LTV:CAC

    Retention curves, LTV, net revenue retention and LTV:CAC are calculated per cohort and reconciled to your Stripe MRR.

Every channel, over time

Which cohorts retain, expand — and which quietly leak.

Instead of one LTV number, you get a retention curve and LTV:CAC for each acquisition channel, so budget flows to the cohorts that compound. Pair it with CAC payback and you have the full unit-economics picture.

Blended retention curve
100%
M1100%
46%
M246%
38%
M338%
33%
M433%
30%
M530%
29%
M629%
Channel (cohort)6-mo Ret.LTVCACLTV:CAC
LinkedIn · ABM48%$650$3102.1:1
Google · Brand search42%$920$1416.5:1
Meta · Prospecting24%$745$2333.2:1

Illustrative cohorts, reconciled to Stripe MRR. Channels below your LTV:CAC target surface in red.

What cohort truth unlocks

Spend where customers actually stay.

112%Net revenue retention, blended
14 moAverage customer lifetime
100%Of cohort revenue reconciled to Stripe

Illustrative figures based on typical results when teams reallocate budget toward channels with stronger cohort retention.

Reconciled to Stripe

LTV you can defend, not a hopeful projection.

LTV is easy to inflate and hard to trust. Signal Sparrow builds every cohort from Stripe and reconciles it to your real revenue: attributed plus direct/unknown equals your net MRR for the period, to the cent. The retention curves and lifetime values you present are grounded in payments, not assumptions.

Reconciled to Stripe91.4% match
Attributed$42,180Direct/unknown$6,920=$49,100
From insight to allocation

Turn retention into a budgeting decision.

Cohorts are only useful if they change where money goes. Signal Sparrow ranks channels by durable value — retention, expansion and LTV:CAC — so you can shift spend from cheap-but-churny sources to the ones that build a compounding revenue base.

Rank by LTV:CAC

Fund the channels that pay back and retain.

Spot silent churn

Cohorts that leak revenue surface early.

Reward expansion

Credit channels whose customers upgrade.

Compare vintages

See if newer cohorts retain better than old.

Cohort signalAllocation actions
Google · Brand — LTV:CAC 6.5:1✓ Scale
Meta · Prospecting — LTV:CAC 3.2:1✓ Hold
LinkedIn · ABM — 48% at 6 mo✓ High retention
30-minute setup

Cohorts and LTV, ready in 30 minutes.

Connect Stripe read-only and add the first-party snippet — Signal Sparrow builds your acquisition cohorts, retention curves and LTV:CAC automatically, with no data warehouse, no SQL and no sales call. Your first channel-level cohort view is ready in under half an hour.

Questions, answered.

Everything teams ask before switching their attribution to Stripe truth. Still curious? Talk to us.

Cohort analysis groups customers by a shared starting point — typically the month and channel that acquired them — and tracks how their revenue behaves over time. It reveals retention, expansion and churn patterns that a single blended metric hides.

LTV is the total gross-margin revenue a customer produces before they churn — commonly (monthly ARPA × gross margin) ÷ monthly churn rate. Signal Sparrow computes it from real Stripe subscription revenue per cohort, including expansion and contraction.

3:1 is a widely used SaaS benchmark — you earn three dollars of lifetime value for every dollar of acquisition cost. Below ~1:1 you're losing money; far above ~5:1 you may be underinvesting in growth. The insight is in seeing it by channel, not blended.

Product analytics infers retention from logins and events. Signal Sparrow measures revenue retention from Stripe — who is still paying, expanding or churning. Usage retention and revenue retention often disagree, and revenue is what funds the business.

NRR measures how much recurring revenue you keep and grow from existing customers: (starting MRR + expansion − contraction − churn) ÷ starting MRR. Yes — it's tracked per cohort and channel, so you can see which sources produce customers that expand.

Yes. Cohorts are built from full Stripe lifecycle data, so upgrades, downgrades, cancellations and reactivations all flow into retention and LTV — giving credit to the channels whose customers grow, not just sign up.

Ready to see which ads actually pay?

Start free, connect Stripe in 30 minutes, and get attribution that reconciles to the cent.

  • Free to start — no credit card
  • Live data in 30 minutes
Signal Sparrow dashboard preview