Fivetran Case Studies Red Ventures Enhances Client Support Through Data and AI
Edit This Case Study Record
Fivetran Logo

Red Ventures Enhances Client Support Through Data and AI

Fivetran
Analytics & Modeling - Machine Learning
Application Infrastructure & Middleware - Data Exchange & Integration
Education
Equipment & Machinery
Sales & Marketing
Predictive Maintenance
Time Sensitive Networking
Data Science Services
System Integration
Red Ventures (RV), a global company with a focus on positively impacting people’s lives and communities, was facing a challenge in managing marketing data efficiently. The company's Red Digital division provides end-to-end performance marketing services to help business-to-consumer (B2C) services providers attract new customers. To deliver greater value to clients, RV needed to use timely insights from data to reach the right consumers. However, maintaining each client’s data in a separate cloud environment and integrating each client’s data for machine learning predictions was proving to be a tedious and time-consuming task. Data engineers had to write custom scripts to ingest data for each client, which was not an efficient use of their time and skills.
Read More
Red Ventures is a global company that seeks to positively impact the trajectory of people’s lives and the communities they touch. The company's Red Digital division aims to give marketing clients a greater return on investment than they’ve previously achieved. RV provides end-to-end performance marketing services that help business-to-consumer (B2C) services providers attract new customers. The company uses a modern, scalable data solution to optimize search campaigns, social campaigns, display, and landing pages in ways that will turn top-of-funnel marketing leads into repeat customers for their clients.
Read More
To address this challenge, RV implemented Databricks to scale data engineering pipelines and speed up insights. The company also used Fivetran for data ingestion and dbt™ for data transformations. Databricks became the engine that performed RV’s heaviest computing tasks. For each client environment, RV set up a dedicated Databricks workspace, Fivetran connectors, and dbt™ projects that only designated employees could access. All three solutions fed data into a machine learning pipeline that drove functions such as budgeting for clients’ advertising spend. RV also received click data, event views, page views, scrolling depth, and more into its warehouse, simplifying and automating its ETL workloads.
Read More
The implementation of Databricks, Fivetran, and dbt™ has led to significant operational improvements for Red Ventures. The company now processes client data more efficiently, freeing up data engineers to work on higher-value tasks. The time spent on data integration has been drastically reduced, and processing jobs that used to take up to 20 hours now finish in four or five. The use of Fivetran and dbt™ has also reduced troubleshooting time significantly. The ease of use of these tools has led to more employees being involved in data transformations, leading to knowledge transfer from engineering to business users. This data democratization has contributed to better results for RV’s clients.
Saves 100 hours per typical data integration
Spends 80% less time on data processing jobs
Reduced troubleshooting from 50% of its time to less than 20%
Download PDF Version
test test