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.
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.
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.
- 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.
Featured Resources
Matillioners using Matillion: Alice Tilles' Journey with Matillion & ThoughtSpot
In the constantly evolving landscape of data analytics, ...
BlogWhat’s New to Data Productivity Cloud?
In July of this year, Matillion introduced the Data Productivity ...
BlogData Mesh vs. Data Fabric: Which Approach Is Right for Your Organization? Part 3
In our recent exploration, we've thoroughly analyzed two key ...