Appcues delivers personalized customer engagement with ClickHouse Cloud

Appcues transitioned to ClickHouse Cloud to enhance their real-time analytics capabilities, significantly improving query speeds and reducing costs while handling a massive data load of 1.31 PB and 410 billion events. Previously relying on a tech stack that included Airflow and Snowflake, Appcues faced challenges with latency and costs as they scaled, prompting the move to ClickHouse for its efficiency and ability to handle complex data segmentation quickly. The switch allowed them to cut query times by 90% and ingestion latency by 99%, while also reducing analytics spending by 23%. ClickHouse's features, such as SharedReplacingMergeTree and lightweight deletes, enabled Appcues to manage user profiles and GDPR compliance more effectively, while maintaining high performance and low latency. This migration not only improved Appcues’ existing analytics setup but also paved the way for new features, including AI-powered insights and enhanced funnel reports, ensuring their platform supports real-time product decisions and scales efficiently.