Red Ventures supports 30% more clients without new headcount

How the media giant reaches the right audience through data and AI powered by Databricks, Fivetran, and dbt™.

Key results:

  • Reaches the right customers with data and AI
  • Saves 100 hours per typical data integration
  • Spends 80% less time on data processing jobs

Background:

  • Company Size: 4,500+ employees
  • Industry: Media and entertainment
  • ELT: Fivetran, Fivetran Transformations for dbt Core™
  • Destination: AWS
  • Use case: advertising effectiveness, customer lifetime value, customer retention
  • Fivetran Connectors: S3, Appsflyer, Bing Ads, Google Ads, Iterable, Twitter Ads, Facebook Ads, Snapchat Ads, Facebook, Twitter, Salesforce, Net Suite Analytics, Google Search Console, Email, Aurora Postgres

Red Ventures (RV) is all about adaptability and change. The global company’s thousands of employees seek to positively impact the trajectory of people’s lives and the communities that they touch. RV’s Red Digital division aims to give marketing clients a greater return on investment than they’ve previously achieved. Hoping to manage marketing data more efficiently, RV implemented Databricks along with Fivetran and dbt™. Soon, RV was completing data processing tasks in a fraction of the time and freeing up its data engineers to focus on analysis. Now, with more intuitive data solutions, RV can focus more on data transformations and helping the company deliver better results for its clients.

“With Databricks, Fivetran and dbt™, we can use data and AI in ways that help us reach the right customers with our clients’ marketing campaigns. That means we can deliver better results for their investment.” — Brandon Beidel, Director of Product Management, Red Ventures

Data ingestion across clouds causes a bottleneck

When companies want to optimize their marketing strategy, they turn to RV. The company’s Red Digital division provides end-to-end performance marketing services that help business-to-consumer (B2C) services providers attract new customers. RV uses a modern, and 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.

“For some of our clients, we manage the entire customer journey,” said Brandon Beidel, Director of Product Management at Red Ventures. “Many clients don’t have the in-house marketing expertise to run sophisticated campaigns. It’s our job to help them drive customer growth over time, and we use data and AI to give them the best results possible.”

For RV, delivering greater value to clients — and consumers — is about using timely insights from data to get in front of the right consumers. But the company doesn’t just think of the bottom line. Red Ventures wants customers and prospects to have an outstanding user experience as they explore products and decide whether to buy.

“Today’s consumer expects to be able to complete the entire purchase process for most products online,” said Beidel. “But when they’re buying complex services, it’s challenging for businesses to get their message across effectively. Our goal is to create for our clients an optimal ad experience or many iterations of a website and then connect each of their customers with the user experience that will best help them understand the product. For us to tailor marketing to that level, we need to effectively use data and AI.”

To ensure data integrity, RV maintains each client’s data in a separate cloud environment. From there, RV must integrate each client’s data and perform intensive transformations to generate machine learning predictions. Until recently, data engineers wrote custom scripts to ingest data for each client — a tedious and time-consuming task.

A modern data stack helps simplify and automate ETL workloads

Seeking to process data more efficiently, RV implemented Databricks to scale data engineering pipelines and speed up insights. The company also uses Fivetran to perform data ingestion and dbt™ to apply data transformations. Databricks is now the engine that performs RV’s heaviest computing tasks. For each client environment, RV has set up a dedicated Databricks workspace, Fivetran connectors and dbt™ projects that only designated employees can access. All three solutions feed data into a machine learning pipeline that drives functions such as budgeting for clients’ advertising spend.

“Due to the nature of our business, we must maintain a separate data stack for each client,” Beidel explained. “But Databricks, Fivetran and dbt™ help us avoid reinventing the wheel as we build out the processing, computation and data management pieces for each client. We’ve been able to take work our engineers have done and reuse it across multiple clients. We’ve also put Fivetran in the hands of our marketers to let them set up integrations for ingesting our clients’ data, and we’ve given them access to dbt™ to define data transformations. Because these tools are so simple, we often don’t need to involve our engineers.”

Most of the onsite events from clients’ websites stream into RV. The company receives click data, event views, page views, scrolling depth and more into its warehouse. From there, RV has simplified and automated its ETL workloads.

“Databricks has allowed us not to have to think about managing infrastructure,” said Beidel. “For many workloads, we simply select the compute size, define our script and let it run. Our data engineers don’t have to be experts in managing Spark clusters. With Databricks, they can focus on the shape of the data and the business logic.”

Delivering better results for clients with less data work

RV now processes client data more efficiently than ever. The company used to spend 100 to 150 hours per data integration. Today, that figure is 10 hours — which frees up data engineers to work on higher-value tasks. Processing jobs that ran overnight and took up to 20 hours now finish in four or five. And because Fivetran provides the same data set for every client and dbt™ gives everyone a clear view of data transformations, RV’s engineering team has reduced troubleshooting from 50% of its time to less than 20%. Automated cluster management capabilities in the Databricks Lakehouse Platform have yielded further time savings.

“Not having to manage clusters is a huge time-saver for us,” Beidel remarked. “Our biggest grievance with other warehousing technologies is the lack of effective autoscaling. It’s a must-have capability when you’re working with a large volume of analytical workloads and have fluctuations in demand throughout the day. Having that variability in usage taken care of for us by Databricks probably saves one engineer out of 10.”

This greater efficiency has enabled RV to support 30% more clients. “One of the things that drew me to dbt™ is that everything is in SQL,” Beidel explained. “It serves as a common language for our team. Not everyone can write SQL, but everyone can read it and have a better understanding of what’s going on underneath.”

Because dbt™ and Fivetran are so easy to use, more RV employees are involved in data transformations. Engineers will often use dbt™ to show marketing staff how specific values were calculated — leading to deeper discussions about the data and to knowledge transfer from engineering to business users.

This data democratization is contributing to better results for RV’s clients. “Using the highly intuitive machine learning pipeline we’ve built, we’ve helped our clients increase cost efficiency in some channels by 20 to 30%,” Beidel concluded.

Commencer gratuitement

Rejoignez les milliers d’entreprises qui utilisent Fivetran pour centraliser et transformer leur data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Taille de l'entreprise
Région
Industrie
Professional services
Sources
No items found.
Destinations
No items found.
Sources
No items found.
Destinations
No items found.
BI tool
No items found.
Essayez Fivetran gratuitement
Chiffres clés
The total economic impact of Fivetran

Learn how automated data movement boosts productivity and accelerates insights for your business.

Download the report
Are you a true data pioneer?

Our quiz will tell you where you are on your data journey and what tools you can unlock to level up.

Take the quiz
Why they chose Fivetran

Further reading
No items found.
No items found.
Related customer stories
Case study

Trinny London achieves up to £260K in savings with Fivetran

Case study

Mistertemp’ : l’intérim digital grandit et gagne en compétitivité avec Fivetran

Case study

Stuart, leader de la livraison à la demande, améliore son expérience client grâce à Fivetran

Case study

La Migration de SumUp vers le Modern Data Stack avec Fivetran

Case study

Libeo choisit Fivetran pour faciliter le paiement en entreprise grâce à la Data

Case study

Interflora accélère sa stratégie d’expansion data en Europe grâce à Fivetran

Case study

National Australia Bank enhances customer experiences and powers GenAI

Case study

Envision Pharma Group and Fivetran: Pioneering faster paths in pharma

Case study

Raiffeisen Bank International uses real-time data to win more customers

Case study

Saks achieves data efficiency & enables AI with Fivetran

Let's get you moving data