Scaling multi-touch attribution to optimize pharmaceutical marketing impact

Scaling multi-touch attribution to optimize pharmaceutical marketing impact

OneSix developed a scalable multi-touch attribution solution for a biopharmaceutical company, enabling precise measurement of marketing impact across channels, optimizing budget allocation, and accelerating data-driven insights for increased healthcare provider engagement.
AI & Machine Learning

Overview

Improving multi-touch attribution for targeted biopharma marketing

A leading biopharmaceutical company, known for its breakthroughs in innovative treatments, sought to improve its understanding of multi-channel marketing impacts on healthcare providers (HCPs), specifically in driving new-to-brand prescriptions (NBRx). With a vast marketing ecosystem, the company employed multiple touchpoints—including email, digital ads, and in-person events—to reach providers across various stages of the decision journey.

Although they had a proof-of-concept model for multi-touch attribution (MTA), it needed to be scaled and fine-tuned to operate effectively in a production environment. Additionally, the company needed a parameterized solution capable of segmenting MTA results by brand, franchise, and indication. The ultimate objective was to develop a robust and flexible MTA model that could accurately attribute marketing impact and optimize budget allocation to maximize engagement with HCPs.

Effective multi-channel marketing in the pharmaceutical industry is challenging, as each channel and publisher varies in its reach, engagement, and effectiveness. Unlike a single-channel approach, multi-touch attribution must capture how touchpoints interact within complex user journeys. An ideal solution would involve controlled experiments to precisely isolate channel impacts; however, the cost and frequency requirements of such experiments make them impractical for real-world applications. The client needed a more scalable approach that leveraged existing data to measure past performance and generate actionable insights for future marketing decisions.

Our Solution

Designing a scalable and adaptive MTA pipeline

OneSix built a highly parameterized, unit-tested Python package to perform MTA on the client’s diverse marketing initiatives, focusing on measuring individual touchpoint effectiveness across brands and indications. The model’s core function was to predict the probability of an NBRx occurring, based on a combination of control and independent variables derived from the various marketing channels. To further refine the model, OneSix introduced an advanced explainer model that could assign a partial contribution to each control and independent variable, providing a breakdown of the factors driving NBRx outcomes.

The MTA model was designed to address key technical challenges, including calibration to adjust for the sigmoid distortion often seen in probability densities from predictive models. This adjustment was achieved through a custom calibration scheme, which corrected probability distortions to ensure that all variables received a positive partial contribution. The parameterized structure of the model allowed users to modify factors such as study period lengths, feature sets, and segment parameters (e.g., brand or indication) with ease. The package was controlled by a single configuration file, providing a centralized interface for rapid experimentation and model adjustments via a command-line interface.

As a result, the pipeline offered flexibility for experimentation across different market baskets and feature combinations, empowering the client’s data science team to iterate quickly and test various configurations. By providing a modular, scalable, and flexible solution, OneSix’s MTA model allowed for high adaptability, enabling the client to execute MTA analyses on demand and derive actionable insights at a pace previously not possible.

Results

Accelerated data-driven insights and improved marketing allocation

The implementation of this comprehensive MTA pipeline enabled the client to gain a deeper understanding of how different marketing touchpoints contributed to NBRx conversions and overall engagement with HCPs. With OneSix’s solution in place, the company was able to assess the individual and combined impacts of each marketing channel, allowing them to identify high-performing channels and optimize spend allocation with confidence. By analyzing the contributions of different touchpoints within the customer journey, the company could now tailor its marketing strategies to maximize engagement and ROI on specific channels.

The streamlined configuration and command-line interface allowed the client’s data science team to rapidly test hypotheses and iterate on model features, reducing the research cycle and enhancing their agility in responding to market dynamics. Continued collaboration with OneSix provided the company with regular updates and enhancements to the MTA model, enabling ongoing improvements and refinements to its methodology. As a result, the biopharmaceutical company was able to achieve a more precise, data-driven approach to marketing attribution, laying a scalable foundation for sustainable growth and optimized channel investment across its brands and franchises.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Leveraging AI to increase provider engagement for a top pharmaceutical company

Leveraging AI to increase provider engagement for a top pharmaceutical company

OneSix developed an AI-driven, multi-channel outreach engine for a global pharmaceutical client, enabling automated, personalized provider engagement across brand portfolios with scalable, data-informed insights.
AI & Machine Learning

Overview

Leveraging AI for a coordinated, personalized marketing strategy

Our client, a top 5 global pharmaceutical company, sought to build and deploy an AI-powered multi-channel outreach engine to coordinate provider engagement across multiple brand portfolios. Their manual engagement process lacked the ability to personalize outreach at the individual provider level, relying instead on aggregate customer segments. This approach created substantial inefficiencies, limited scalability, and missed opportunities to tailor interactions based on individual provider traits and behaviors.

Our Solution

