Fivetran > Case Studies > Optimizing Ad Efficiency with Fivetran Transformations for dbt Core: A Mighty Digital Case Study

Optimizing Ad Efficiency with Fivetran Transformations for dbt Core: A Mighty Digital Case Study

Fivetran Logo
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
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 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.
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
  • The implementation of Fivetran Transformations for dbt Core resulted in several operational benefits for the transportation startup. There was greater visibility into the performance of their marketing campaigns with target audiences, which allowed for more informed decision-making. The solution also reduced data latency, enabling the startup to quickly react to behavioral changes in their customer base. Additionally, the startup was able to cut engineering costs associated with building and maintaining data pipelines, freeing up resources to focus on other projects. The project was successfully implemented, leading to increased customer satisfaction.
Quantitative Benefit
  • 150% increase in return on ad spend
  • 2x times better user activation rates
  • 350% increase in customer engagement

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.