5-9
man-hours
per week saved
on data collection
Case Study
How Ogilvy Spain Streamlines Social Media Data with Dataddo
1
source of truth
to inform all
business decisions
100%
scalability
of data integrations
for clients
Main Challenge
Ogilvy Spain was spending too much time manually collecting data from a large number of client accounts on multiple social media platforms and integrating it in reports for the clients. What they needed was a way to automatically centralize all this data in MySQL, where it could be easily accessed by Ogilvy's data team for reporting purposes.
Key Outcomes
- • 1 source of truth to inform all decisions, i.e. MySQL.
- • 5-9 hours of work saved weekly by automating data integrations, freeing up more time for deriving profitable insights.
- • Full scalability of integrations. Their data team can easily build new integrations and cancel existing ones as clients come and go.
Solution
- • Dataddo automatically extracts data from all client accounts on Facebook, Instagram, LinkedIn, and other social media platforms and syncs it daily to MySQL for processing and storage.
"
“We had a big need to centralize our data into one place and Dataddo gave us the opportunity to provide better reports in a fast and reliable way.”
Cayetano Sanchez
Data & Business Intelligence Analyst
Case Study
Read the Full Story
Ogilvy has been creating ad campaigns for giants like Burger King, Samsung, Adidas, Dove, and many others for decades. With offices worldwide and a history of over 75 years, Ogilvy is one of the largest and most prestigious advertising agencies in the world. Their Spain team, based in Madrid and Barcelona, manages social media campaigns for many well-known brands.
The Problem: Scattered Socials
Ogilvy Spain was manually collecting data every day from a variety of client accounts on Facebook , Instagram , LinkedIn , and other social media platforms . They were in need of a way to aggregate and automate this data extraction and deliver it to MySQL , giving them the ability to create reports and dashboards, and providing their clients with a comprehensive overview of their social media activities.
However, Ogilvy had a list of requirements for their data architecture, including but not limited to: flexibility and scalability, automation, interoperability with online data sources, and the ability to share raw data. Any new piece added to their infrastructure needed to meet these criteria in order to satisfy their data management requirements.
The Solution: Automatic Integration to MySQL
Through Dataddo, Ogilvy Spain was able to centralize their social media data analytics operations and channel all of their data into a single database: MySQL.
With automatic and seamless data synchronizations from multiple accounts across multiple platforms, Dataddo eliminated the tedious task of manually extracting data from each individual account. This saved 5-9 man-hours of work daily for the Ogilvy Spain team and optimized their data workflow so their analysts could spend more time working with the data itself.
"
“We had a big need to centralize our data into one place and Dataddo gave us the opportunity to provide better reports in a fast and reliable way.”
Cayetano Sanchez
Data & Business Intelligence Analyst
The Outcome: Easy, Flexible, Scalable Data Integrations
With everything accessible directly in their MySQL cloud, the entire Ogilvy team can quickly access the information and data they need, letting them efficiently provide reports and campaign results for their clients. As their social presence changes and develops, they can easily add new sources to their Dataddo account without affecting the existing data channels, ultimately giving Ogilvy the flexibility, scalability, automation, and reliability they were seeking.
See the Dataddo Platform in Action
Click below to start a free trial or book a demo with one of our experts.
Testimonials
Our Customers Love Us
Amalia Bornstein
Global Social Content and Marketing Data Analyst
Uber Eats
“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”
Andrew Hart
Chief Operations Officer
Sat 7
“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”
Vahan Petrosayan
Director of IT & Infrastructure
Search Engine Journal
“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”
Michael Guntenaar
CTO
ID&T Group
“Dataddo opens up gates and takes away the hurdles of working with data.”
Laurent Partouche
CPO
FoodChéri & Seazon
“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”
Natheer Maloon
Technology Solutions Manager
Boldr
“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”
Zdeněk Hejnak
Data Development Team Leader
Livesport
“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”
Greg Senior
Business Operations Manager
Farm Focus
“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”
