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

Edit This Case Study Record

	GroupM Enhances Client Insights and Saves Time with Fivetran Fivetran

GroupM Enhances Client Insights and Saves Time with Fivetran

Fivetran

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

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

Impact #1

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.

Benefit #1	Fivetran saves GroupM over 75 hours a month
Benefit #2	Time saved equates to three to five hours per month, per client
Benefit #3	Fivetran backfills GroupM customers’ historical data, saving the team further time and avoiding time-consuming manual syncs

Benefit #1

Fivetran saves GroupM over 75 hours a month

Benefit #2

Time saved equates to three to five hours per month, per client

Benefit #3

Fivetran backfills GroupM customers’ historical data, saving the team further time and avoiding time-consuming manual syncs

Download PDF Version

Overview

GroupM Enhances Client Insights and Saves Time with Fivetran

Operational Impact

Quantitative Benefit