Case Study: Superwall scales subscription monetization and real-time analytics with ClickHouse Cloud

How Superwall uses WarpStream and ClickHouse Cloud to scale subscription monetization

Superwall, a 14-person company that powers paywall monetization for hundreds of mobile subscription apps, needed a way to capture and analyze massive event volumes in near real time. As its platform grew to ingest 100 MB of events per second and store hundreds of terabytes of data, the team needed a fast, durable, low-maintenance analytics stack. ClickHouse was chosen for real-time analytics, initially helping Superwall replace hourly or daily rollups with instant, SQL-based pre-aggregation.

To scale, Superwall moved to ClickHouse Cloud alongside WarpStream, and used ClickPipes to stream data reliably from WarpStream into ClickHouse Cloud without operational overhead. ClickHouse’s managed, elastic architecture eliminated constant disk resizing and simplified ingestion, while invalid records were isolated in an errors table for safer operations. With ClickHouse, Superwall now moves more than 100 MB/sec, manages over 300 TB of data growing by 40 TB per month, and keeps customer dashboards loading in seconds.

Superwall

Brian Anglin

Chief Technology Officer