In this guest post by Cameron Archer, the author discusses how he replaced Google Analytics with a custom web analytics platform using JavaScript, Tinybird, and Retool, focusing on recreating the Google Analytics Content Drilldown view. Archer explains the process of capturing web events data and utilizing Tinybird's SQL Pipes to analyze and transform this data into meaningful insights, such as aggregated pageviews for subdirectories. The post elaborates on implementing a privacy-focused approach that avoids using session cookies and describes how query parameters and API endpoints were used to replicate the drilldown functionality in Retool. The final product allows users to explore visitor interactions with website subdirectories and visualize their performance over time, mirroring Google Analytics' functionality without compromising on data privacy.