Marketing Data Warehouse for an American Utility Manufacturing Company
ManufacturingBusiness Impacts
Enabled data-driven decision making
Automated data transfer process
Enhanced quality of data
Built a foundation to achieve data-driven Marketing Analytics
Customer Key Facts
- Country : United States
- Size : 5500+ Employees
- Industry : Manufacturing
- About : The client is an international manufacturer and marketer of complete solutions that identify and protect people, products and places
Creating a Centralized and Automated Digital Marketing Data Warehouse on Google Cloud
The client is an international manufacturer and marketer of complete solutions that include high-performance safety devices, printing systems, labels, signs, and software solutions that identify and protect people, products, and places. The challenge was to create a centralized and fully automated real-time Digital Marketing Data Warehouse on Google Cloud for timely integration of data from various platforms and data siloes.
Challenges
- Ingestion of data from multiple data sources
- Transferring data from various sources to Google BigQuery
- Maintaining data consistency and common frequency mapping
- Automating data transformation and ingestion
Technologies Used
Google Cloud Storage
Google Monitoring and Alerting
Google BigQuery DTS
Google Logging
Google Cloud Composer
Adobe Analytics
Bing Ads
Salesforce
Azure SQL
Google Ads
Solution
Quantiphi assisted in building a Marketing Data Hub that involved the creation of data pipelines to enable automation and schedule data ingestion and transformation from various data sources to GCP.
The data integration was carried out with a Business Intelligence tool called DOMO, which facilitated quick dashboarding, reporting, and visualization in order to support descriptive and diagnostic analytics.
Result
- Achieved data-driven marketing analytics for an intelligible understanding of business operations and marketing efforts
- Provided a consolidated view of all data sources in BigQuery to be used as a single source of truth for analytics and reporting
- Developed a custom solution with end-to-end process automation
- Built a solid foundation to achieve data-driven marketing analytics
- Improved data quality and automated data ingestion onto BigQuery
