For HealthPost, heaps of great data lived in their Ecommerce platform, ERP, marketing and analytics platform. But all of it was unconnected and sitting in silos.
Overdose. leveraged the power of Google Cloud Platform's 'BigQuery' data-warehouse to bring together the data from these unconnected data sources. The solution required the use of Stitch data connectors as well as custom-built API connectors running from 'serverless' Google Cloud Functions. Once all the raw data integrations were running, Overdose. built a series of schedules and workflows within BigQuery to transform the source data into schemas that could talk to each other.
The HealthPost team needed to manually build ecommerce, marketing and commercial reports in spreadsheets which required upkeep and user intervention.
Overdose. worked collaboratively with HealthPost to leverage the power of Looker Studio and BigQuery's Custom Queries to build customized reports using the integrated data from their data-warehouse. This allowed for quick and easy access to the latest insights, enabling HealthPost to make informed decisions at the click of a button.
HealthPost invested advertising dollars across various channels, including social, search, affiliate marketing, and native ads. Although each platform provided performance reporting, they lacked a comprehensive view of how the marketing mix impacts new customer acquisition (CAC).
Overdose. implemented the AcqWire BI module, which integrates campaign performance data from various ad platforms with PII data from NetSuite. This enabled HealthPost to monitor changes in marketing mixes and track CAC trends comprehensively. With this, HealthPost gained a clearer understanding of their marketing performance, as well as a holistic view of the outcomes achieved by their marketing efforts.
HealthPost needed a comprehensive understanding of the influence of each marketing channel on customer behaviour to make informed ad spend decisions and explore new marketing channels.
Overdose. integrated direct post-purchase surveys into the AcqWire BI solution for HealthPost, allowing them to receive ongoing feedback directly from their customers. The surveys provide insights into where customers are being influenced and how they feel about their overall experience with HealthPost. With a sample size of over 45%, these insights are reflective of the entire population and provide HealthPost with valuable information to inform their marketing strategies and optimize their ad spend.
In response to the rising customer acquisition costs in the industry, HealthPost recognized the need to prioritize customer retention. To do so, they required an in-depth understanding of their customer base, including customer cohorts, re-purchase behaviors, product affinities, churn rates, and other retention metrics.
Overdose. implemented the Re10sion BI module, which ingests transactional and behaviour data to surface actionable customer insights. These insights helped HealthPost incentivise churned customers, reinvigorate predicted-churners, delight top customer cohorts, understand product affinities, LTV trends and much more.