Build Your Own Marketing Funnel Without GA4 — Sessions, Attribution, ROAS in SQL
Learn how to implement sessions, attribution, funnels, and ROAS with pure SQL — no expensive analytics tools needed.
Build Your Own Marketing Funnel Without GA4 — Sessions, Attribution, ROAS in SQL
Why Build It Yourself
Google Analytics 360, Amplitude, Mixpanel... Enterprise analytics tools come with hefty annual costs.
Hard to justify these costs at a startup. But with raw event logs, you can do the same analysis in SQL. 90% of core features these tools provide can be replicated with SQL.
1. Sessions — The Secret of 30-Minute Timeout
The rest of this series is paid
- ✓ The whole “SQL analytics” series: 9 posts in English, 9 in Korean
- ✓ 7 Jupyter notebooks
- ✓ One payment, no expiry. Opens when you sign in with the email you pay with.
The series pass needs no account to pay. The subscription needs a free account.