Case Studies: Clutch

Their success

1

Ingested & transformed thousands of rows of data from inbound API records per hour

2

Improved machine learning outcomes with data cleansing in Matillion

3

Saw a quick ROI with the pay-as-you-go pricing model through AWS Marketplace

About

Clutch’s Customer Management platform delivers actionable customer intelligence and personalized engagements that empower B2C companies to uniquely identify, understand, and motivate each individual in their customer base. The platform integrates real-time customer data across point-of-sale, e-commerce, mobile and social channels, marketing touchpoints, and more, back to a single individual customer record. With the addition of machine learning, the platform is able to deliver highly personalized and relevant engagements to increase the value of each customer.

Company: Clutch

Location: Pennsylvania, USA

Industry: Marketing and Advertising

Employees: 200

Product: Matillion ETL for Amazon Redshift

Use Case: Data Warehouse Modernization, Machine Learning

Website: https://www.clutch.com/

The challenge

Every brand is unique - and so is its data

The Clutch platform helps B2C marketers build relationships with consumers, encourage them to spend more and order more, and get highly personalized Artificial Intelligence and Machine Learning assisted guidance for consistent, timely communication. But for Clutch, no two clients are alike. They have differing Point Of Service (POS) systems, CRM platforms, and verticalspecific attributes and measurements. To ensure that all customer data was available for reporting in a scalable and timely manner, Clutch needed a more sophisticated platform to handle data diversity and load operations from both locally stored data sources and also a broad spectrum of web-based systems.

The solution

Actionable data within hours

As part of their overall data warehouse modernization initiative, Clutch decided on a host of AWS solutions. Clutch selected Amazon Redshift as it’s data warehouse, replacing Informatica. In addition to Amazon Redshift, Clutch also selected Matillion ETL for Amazon Redshift due to its tight integration with Amazon Redshift, as well as its powerful data transformation capabilities. Matillion, working together with AWS services like Amazon Redshift, Kinesis, S3, SQS and more, plays a vital role in getting Clutch’s customer data into an actionable form for marketers to act on within hours, not days or weeks.

The benefits

Maneuvering massive amounts of data to drive insight

With Matillion, Clutch can now ingest, transform, and maneuver the massive amounts of retail, banking, and pharmaceutical data their customers rely on to drive insight, segmentation, and loyalty. With the Matillion pay-as-you-go model, Clutch affordably maintains logic and process separation. Multiple Matillion instances are used to drive internal processes, while separate instances are used to segregate client data workflows to ensure all data is being appropriately handled. This has proved to be instrumental in understanding data volume, process complexity, and other important metrics for the cost of operation and cost of sale. By setting complex business and data processing rules within Matillion, Clutch can tackle challenges from it’s customers that were too time-consuming, costly, or otherwise not feasible on legacy systems.

The results

  • Ingests and transforms thousands of rows of data from inbound API records per hour, and several terabytes of data submitted via batch channels (SFTP) via Matillion.

  • Brings in new data 24/7 with Matillion’s highly available infrastructure

  • Improved machine learning outcomes with data cleansing in Matillion.

  • Achieved clear operational and sales reporting with a multi-instance set up that segregates internal vs. external workloads

  • Saw a quick ROI with the pay-as-you-go pricing model through AWS Marketplace.

  • Increased agility and reduced time to market on ETL-heavy products and projects, a significant competitive benefit.

  • Improved system performance by replacing costly and inefficient legacy systems with a modern technology stack.

What's next

Even faster time to insight for customers

Since Matillion can handle point-of-sale, e-commerce, mobile and social channels, marketing touchpoints, and other data types across a number of verticals including retail, banking, and pharma, the possibilities for expansion are limitless. Because Matillion leverages the multiple processing and scalability of the cloud, Clutch can onboard new clients quickly and enable them to gain insights from data much faster. By building faster, data analysts have more time to mine data and discover insights. Furthermore, Clutch can meet more complex client needs involving multiple data sources, data governance, and security requirements, using Matillion’s simple yet extensible ETL development process via a graphic user interface. Arming data analysts with more and better quality transformed data helps them make better decisions. This enables Clutch to be more competitive and create more innovative ways for clients to create lasting customer loyalty.

Begin your data journey

Matillion provides simple, powerful, easy to use data integration and ETL products that enable your company's data journey.