How Audiohook uses Firebolt to prepare reports in no time
公司规模
Startup
地区
- America
国家
- United States
产品
- Firebolt
- AWS S3
- Firebolt Python SDK
技术栈
- ELT Datapipe
- Sparse Indexing
- Composite Primary Index
实施规模
- Enterprise-wide Deployment
影响指标
- Cost Savings
- Customer Satisfaction
- Productivity Improvements
技术
- 平台即服务 (PaaS) - 数据管理平台
- 分析与建模 - 预测分析
适用行业
- Software
- 电信
适用功能
- 商业运营
- 销售与市场营销
服务
- 云规划/设计/实施服务
- 软件设计与工程服务
- 系统集成
关于客户
Audiohook is a startup adtech company that focuses on enabling performance marketers to leverage digital audio as a new channel. They provide services that allow businesses to reach customers across digital and traditional audio channels, offering DSP services to enhance these experiences. The company is dedicated to providing insights into marketing campaigns, helping marketers understand the reach and effectiveness of their efforts. As a startup, Audiohook prioritizes dynamic data models and rapid analysis to stay competitive in the fast-paced adtech industry.
挑战
Audiohook, an adtech company, faced challenges with their existing cloud data warehouse, which was unable to meet their performance needs for dynamic data models and speed of analysis. The company needed a solution that could handle complex joins, windows, and aggregations across large event-based datasets to provide insights into marketing campaign effectiveness. Their existing solution was slow, taking up to an hour to compute impressions and conversions, which was not sustainable for their business needs.
解决方案
Audiohook adopted Firebolt, a data warehouse solution running on AWS S3, to address their performance challenges. Firebolt's indexing capabilities, particularly its primary sparse indexing, allowed Audiohook to significantly improve the efficiency of their ELT processes. By leveraging Firebolt's ability to prune unnecessary records and optimize data model design, Audiohook reduced query times from an hour to approximately two minutes. Additionally, Firebolt's model of allowing customers to adjust compute instance attributes enabled Audiohook to choose an engine with more RAM, further enhancing query performance by avoiding intermediate result spilling to disk.
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
Vodafone Hosted On AWS
Vodafone found that traffic for the applications peak during the four-month period when the international cricket season is at its height in Australia. During the 2011/2012 cricket season, 700,000 consumers downloaded the Cricket Live Australia application. Vodafone needed to be able to meet customer demand, but didn’t want to invest in additional resources that would be underutilized during cricket’s off-season.
Case Study
SKT, Construction of Smart Office Environment
SK T-Tower is the headquarters of SK Telecom. Inside the building, different types of mobile devices, such as laptops, smartphones and tablets, are in use, and with the increase in WLAN traffic and the use of quality multimedia data, the volume of wireless data sees an explosive growth. Users want limitless Internet access in various places in addition to designated areas.
