Skip to content
LazyAnalyst Lookbook
Share
Explore

Unlocking Customer Insights for a Healthcare E-Commerce Brand

1.5-year ongoing retainer contract with periodic project work

Story

Allermi, a fast-growing e-commerce healthcare brand, needed to understand how customers moved through their funnel - from signup and quiz completion to subscription. But they had no data warehouse, no reporting architecture, and no ability to connect marketing activity to onboarding outcomes. With budget limitations and tool integration issues compounding the problem, they turned to LazyAnalyst for help. We stepped in as their strategic data partner, built an end-to-end pipeline, and stayed on as their fractional data team as the company matured. What began as a lean infrastructure project has grown into a long-term architecture powering their customer insights, retention strategy, and investor reporting.

Challenges

No data warehouse or reporting structure in place
Inability to analyze onboarding drop-offs or conversion trends
Budget ruled out top-tier tools like Fivetran
Klaviyo’s connector failed to sync with AWS via Supermetrics
A third-party connector introduced bugs and reliability issues
No visibility into funnel performance or marketing ROI

Solutions

Designed a scalable data strategy aligned with Allermi’s growth goals
Integrated Klaviyo data into AWS Redshift using Hevo as the connector
Modeled and transformed raw data to support funnel and cohort analysis
Built Looker Studio dashboards to track activation stages like account setup and medical quiz completion
Provided strategic analysis of onboarding metrics to improve conversion flows
9 months later, upgraded the stack to Databricks and Domo for scalability and multi-source integration (Shopify, Iterable, Pharmacy App data)
Retained for ongoing architecture expansion and data maintenance

Outcomes

Real-time visibility into customer onboarding and drop-off points
Clearer understanding of funnel performance and conversion drivers
Improved onboarding experience and data-driven optimization of messaging
Reliable data infrastructure that supports investor visibility and team-wide access
Ongoing expansion into a full BI command center as the brand scales

Testimonial

The new insights we have are quite eye-opening for all of us. Working with Corinna has been a game-changer. She helped spearhead the development of a comprehensive data pipeline and built custom dashboards, providing us with deeper insights into our customer journey and essential touchpoints for testing and optimization. Her exceptional data expertise and commitment to our business goals have made her an invaluable partner. I'm excited to continue collaborating with her as we transform into a truly data-driven organization!
- Christian Liu, CMO @Allermi

Skills

Data Strategy · Databricks · Business Intelligence (BI) · Marketing Analytics · Data Project Management · Data Product Management · Process Analysis · Klaviyo · Amazon Redshift · PostgreSQL · Looker Studio · Hevo · Domo · API Development · Data Migration · Integrate.io · Fivetran

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.