How I Build a Professional LTV Curve in Google Sheets (No Shortcuts) скачать в хорошем качестве

How I Build a Professional LTV Curve in Google Sheets (No Shortcuts)

Most LTV tutorials cut corners. This one doesn't. 🚩 In this video I'll show you how to build a professional LTV curve in Google Sheets from scratch. Starting from a pre-aggregated SQL dataset, applying real cohort survival curves, and discounting future revenue with WACC. No raw logs. No 1/churn shortcuts. No ignoring the cost of capital. ----------------------------------------------------------------------------------------------------------------- 📌 What we cover: 📦 Why aggregation in SQL comes first — and why you should never model raw logs in a sheet 📉 Why 1 ÷ churn overestimates your LTV (and what to use instead) 💰 What WACC is, why it matters, and how to apply it with the =PV() formula in Sheets 🔄 How to build a cumulative LTV column that resets per cohort 📊 How to turn your data into a pivot table and plot the LTV curve ✂️ How to find your Fixed LTV cut-off — the number you can actually make decisions with ----------------------------------------------------------------------------------------------------------------- 🔗 Links & Resources: 📖 Full article on Substack (with formulas + data table): https://open.substack.com/pub/mackans... 🗄️ Part 1 — SQL Data Preparation for LTV:    • Building a SaaS LTV Model with SQL: From B...   📊 Google Sheet with the data used in this video: https://docs.google.com/spreadsheets/... ----------------------------------------------------------------------------------------------------------------- ⏱️ Timestamps: 00:00 — Intro 00:40 — Red flags when calculating LTV 00:55 — Use SQL to pre-aggregate 01:40 — Don't use churn rate to calculate customer lifetime 02:00 — WACC 03:30 — The dataset 05:10 — Calculate discount amount with PV formula 07:30 — Cumulative discounted amount 09:00 — Pivot table as basis for LTV curve 10:15 — Create LTV graph 13:00 — Calculate LTV value 14:00 — Final words ----------------------------------------------------------------------------------------------------------------- If this was useful, the best thing you can do is subscribe and share it with someone who's still using 1/churn 😄 #LTV #GoogleSheets #SaaSMetrics #CustomerLifetimeValue #WACC #CohortAnalysis #DataAnalytics #SubscriptionBusiness #GrowthMetrics #SQLtoSheets #businessintelligence