Case Study: Ritual achieves improved retention and 95% fewer data pipeline issues with Fivetran

Ritual Improves Retention With a Modern Data Stack

Ritual, an LA-based direct-to-consumer subscription wellness brand, faced unreliable retention reporting because of a brittle ETL pipeline, fragmented transformation code and degrading warehouse performance. To get a single source of truth for retention and accelerate analysis, Ritual migrated to a modern data stack using Fivetran for automated pipeline ingestion alongside Snowflake (warehouse), dbt (in-warehouse transformations) and Looker (BI).

Fivetran now extracts and loads transactional, email and web interaction data into Snowflake where dbt snapshots and transforms it for Looker, eliminating pipeline failures and speeding analysis. The new stack delivered a 95% reduction in data pipeline issues, a 75% reduction in query times, a threefold increase in data team velocity (and a ~68% uplift in feature development thanks to dbt), and enabled sustained month-over-month retention improvements through faster cohort analysis and personalized customer messaging.

Ritual

Brett Trani

Director of Data and Analytics