Member-only story
Introduction
ClickHouse’s name derives from a combination of “Clickstream” and “Data Warehouse”. This captures the use case for which it was originally designed: keeping records of all clicks by people from all over the Internet. Although the range of use cases to which ClickHouse is applied has diversified, it still remains hugely popular for analytics relying on the capture of web events. Product Analytics represents a natural extension of this use case, focusing on tracking and analyzing how users interact with products to drive insights into user behavior, engagement, and satisfaction.
In this blog, we’ll guide you through building a powerful product analytics solution with ClickHouse, sharing insights on essential data schemas, typical workflows that product managers and growth marketers depend on, and the key queries for extracting valuable metrics. This guide draws from our experience developing and running our own in-house product analytics platform, Galaxy, which has provided actionable insights and proven reliability over nearly two years of operation.
With over 20 billion events and 14 TB of data, Galaxy has empowered us to quantitatively assess the impact of every design and product decision we make. The platform enables A/B testing and the measurement of common user workflows, allowing us to refine and enhance the ClickHouse Cloud experience continually.
