Rokt, a global marketing technology company, faced challenges with their reporting system due to its complexity and limited customer data slicing capabilities. They evaluated several databases, including Elasticsearch, Apache Pinot, Druid, Citus Data, StarRocks, Snowflake, and ClickHouse, before deciding on ClickHouse as the best option. ClickHouse provided better support for group-by capabilities, filtering, and joins, making it easier to query their large dataset of views, clicks, purchases, and events. The company found that ClickHouse was three times less expensive than Redshift without cache, outperformed Redshift in terms of performance, and could handle up to 200 queries per second. Rokt plans to migrate to ClickHouse Cloud for its advantages in backups and data analytics, including solving problems related to replication, sharding, and scalability.