Why NDR?
Net Dollar Retention shows how revenue from existing customers evolves: who churns, who downgrades, and who expands. For SaaS, it’s the north star of growth quality.
What’s tricky?
• GA4 doesn’t provide (LOL) NDR out of the box
• Expansion, downgrades, churn - all hidden in raw transactions
• Simple revenue sums miss the nuance
How to calculate with SQL?
• Group revenue by cohort and period
• Compare recurring revenue between periods
• Factor in upsells, downgrades, and churn via window functions
What’s the output?
A single % that reveals whether your existing base is growing revenue on its own. High NDR = product-market fit. Low NDR = churn is eating you alive.
Wanna adjust it by MRR or ARR? Drop me a message )
Want to get all my top Linkedin content? I regularly upload it to one Notion doc.
Go here to download it for FREE.
