FabFunnel & ClickHouse: Delivering Real-Time Marketing Analytics

Anmol Jain, SDE-2 (Full stack Developer) at Idea Clan

Siddhant Gaba, SDE-2 (Python) at Idea Clan Idea Clan is a performance marketing company that relies on real-time reporting to drive data-driven decisions and maximize campaign effectiveness. As their client base expanded, the team encountered significant challenges with their reporting system—frequent data updates meant handling large datasets inefficiently, leading to slow query execution and delays in delivering insights. This bottleneck hindered their ability to provide timely optimizations for ad campaigns.

To address these issues, they needed a solution that could handle rapid data ingestion and querying at scale without the overhead of traditional refresh processes. In this talk, Anmol and Siddhant share how their team transformed their reporting infrastructure with ClickHouse to achieve real-time insights, enhancing speed, scalability, and efficiency in managing large-scale ad performance data.

You can find the deck of this talk from https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-Delhi-1/Talk%205%20-%20Idea%20Clan%20-%20Delhi%20Meetup_22Mar25.pdf