How HighLevel rebuilt its data platform for speed, scale, and simplicity on ClickHouse Cloud

HighLevel, a marketing and sales platform serving over 90,000 agencies and 3 million small businesses, transitioned its data operations to ClickHouse Cloud to address performance issues as their usage grew exponentially. Previously relying on a mix of MySQL, Elasticsearch, Firestore, and a document database, HighLevel faced challenges with slow query response times, inefficient storage, and high maintenance demands. By migrating to ClickHouse Cloud, they achieved significant storage reductions and improved query performance dramatically, reducing latency from several seconds to under 200 milliseconds. This shift enabled them to efficiently handle billions of daily events and reduce operational overhead. The migration also involved optimizing their data architecture for use cases such as lead activity, workflow logs, notifications, and real-time revenue dashboards. Implementing client-side observability and adopting best practices like avoiding update-heavy patterns and optimizing schemas further enhanced their system's efficiency and reliability. This transformation allowed HighLevel to unify its data operations into a cohesive, high-performance platform, supporting its rapid growth without the previous bottlenecks.