sql SQL
bar_chart_4_bars BI
timeline Retention
Data Analysis with SQL
Advanced queries with JOINs, CTEs, and window functions to measure acquisition, retention, and profitability. Includes ARPU, LTV, and churn for marketing and product decisions.
Stack
SQL
CTE
Window functions
flag
Objective
Answer acquisition, retention, and profitability questions with optimized, reproducible SQL queries.
account_tree
Methodology
- Review the relational schema and foreign keys.
- Build queries with JOINs and CTEs to derive user, order, and traffic metrics.
- Use window functions for cohorts and monthly churn.
- Export to CSV for dashboards in Tableau or Looker Studio.
bar_chart
Key visualizations
- • Retention and monthly churn cohorts.
- • Conversion and ARPU by acquisition channel.
- • Revenue curve and LTV vs. CAC.
emoji_events
Results
- • Ready-to-replicate, documented queries.
- • Identification of the highest ROI acquisition channels.
- • Key metrics (ARPU, LTV, churn) available for executive dashboards.