Visit Matillion AI Playground at Snowflake Data Cloud Summit 24

Find out more
Back to all
0058 Swish Logo Red Digital
Matillion Emerald Awards Solid Logo Green Navy TRANS Background WINNER

Unlocking Customer Insights at Swish Maintenance

Schedule a Demo
Swish Maintenance

42%reduction in monthly customer churn

$100,000 revenue growth from re-engaging churned customers

Identified potential growth opportunities among their customer base

Challenge

Following the implementation of Snowflake data warehouse, Swish Maintenance required an ETL solution that was easy to learn, capable of handling data extraction and transformation to optimize customer retention efforts.

Solution

Using Matillion for orchestration and transformation created a structured folder hierarchy (Ingest, Clean, Normalize, Integrate, Analyze) to move and manipulate data. This allowed data analysts to curate reports easily and empowered business users to create ad-hoc reports with clean, well-modeled data. Matillion features, including database queries, SQL server connectors, orchestration components, transformation tools, API integrations, and connectors for Magento and Google enabled versatility. 

Results

  • 42% reduction in monthly customer churn rate.
  • Generated $100,000 in additional revenue showcasing the financial impact of their ETL solution, through the re-engagement of churned customers.
  • Possessing the ability to identify "at-risk" customers allowed Swish to focus on retention with a view to growing sales in the future.