Arkema x Converteo – Dashboard Automation: Maximizing Time for Strategic Analysis
Context
Faced with the time-consuming task of collecting necessary data for marketing analyses and visualizations, Arkema's marketing team sought to optimize this process. Converteo, at the crossroads of marketing and data, was chosen as the ideal partner to automate this data collection process. The primary data sources, Google Analytics and Marketo, required an innovative solution tailored to the AWS environment and to the requirements of Arkema's IT team.
Objectives
- Significantly reduce the monthly time spent on data collection
- Ensure greater reliability and stability of the collected data
- Free up time for higher value-added strategic analyses
Project phases
Needs analysis
- Collaboration with the IT team to understand the AWS environment
- Understanding the specific needs of the marketing team
Design de la solution
- Decision not to use AppFlow's built-in connectors due to the data size and custom segments required
- Serverless architecture validation based on Lambda functions for data extraction, S3 for storage, and Athena for business transformations
Implementation
- Development of automated data pipelines within AWS
- Replacement of the Excel sheet used for the PowerBI dashboard with the datamart created and automatically updated in Athena
Testing et validation
- Verification of data integrity and reliability
- Performance tests to ensure the system can handle the data volumes
Training and deployment
- Training the marketing team on the new system
- Deployment of the automated solution and smooth transition to the new environment
Résultats
50% reduction in data collection time.
Improved data reliability due to increased granularity and minimization of human errors.
Increased time for higher value-added analyses, providing strategic insights for Arkema's marketing team.