Download PDF
Optimizing Ad Efficiency with Fivetran Transformations for dbt Core: A Mighty Digital Case Study
Technology Category
- Functional Applications - Transportation Management Systems (TMS)
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Buildings
- Transportation
Applicable Functions
- Maintenance
- Sales & Marketing
Use Cases
- Autonomous Transport Systems
- Public Transportation Management
The Challenge
Mighty Digital, a growth, analytics, and strategy consulting firm based in Ukraine, was faced with the challenge of helping a transportation startup optimize its ad budget efficiency, user activation rates, and campaign engagement. The startup had no clear understanding of the cost-effectiveness of various ad campaigns due to an inefficient ETL pipeline built using Airflow and Python transformations. The data architecture was prone to errors, missing data points, and overall inefficiency, leading to inaccurate advertising results. The existing solution was convoluted, involving multiple softwares stitched together to create a complex architecture that provided no insights. This led to a lack of data insight, reliability, and availability, inefficient marketing campaigns and ad spend, inability to turn data into customer retention optimizations, and decreased trust in data due to errors.
About The Customer
The customer in this case study is a transportation startup that was struggling with optimizing its ad budget efficiency, user activation rates, and campaign engagement. Prior to working with Mighty Digital, the startup had no clear understanding of the cost-effectiveness of various ad campaigns due to an inefficient and error-prone data architecture. The startup's existing solution was complex and provided no insights, leading to a lack of data insight, reliability, and availability, inefficient marketing campaigns and ad spend, and decreased trust in data due to errors.
The Solution
Mighty Digital implemented Fivetran Transformations for dbt Core to help the transportation startup unlock its advertising data and find more efficiency in their budget. They shifted from ETL to cloud-based ELT with Fivetran, dbt Core, BigQuery, and Looker. Fivetran data models reduced engineering time and provided best-in-class modeling, out-of-the-box. Fivetran provided stable data pipelines that could be easily transformed and scaled with Fivetran Transformations for dbt Core. This solution enabled the startup to accelerate its growth in a competitive market, while satisfying its customers with delightful advertising campaigns. The client now has trustworthy, fast advertising insights centralized in one source of truth.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
