Case Study: LiveRamp achieves faster customer journey insights with Matillion

LiveRamp cuts analysis time from 1–2 days to instant with Matillion

LiveRamp, a marketing and advertising company, faced the challenge of visualizing the complete customer journey due to data being locked in various silos across their organization. With information spread across marketing, sales, product, and finance teams in different time zones and formats, Senior Manager Hoshang Chenoy needed a way to stitch this data together centrally. The challenge was compounded by the need to govern the data properly and exclude sensitive PII.

The solution was implemented using Matillion ETL for Redshift. The product was chosen for its seamless integration with Redshift, its ability to handle complex data transformation, and its flexibility for writing custom code. The results included a centralized dashboard consolidating up to 20 data sources, which reduced the time to access conversion rates to under five minutes per metric. This provided instant analysis to stakeholders, guiding strategy with an easy-to-understand interface and ultimately helping LiveRamp use the right message at the right time in the buyer's journey.

LiveRamp