SQL analysis of marketing channels (LTV, CAC, Payback, retention)
-
Updated
Apr 8, 2026
SQL analysis of marketing channels (LTV, CAC, Payback, retention)
Python cohort retention & LTV:CAC analysis (synthetic e-commerce): heatmaps + channel unit economics (HTML/PDF report).
A system dynamics engine that models compounding cohort decay to help users predict future user retention, estimate required marketing or network subsidy costs, and model value extraction across different business models like SaaS, Web3 networks, and autonomous AI economies.
Auditoría estratégica de ROI y Unit Economics para la plataforma Showz. Identificación de ineficiencias críticas en la captación de usuarios y optimización de la rentabilidad operativa mediante el análisis profundo de LTV, CAC y ROMI.
Comprehensive unit economics analysis for a manufacturing company. Upgraded, corrected, and expanded edition of the original project.
Data-driven SaaS pricing optimization using ML to maximize LTV/CAC ratios. Employs Random Forest, clustering, and elasticity analysis on 4,222 customers to recommend tiered pricing strategies that balance revenue growth with sustainable churn rates.
Descriptive and formula-based predictive CLV analysis, revealing how survivorship bias inflates historical customer value estimates for high-churn segments. Built with Python, DuckDB, SQL, and pandas.
Add a description, image, and links to the ltv-cac-ratio topic page so that developers can more easily learn about it.
To associate your repository with the ltv-cac-ratio topic, visit your repo's landing page and select "manage topics."