Adfirehealth.com managed programmatic ad campaigns for medical companies. Legacy data was stored in multiple, underperforming MsSQL databases and offline excel files. They wanted to digitally modernize their company.
Challenge 1: It was important to integrate all of their data sources into one single view of the healthcare professionals their campaigns were targeting.
Challenge 2: Adfire’s clients required one-to-one targeting on enriched profiles, making it paramount that all databases be integrated and kept up-to-date.
We saw the opportunity to migrate their legacy data, giving Adfire a clean, unified data layer to view their user profiles. This would allow all enrichments from offline files to be centralized and made in near real-time enrichments vs daily batch cleanup. With a centralized customer data platform as a single source of truth, non-technical and business stakeholders could collaborate on ad analytics and reporting insights without knowing SQL and without requesting time from Engineering or Data teams.
We delivered a custom data integration layer. Our platform allowed for the
sharing and reporting of actionable insights ready for Adfire stakeholders and
clients.
Integrating ad and person datasets into a single data warehouse.
Building a data warehouse and unified profiles for better ad performance reporting.
Validating all datasets and training the team to build their own data models on their new clean, unified data layer.
We delivered a custom data integration layer. Our platform allowed for the
sharing and reporting of actionable insights ready for Adfire stakeholders and
clients.
"I highly recommend Matt Strautmann to anyone who is struggling to develop their tech stack or needs guidance developing their data or product teams. We were hitting roadblock after roadblock when trying to implement the right technology and find the right resources to further develop our services and products. Matt helped us move past those barriers. He truly cares about his clients and is readily available which is helpful when you have a busy schedule. He is a valued partner who offers intellect, vision, strategy, and actionable steps forward."
