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
These data analytics guides follow the path from a single tracked event to a decision. Most posts include code you can run on a small stack.
For instance, event driven analytics architecture explains the overall flow. Next, PostgreSQL schema design for analytics shows how to store it well. Later posts add AI on top, such as text to SQL with a local LLM. In short, it is analytics for people who build the pipes.
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,…