CHALLENGES

• Adapt the platform that the customer already used to the cloud;
• Cope with the ever-increasing data flow;
  
• Reduction of manual work;
• Reduce manual handling of Google sheets.

SOLUTION

The project scope included the implementation of a Data Analytics and Marketing Analytics / Cloud for Marketing architecture, using Google Cloud solutions (Cloud Scheduler, Cloud Pub/Sub, Cloud Functions, Cloud Storage, BigQuery, DataStudio). Processes were developed to extract data from Marketing tools for Ad Managers (Facebook Ads, Google Ads, Google analytics), CRM (Pipedrive) and email marketing tools (MailChimp, Zapito), created the data integration layer in a single storage architecture via Cloud Storage and BigQuery, automating the loading processes and making data and indicators available through Dashboards in Google DataStudio.

BENEFITS

• Cost reduction;
• Less manual labor in the operation;
• High level of automation in the production of dashboards;
• Data centralization in a single repository.