SQL Queries for User Analytics (MySQL Examples)
Copy-paste SQL queries for user analytics in MySQL 8.4: DAU/MAU, sessions, funnels, retention cohorts and window functions, each…
Category
Analytics
Data analytics notes for product and engineering. Instrumentation, funnels, metrics that matter, and turning numbers into decisions. New posts land soon.
18 articles
-
-
How to Centralize Server Logs for a Web App
Learn how to centralize server logs for a web app and turn nginx and app logs into analytics…
-
How to Track Button Clicks and Form Submissions with JavaScript
Learn how to track button clicks and form submissions with vanilla JavaScript: event delegation, sendBeacon, keepalive and SPA…
-
How Web Analytics Works: Tracking Pixels, HTTP Requests and Cookies
Learn how web analytics turns a page view into a database row: tracking pixels, HTTP requests, first-party cookies,…