Case Study

Unlocking Actionable Intelligence Through Data Transformation

challenge

Out of Date Platform Not Providing Enough Insights for Growth

The Head of Growth Marketing for a global payments company needed insight into how marketers were utilizing email contacts – specifically, what percentage of available contacts were emailed, how often and how early. The goal was to convert website visitors into active users for additional revenue growth. However, this exposed long-standing technical debt in their marketing systems. Without an upgraded platform to be able to better make sense of the data, they wouldn’t be able to increase sales conversions. 

solution

New Environment With Dynamic Data Visualization

To help our client achieve their sales goals, we: 

  • Designed and implemented a transformation pipeline to create a slowly changing dimension (SCD) that tracks email contact statuses over time (e.g., legal permission to send promotional emails and whether they were a website user).
  • Built a transformation algorithm to link the most relevant set of customer attributes for  multi-account users, such as signed up/gone live/adopted or platform/direct/connected.
  • Created an OLAP cube to precalculate metrics for various levels of detail using these transformed data resources.
  • Designed an interactive visual environment that allows the user to dynamically “slice and dice” various views of the data as time series.

results

More Accurate Insights

The Head of Growth Marketing gained a clear and accurate view of their marketing email asset utilization, which had previously been a mystery. They quantified underutilization and set clear targets and goals for the team. Without the data transformations, SCD modeling and OLAP cube, generating insights would have been impossible due to the complexity of the required queries. The project, from requirements gathering to implementation and user acceptance, was completed in just 12 weeks, delivering significant value to the client’s global marketing operations.

Related Case Studies
See All Case Studies
Case Study
Nov 26, 2024

Digital Transformation Catapults Global Retailer to $4 Billion Projected Revenue Boost

A leading international retailer with a multi-billion-dollar product roadmap faced significant challenges in their product development cycle. This led to a number of problems including the inability to ensure optimal ROI. Our client needed a partner to restructure their process and provide deeper insights into their product development cycle.

Read More
Case Study
Nov 12, 2024

Ensuring 100% Data Accuracy for a Global Tech Company

Our client, a global technology company, needed to launch an internal revenue reporting system for ingesting and tracking federal revenue data. The project required coordination across a large number of teams, ERP systems and virtual desktops, with significant manual work needed to fix data issues. Learn how we helped.

Read More
Case Study
Nov 11, 2024

Faster AI-Powered Mortgage Origination Process for Major Bank

A large bank’s mortgage origination department struggled with a time-consuming, labor-intensive application process. Reviewing and analyzing submitted documents took too long, leading to longer processing times and limiting how many applications Document Specialists could handle. The bank sought to automate the process to improve efficiency for both employees and customers. Learn how we helped.

Read More
Case Study
Nov 8, 2024

Scaling Dropship Operations to Increase Customer Satisfaction for Global Retailer

Our international clothing and lifestyle client saw increased demand for larger items, but their retail stores lacked storage space. They needed a dropship system that used their warehouses for storage and integrated with their existing processes and inventory system. Learn how we helped.

Read More
See All Case Studies
noun-arrow-2025160 copy 2
noun-arrow-2025160 copy 2
See All Case Studies