Trackingplan is a comprehensive testing solution for web, iOS, Android, and backend analytics that powers ClickHouse, an analytical database capable of serving dynamic queries on the full data. The company initially used DynamoDB but recognized its limitations in handling complex queries and data inconsistencies. After evaluating alternatives, Trackingplan chose ClickHouse due to its unparalleled performance, flexible querying capabilities, and ability to answer unplanned queries. The adoption of ClickHouse simplified tracking plan's development process, allowing them to focus on optimizing queries using Materialized Views and leveraging the scaling API of ClickHouse Cloud to ensure compliance with local privacy regulations. With a growing 30 Billion rows in ClickHouse, Trackingplan continues to leverage the database's capabilities to improve their product offerings and expand into new use cases, including historical analysis.