下载PDF
Optimizing Ad Efficiency with Fivetran Transformations for dbt Core: A Mighty Digital Case Study
技术
- 功能应用 - 运输管理系统 (TMS)
- 基础设施即服务 (IaaS) - 云数据库
适用行业
- 建筑物
- 运输
适用功能
- 维护
- 销售与市场营销
用例
- 自主运输系统
- 公共交通管理
挑战
Mighty Digital 是一家总部位于乌克兰的增长、分析和战略咨询公司，面临着帮助一家交通初创公司优化其广告预算效率、用户激活率和活动参与度的挑战。由于使用 Airflow 和 Python 转换构建的 ETL 管道效率低下，该初创公司对各种广告活动的成本效益没有清晰的了解。数据架构容易出错、丢失数据点，整体效率低下，导致广告结果不准确。现有的解决方案非常复杂，涉及将多个软件拼接在一起以创建一个无法提供任何见解的复杂架构。这导致缺乏数据洞察力、可靠性和可用性、营销活动和广告支出效率低下、无法将数据转化为客户保留优化，以及由于错误而降低对数据的信任。
关于客户
本案例研究中的客户是一家交通初创公司，该公司一直在努力优化其广告预算效率、用户激活率和营销活动参与度。在与 Mighty Digital 合作之前，由于数据架构效率低下且容易出错，这家初创公司对各种广告活动的成本效益并没有清晰的了解。该初创公司现有的解决方案非常复杂，并且无法提供任何见解，从而导致缺乏数据洞察力、可靠性和可用性、营销活动和广告支出效率低下，并且由于错误而降低了对数据的信任度。
解决方案
Mighty Digital 为 dbt Core 实施了 Fivetran 转换，以帮助运输初创公司释放其广告数据并提高预算效率。他们从 ETL 转向使用 Fivetran、dbt Core、BigQuery 和 Looker 的基于云的 ELT。 Fivetran 数据模型减少了工程时间并提供了开箱即用的一流建模。 Fivetran 提供了稳定的数据管道，可以使用 Fivetran Transformations for dbt Core 轻松进行转换和扩展。该解决方案使这家初创公司能够在竞争激烈的市场中加速发展，同时通过令人愉快的广告活动满足客户的需求。客户现在拥有集中在一个事实来源的值得信赖、快速的广告洞察。
运营影响
数量效益
相关案例.
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.
