Fivetran Case Studies Red Ventures Enhances Client Support Through Data and AI

Edit This Case Study Record

	Red Ventures Enhances Client Support Through Data and AI Fivetran

Red Ventures Enhances Client Support Through Data and AI

Fivetran

Technology Category	Analytics & Modeling - Machine Learning Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Education Equipment & Machinery
Applicable Functions	Sales & Marketing
Use Cases	Predictive Maintenance Time Sensitive Networking
Services	Data Science Services System Integration
Challenge	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
About Customer	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
Solution	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 Log in to view content
Contents

Technology Category

Analytics & Modeling - Machine Learning

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Education

Equipment & Machinery

Applicable Functions

Sales & Marketing

Use Cases

Predictive Maintenance

Time Sensitive Networking

Services

Data Science Services

System Integration

Challenge

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.

About Customer

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.

Solution

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.

Impact #1	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.

Impact #1

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.

Benefit #1	Saves 100 hours per typical data integration
Benefit #2	Spends 80% less time on data processing jobs
Benefit #3	Reduced troubleshooting from 50% of its time to less than 20%

Benefit #1

Saves 100 hours per typical data integration

Benefit #2

Spends 80% less time on data processing jobs

Benefit #3

Reduced troubleshooting from 50% of its time to less than 20%

Download PDF Version

Overview

Red Ventures Enhances Client Support Through Data and AI

Operational Impact

Quantitative Benefit