Developing an AI-driven multi-channel outreach engine

OneSix built a custom AI solution leveraging enterprise reinforcement learning technology to automate and optimize provider engagement. Using real-time data on provider traits, behaviors, and patient populations, the solution integrates multi-brand and multi-channel outreach into a single system. The platform, powered by Strong RL, Apache Spark, and Tensorflow, is designed to scale within the client’s on-premise infrastructure to accommodate vast data volumes and diverse brand requirements.

Results

Enhanced efficiency and personalized engagement at scale

With this AI-driven outreach engine, our client achieved a highly efficient, data-driven provider engagement strategy, enabling coordinated, personalized interactions across brands and channels. The system improved engagement outcomes by predicting provider response probabilities and suggesting targeted interventions. As a result, the pharmaceutical company can engage providers in a more tailored, impactful way, leveraging individual insights at scale and significantly reducing manual efforts.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Centralizing data for real-time insights and decision-making in pharmaceuticals

Centralizing data for real-time insights and decision-making in pharmaceuticals

OneSix implemented an enterprise data warehouse for a pharmaceutical client, centralizing data to enhance visibility, streamline analytics, and support real-time decision-making across business functions.
Data & App Engineering
Data Analytics
AWS
Tableau

Overview

Enhancing visibility and data-driven decision-making

Our pharmaceutical client needed a sophisticated solution that provided more visibility into every facet of their operations. The company manufactures an extensive number of specialty injectable products for service providers in this space, leaning on data analytics to guide supply chain decisions as well as other core business functions.

Company leaders came to OneSix seeking our help to move beyond their limited, spreadsheet-based approach and architect a sophisticated analytics solution that provided more visibility into every facet of their operations.

Our Solution

Designing an enterprise data warehouse for unified analytics

OneSix helped design and implement a comprehensive enterprise data warehouse to manage all of our client’s analytics needs. The data warehouse is integrated with numerous internal and external systems of record, giving organizational stakeholders a single source of historical data.

Using an agile delivery process, our team was able to quickly create and roll out holistic business intelligence dashboards that could be accessed by different business units, including finance, sales, marketing, and supply chain teams.

Technologies Implemented

Results

Delivering insights and operational visibility with a single source of truth

Since implementing this comprehensive data warehouse solution, our client has enjoyed the confidence of knowing that all organizational data is stored in a single, easy-to-reach location.

Valuable information and metrics are no longer locked away in departmental silos, and stakeholders have more visibility and greater access to insights such as real-time inventory management. An integrated view now exists across multiple physical locations, leveraging sales, finance, purchasing, and inventory data in a single portal for analytics.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Solving data sprawl challenges for a healthcare tech company

Solving data sprawl challenges for a healthcare tech company

OneSix implemented a centralized data lake and data warehouse solution for a healthcare technology firm, enabling streamlined data management, on-demand analytics, and enhanced decision-making across the enterprise.
Data & App Engineering
AWS
Tableau

Overview

Managing data sprawl and enabling comprehensive analytics

It’s easy to forget how big “big data” can really be. Large organizations produce vast quantities of data every day, sometimes with no practical way to capture, organize and store it all. The result: unwieldy data sprawl that prevents organizations from fully capturing a complete view of their operations.

As a healthcare education, product, and technology firm, our client was no stranger to these barriers. It generated massive amounts of data but had no central repository to organize that data and report on it across the enterprise. OneSix helped create a data warehouse solution that could put an end to our client’s data sprawl problems and establish a foundation to support ongoing analytics efforts.

Our Solution

Implementing a centralized data lake and data warehouse

Because our client produced so much data, OneSix used a centralized data lake approach to effectively house and manage its numerous, high-volume data sources. Our team helped define the data collection and aggregation strategy, as well as develop the solution’s information architecture.

Treasure Data’s cloud-based data management platform served as the basis for the data lake implementation and helped our team set up the automation needed to streamline data capture and aggregation across the enterprise.

With user-friendly dashboards and visualizations built through Tableau (leveraging data directly from the Amazon Redshift data warehouse), our client has the tools to easily generate reports for key stakeholders and guide strategic decision-making.

Results

Empowering on-demand analytics and enabling future growth

The new data warehouse solution can house and aggregate billions of rows of data to support end users in an on-demand capacity. The speed and agility of our client’s analytics capabilities have been greatly increased as a result of this new data lake implementation. 

Business analysts can report on operational performance related to sales, marketing, advertising and much more. Thanks to OneSix’s help, our client is well-positioned to expand and refine its analytics efforts in the future, continuing to produce valuable insights that produce better business outcomes.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Uncovering insights into member engagement for a digital health company

Uncovering insights into member engagement for a digital health company

OneSix implemented a scalable data warehouse solution for a digital health company, enabling efficient, accurate reporting and data-driven insights into member engagement across texting programs.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Streamlining insights into member behavior

