How I replaced Google Analytics with Retool and Tinybird, Part 2

In a blog post, the author details the process of creating a custom web analytics platform to replace Google Analytics using Retool and Tinybird, focusing on replicating the Content Drilldown feature. The Content Drilldown is a Google Analytics view that aggregates metrics for subdirectories within a domain, allowing users to explore session metrics for entire sections of a website rather than individual pages. The author describes how they used Tinybird to capture and transform web events data into a format that mimics the Content Drilldown's functionality, with a focus on privacy by avoiding the use of session cookies. They detail the steps for creating SQL queries in Tinybird to extract and aggregate pageviews by subdirectory, publish these queries as API endpoints, and utilize Retool to build an interactive user interface that mimics Google Analytics' drilldown functionality. The project culminates in a Retool application that allows users to drill down into specific subdirectories and view aggregated pageviews over time, providing a Google Analytics-like experience without compromising data privacy.