Case Study: Audiohook achieves 30x faster reporting ELT with Firebolt

How Audiohook uses Firebolt to prepare reports in no time

Audiohook, an adtech company focused on digital audio advertising, faced a significant challenge in analyzing large, complex event datasets to provide campaign insights to its customers. Their previous cloud data warehouse could not perform the necessary joins and aggregations efficiently, causing critical ELT reporting jobs to take about an hour to complete. This performance wall hindered their ability to deliver timely analytics.

By implementing the Firebolt cloud data warehouse, Audiohook leveraged its powerful sparse indexing and primary index capabilities to dramatically speed up data processing. This solution allowed Audiohook to prune unnecessary records and perform complex joins across billions of rows much faster. As a result, Firebolt reduced the runtime of their key ELT reporting query by 30x, bringing it down from an hour to just two minutes, which provided greater efficiency and cost savings.

Audiohook