Healthcare E-Commerce BI and Data Science

The Challenge

A healthcare e-commerce company selling medical-grade supports and braces — had grown rapidly from a basement operation to a team of over 20 staff. That growth brought a sprawl of disconnected systems: an ERP for inventory and orders, Shopify and Amazon for sales channels, multiple advertising platforms, Zendesk for customer support, and several shipping providers. Data was siloed across each platform with no way to connect the dots. Leadership couldn’t answer fundamental questions about product profitability because costs, returns, advertising spend, and support overhead were all tracked in separate systems with no common key.

Our Approach

CorrDyn designed and built a unified data pipeline that ingested data from every SaaS platform into BigQuery, creating a single source of truth for the business. The most complex challenge was metadata attribution — connecting an advertising click on one platform to a sale on another, a return processed through a third, and a support ticket logged in a fourth. We built a normalized data model with complex attribution logic that accounted for the nuances of each channel, including marketplace fees, return shipping costs, and allocated customer support time. On top of this foundation, we developed a Looker BI suite with dashboards tailored to each department’s needs: marketing saw campaign ROI, operations tracked fulfillment efficiency, and leadership had a full product profitability view.

The Results

For the first time, the company could see true end-to-end profitability for every product across every channel. The analysis revealed that a significant portion of their catalog was generating minimal or negative margin once advertising, returns, and support costs were factored in. Armed with this data, leadership made the decision to reduce the product portfolio by 30%, cutting low-margin items and redirecting resources toward their most profitable lines. Self-service reporting was enabled across all departments, eliminating the previous reliance on ad-hoc spreadsheet analysis and giving managers real-time visibility into the metrics that mattered to their teams.