A digital health company was looking to better handle its customers’ needs by providing insights into member behaviors within its texting programs.

Our client provides their customers with various metrics with regard to participation and engagement in their many texting program offerings. As requests come in for new information and/or slight variations in existing reports, our client needed a better way to meet these requests.

The existing process was very manual and prone to errors, sometimes delaying turnaround time in responding to customers’ data requests. This process impeded the client’s ability to create new reports or aggregate reports across multiple programs for each customer. The current reporting could represent a point in time but did not easily allow for trends over time.

Our Solution

Building a flexible data warehouse with automated ETL

OneSix designed and built a data warehouse that could handle the client’s current and future needs in both reporting and data analytics. We created a data model that could handle today’s reporting needs while allowing the flexibility to add on later. 

Using Fivetran, we brought their source data, SQL Server and DynamoDB, into a Snowflake database. Using Matillion, we built a fully automated ETL process with fewer steps and a faster turnaround time to provide up-to-date data. The reporting and analytics are now available in Power BI.

Technologies Implemented

Results

A single source of truth for decision-making and trend analysis

With this solution and knowledge transfer, the organization is able to leverage the analytics output from our project as a template for building future reporting. A single source of truth from the cloud data warehouse allows the business to look at the numbers with confidence for decision-making.

Key financial metrics are available to view by snapshot, trends, as well as drill-down to more granular components in a visual, easy-to-digest method. The labor reporting has already yielded insight into better management of overtime for the workforce.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Driving ROI and data-driven decisions with self-service reporting for regenerative medicine

Driving ROI and data-driven decisions with self-service reporting for regenerative medicine

OneSix implemented a secure, self-service Power BI reporting solution, enabling a regenerative medicine company to gain immediate ROI from their new CRM/ERP system and drive data-informed decisions across sales and finance.
Data Analytics
Microsoft Azure
Power BI

Overview

Leveraging new CRM/ERP data for actionable insights

A regenerative medicine company specializing in placental-derived products was in the process of a technology transition. The company implemented Dynamics 365 Business Central as its new CRM and ERP platform to track sales and accounts receivable.

Their new platform unlocked troves of new data that opened a new future for their business, one that is rooted in analytical insights and data-driven decision-making. But, in order to get a valuable ROI for their system upgrade, they needed a self-service reporting platform to take advantage of their newfound data assets.

Our Solution

Building a Power BI reporting suite for self-service access

OneSix developed a suite of reporting tools within Power BI to equip the company with the data it needed to improve its bottom line.

Self-service data enablement was built in, enabling access to clean, curated datasets and reporting insights to all team members, from any device. Row-level security settings open the door to insights beyond the C-Suite, allowing individual salespeople to securely log in and see their own revenue growth, identify cross-sell opportunities at a product level, or profile important customers.

Technologies Implemented

Results

Empowering data-driven decision-making across teams

With this highly interactive, foundational reporting structure, the client is now primed to create a culture of data-driven decision-making.

The sales team can see their performance and drill down into a variety of different data points to help set strategy. The accounting team has a one-stop shop for both tracking their accounts receivable at a high level and accessing line item-level datasets that can be integrated into existing workflows without disrupting operations.

The new reporting structure will allow the company to yield immediate ROI on their system upgrade by having reporting live immediately as they transition to their new CRM/ERP system.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Establishing a competitive edge with embedded analytics for Chordline Health

Establishing a competitive edge with embedded analytics for Chordline Health

OneSix empowered Chordline Health to gain a competitive edge by implementing a scalable, multi-tenant analytics solution that improved application performance, reduced operational costs, and delivered real-time insights directly within their SaaS platform.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran

Overview

Enhancing SaaS competitive edge with scalable, embedded analytics

Chordline Health, a healthcare software provider, wanted to gain a competitive advantage with their SaaS application by offering feature-rich analytics embedded into the application.

Existing analytics was driven off the single-tenant operational databases using complex SQL statements that could not be reused across customers due to the different data models per customer. Any needed changes were restricted by the legacy approach that required extensive labor and testing to enhance. The application experienced severe performance issues. A scalable solution was needed to expose the trove of data for customers that could be easily integrated into their application.

Our Solution

Implementing an automated data framework

OneSix designed an end-to-end automated framework to load multi-model databases per customer into a data lake and transformed that into a multi-tenant data warehouse addressing Cases, Authorizations, To-do lists, and Compliance threshold reporting.

All new tools and platforms were introduced that would help automate new customer loads by using a simple control table. A live connection to the data warehouse using the powerful Snowflake engine served embedded analytics using Sisense visualization. The complex security model was simplified via two security tables that allowed bi-directional integration between Sisense and the SaaS application.

Technologies Implemented

Results

Boosted application performance and reduced labor costs

The implementation of the Embedded Analytics solution brought about significant positive changes for the SaaS provider:

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.