The client is a Fortune 500 food manufacturing firm that was looking to automate data collection, storage and improve data quality for faster and accurate analysis. Their data previously had to be sourced and manually ingested from over 30 different entities and they didn’t have a consistent template to collect data. Their marketing team also wanted user-friendly data visualizations to get a holistic view of advertising spend, help generate faster insights and optimize marketing RoI.
Sigmoid built tactic-based data models to standardize the input files from different data providers, agencies and channels. The datasets, which came at different intervals of time were then transformed to work with the respective models. The ETL pipelines were set up, pre-processed and transformed using AWS Lambda and Glue, to be then served through Amazon Redshift. Sigmoid built automated pipelines to pull the data via SFTP and UI portals. Tableau dashboards helped provide stakeholders a 360-degree view of the advertising spend by monitoring over 10 tactics.