Fivetran > Case Studies > GroupM Enhances Client Insights and Saves Time with Fivetran

GroupM Enhances Client Insights and Saves Time with Fivetran

Fivetran Logo
Technology Category
  • Analytics & Modeling - Machine Learning
  • Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries
  • Oil & Gas
  • Retail
Applicable Functions
  • Maintenance
  • Sales & Marketing
Use Cases
  • Time Sensitive Networking
Services
  • Cloud Planning, Design & Implementation Services
  • Data Science Services
About The Customer
GroupM is a global media agency group based in Oslo and the Nordic region's largest media agency group. It serves over 200 clients with technology-enabled services that connect with premium partners, including Google, Facebook, and Amazon. GroupM provides a shared services-type function for other agencies in the group – MediaCom, Mindshare, Wavemaker, MediaPlus – and is responsible for collecting data and measuring the effectiveness of their award-winning advertising campaigns. They were looking for a more efficient and robust solution to collect and analyze data for their clients.
The Challenge
GroupM, a global media agency based in Oslo, was facing challenges in collecting and analyzing data for their clients. The agency, which serves over 200 clients and provides shared services for other agencies in the group, was using Supermetrics to pull marketing data directly into Google Sheets. However, this method was proving to be inefficient and problematic. Pipelines would occasionally fail due to hard-to-detect issues, and there were formatting problems with the spreadsheets as well as manual errors. Preparing data for analysis in Google BigQuery, GroupM’s data warehouse, was labor-intensive, and clients were demanding faster access to more insights. One client, with a broad business portfolio spanning retail and hotels, was looking for dashboards that could handle historical data analysis as well as day-to-day reports. GroupM was determined to find a more robust solution.
The Solution
GroupM identified Fivetran as the pipeline solution to streamline their data processes. Fivetran provided connectors to pull data from a wide variety of data sources, including Facebook and Google Ads, directly into Google BigQuery. The GroupM team was impressed by Fivetran’s self-healing and zero maintenance architecture, along with fast access to pre-configured connectors that could speed up ingestion from up to 15 main sources. The goal was to gather all the data in BigQuery to build automatic reporting. Every client has different marketing KPIs, but metrics for impressions, clicks, and conversions were always in demand. The next phase of development plans to use Connect Card, an embeddable Fivetran setup feature, which authenticates user credentials via a secure HTTPS connection and avoids any work on the company servers. This would allow GroupM customers to input their login credentials for the data source directly and initiate the sync, avoiding the need to share proprietary data with GroupM.
Operational Impact
  • The implementation of Fivetran has allowed GroupM to standardize processes, accelerate time to insights, and free up the data team from having to manage and maintain pipelines. Reports are now presented to the client via dashboards that are updated daily. The time saved has been significant, with Fivetran saving as much as 75 hours a month, or nearly two weeks of work. The plan going forward is to move beyond marketing and use the data for sales modelling, leveraging AI and machine learning for statistical analysis of the factors that influence a purchase. The use of Fivetran has resulted in increasingly sophisticated analytics.
Quantitative Benefit
  • Fivetran saves GroupM over 75 hours a month
  • Time saved equates to three to five hours per month, per client
  • Fivetran backfills GroupM customers’ historical data, saving the team further time and avoiding time-consuming manual syncs

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.