Real-world SQL recipes
The questions that land in your inbox on a Monday: active users, MRR, churn, CAC, how long tickets take. Each one is a query you can run, read line by line, and steal.
- ProductWAU / MAUWeekly and monthly active users (WAU, MAU)
- FinanceMRRMonthly recurring revenue (MRR) by month
- FinanceChurn %Monthly churn rate
- Any metric7-day averageRolling 7-day average
- ProductFunnelConversion funnel
- ProductRetentionRetention by signup cohort
- MarketingCACCustomer acquisition cost (CAC) by channel
- SalesTop 3 per groupTop 3 in every group
- OperationsHours to closeTicket resolution time and throughput