---
title: How Ogilvy Spain Streamlines Social Media Data with Dataddo
description: Read how Ogilvy Spain uses Dataddo to extract data from multiple accounts on various social media platforms to provide quick, reliable reports for clients.
image: https://blog.dataddo.com/hubfs/cs-ogilvy-2.png
---

[![Dataddo Blog](https://blog.dataddo.com/hs-fs/hubfs/blog-logo.png?width=180&name=blog-logo.png)](https://blog.dataddo.com)

**

[Get Dataddo Free](https://www.dataddo.com/signup?hsLang=en)

[![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9)

# How Ogilvy Spain Streamlines Social Media Data with Dataddo

By Jessica Piel | 4 min read

![](https://blog.dataddo.com/hubfs/cs-ogilvy-2.png)

- **
- **
- **

## **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**

**![Ogivly tech](https://blog.dataddo.com/hs-fs/hubfs/Ogivly%20tech.png?width=2280&height=465&name=Ogivly%20tech.png)**

- **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**

**![Ogilvy & Dataddo](https://blog.dataddo.com/hs-fs/hubfs/Ogilvy%20%26%20Dataddo.png?width=2280&height=461&name=Ogilvy%20%26%20Dataddo.png)**

- **Dataddo automatically extracts data from all client accounts **on Facebook, Instagram, 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, Ogilvy Spain*

 

## ![Ogilvy about table](https://blog.dataddo.com/hs-fs/hubfs/Ogilvy%20about%20table.png?width=250&height=342&name=Ogilvy%20about%20table.png)Full Case Study

[Ogilvy ](http://www.ogilvy.es/)has been creating ad campaigns for giants like Burger King, Samsung, Adidas, Dove, and many others for decades. In keeping with its reputation to stay on the leading edge of culture, Ogilvy has evolved with the times to include social media and digital marketing strategies both for their clients and for themselves. But, as any marketer is well aware, each new social media platform brings with it an abundance of data. 

 

## **The Problem: Scattered Socials**

Ogilvy Spain was manually collecting data every day from a variety of client accounts on [Facebook](https://www.dataddo.com/connector/facebook-ads/?hsLang=en), [Instagram, ](https://www.dataddo.com/connector/instagram-ads?hsLang=en)and [other social media platforms](https://dataddo.com/connectors). They were in need of a way to aggregate and automate this data extraction and deliver it to [MySQL](https://www.dataddo.com/storage/mysql?hsLang=en), 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 data warehouse in MySQL.

![ogilvy flow_updated-1](https://blog.dataddo.com/hs-fs/hubfs/ogilvy%20flow_updated-1.jpg?width=755&height=420&name=ogilvy%20flow_updated-1.jpg)

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, Ogilvy Spain*

## **The Outcome: Easy, Flexible, Scalable Data**

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 how Dataddo can help your business** Just a few quick steps to get your data to your dashboard for better analysis, without the hassle. [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a) |
| --- |

 Category: [Case Studies](https://blog.dataddo.com/tag/case-studies), [facebook](https://blog.dataddo.com/tag/facebook), [instagram](https://blog.dataddo.com/tag/instagram), [mysql](https://blog.dataddo.com/tag/mysql), [facebook_post](https://blog.dataddo.com/tag/facebook_post), [facebook_page](https://blog.dataddo.com/tag/facebook_page), [facebook_ads](https://blog.dataddo.com/tag/facebook_ads), [instagram_ads](https://blog.dataddo.com/tag/instagram_ads), [instagram_user](https://blog.dataddo.com/tag/instagram_user), [instagram_media](https://blog.dataddo.com/tag/instagram_media), [instagram_story](https://blog.dataddo.com/tag/instagram_story), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

### Related Articles**

<https://blog.dataddo.com/how-publicis-groupe-brasil-uses-dataddos-api-to-scale-a-data-product?hsLang=en>

## [How Publicis Groupe Brasil Uses Dataddo’s API to Scale a Data Product](https://blog.dataddo.com/how-publicis-groupe-brasil-uses-dataddos-api-to-scale-a-data-product?hsLang=en)

*(4 min read )*

 Topics: [Case Studies](https://blog.dataddo.com/tag/case-studies), [facebook](https://blog.dataddo.com/tag/facebook), [instagram](https://blog.dataddo.com/tag/instagram), [mysql](https://blog.dataddo.com/tag/mysql), [facebook_post](https://blog.dataddo.com/tag/facebook_post), [facebook_page](https://blog.dataddo.com/tag/facebook_page), [facebook_ads](https://blog.dataddo.com/tag/facebook_ads), [instagram_ads](https://blog.dataddo.com/tag/instagram_ads), [instagram_user](https://blog.dataddo.com/tag/instagram_user), [instagram_media](https://blog.dataddo.com/tag/instagram_media), [instagram_story](https://blog.dataddo.com/tag/instagram_story), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

<https://blog.dataddo.com/how-ringside.ai-builds-a-data-product-better-and-faster-using-dataddo?hsLang=en>

## [How Ringside.ai Builds a Data Product Better and Faster Using Dataddo](https://blog.dataddo.com/how-ringside.ai-builds-a-data-product-better-and-faster-using-dataddo?hsLang=en)

*(4 min read )*

 Topics: [Case Studies](https://blog.dataddo.com/tag/case-studies), [facebook](https://blog.dataddo.com/tag/facebook), [instagram](https://blog.dataddo.com/tag/instagram), [mysql](https://blog.dataddo.com/tag/mysql), [facebook_post](https://blog.dataddo.com/tag/facebook_post), [facebook_page](https://blog.dataddo.com/tag/facebook_page), [facebook_ads](https://blog.dataddo.com/tag/facebook_ads), [instagram_ads](https://blog.dataddo.com/tag/instagram_ads), [instagram_user](https://blog.dataddo.com/tag/instagram_user), [instagram_media](https://blog.dataddo.com/tag/instagram_media), [instagram_story](https://blog.dataddo.com/tag/instagram_story), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

<https://blog.dataddo.com/data-integration-software-in-practice-dataddo-use-cases-and-outcomes?hsLang=en>

## [Data Integration Software in Practice: Dataddo Use Cases and Outcomes](https://blog.dataddo.com/data-integration-software-in-practice-dataddo-use-cases-and-outcomes?hsLang=en)

*(4 min read )*

 Topics: [Case Studies](https://blog.dataddo.com/tag/case-studies), [facebook](https://blog.dataddo.com/tag/facebook), [instagram](https://blog.dataddo.com/tag/instagram), [mysql](https://blog.dataddo.com/tag/mysql), [facebook_post](https://blog.dataddo.com/tag/facebook_post), [facebook_page](https://blog.dataddo.com/tag/facebook_page), [facebook_ads](https://blog.dataddo.com/tag/facebook_ads), [instagram_ads](https://blog.dataddo.com/tag/instagram_ads), [instagram_user](https://blog.dataddo.com/tag/instagram_user), [instagram_media](https://blog.dataddo.com/tag/instagram_media), [instagram_story](https://blog.dataddo.com/tag/instagram_story), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

### Subscribe to The Chronicles of Marketing Newsletter

## Comments

## Subscribe to Our Blog

Stay up to date with the latest marketing, sales, and service tips and news.

![subscribe](https://blog.dataddo.com/hubfs/Illustrations/subscribe.svg)

- [****](https://www.linkedin.com/company/dataddo)

- ©  Dataddo, Inc. All Rights Reserved

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Jessica Piel",
    "url" : "https://blog.dataddo.com/author/jessica-piel"
  },
  "dateModified" : "2023-07-11T15:38:12.098Z",
  "datePublished" : "2021-07-31T07:21:00.000Z",
  "headline" : "How Ogilvy Spain Streamlines Social Media Data with Dataddo",
  "image" : [ "https://blog.dataddo.com/hubfs/cs-ogilvy-2.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.dataddo.com/how-ogilvy-spain-streamlines-social-media-data-with-dataddo",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.dataddo.com/hubfs/Dark%20logo@3x-1.png"
    },
    "name" : "Dataddo, Inc."
  }
}
```