Challenge: In the competitive healthcare industry, a clinic specializing in B2C and B2B online subscriptions and healthcare insurance packages sought to innovate its digital presence. Offering mobile and desktop app solutions, the clinic enabled customers to manage personal subscriptions, corporate employee health benefits, and family insurance plans with ease.
While the clinic successfully attracted consumers and businesses through various paid media platforms, it struggled to unify and interpret its expansive data landscape to find an edge and optimize their budgets. The clinic needed a comprehensive analytics solution to improve customer segmentation, predict churn, and refine its digital strategy.
To meet these challenges, we built an advanced data warehouse in Google Cloud Platform’s BigQuery, serving as a centralized resource for the clinic’s digital analysts. This warehouse integrated data from diverse sources, including Google Analytics 4, InnersTrends for in-app tracking, and CRM systems for holistic analytics.
Technical Implementation:
The data warehouse architecture included multiple processing layers to streamline the normalization and transformation of data:
Monitoring and Continuous Improvement:
The warehouse setup included proactive monitoring to ensure the reliability and accuracy of the data flows, enabling the clinic to continuously refine its analytics and reporting systems.
Impact on Business Strategy:
With the new data warehouse in place, the clinic is able to to:
Google Analytics, Firebase, Paid media platforms, Huawei AppGallery Connect, AppsFlyer, OMA, Cbox, Actito, Mailchimp, Funnel.io, InnerTrends, GCP Dataform, BigQuery Data Warehouse, Google Cloud Platform, Compute Engine, Instance Scheduler, Docker, Github, Tableau Desktop, Looker Studio
©2024 All rights reserved