What's Your Risk? Understanding Churn
Employers Resource Association, like many longstanding companies in recent years, was looking to use data analytics to better understand its members' churn rate. AMEND analyzed their historical churn information and current member mix to identify the drivers of churn and build a model to predict at-risk members.
This model functions to simultaneously signal which customers need extra care, point to inefficiencies in the business and help set appropriate retention, net member growth and revenue goals annually.
Overview
-
Company Overview
- Non-profit HR Services
- Cincinnati, OH
-
Assessing the Landscape
- Member-driven business model with 1,000s of members
- In existence for 70+ years
-
Identifying Opportunity
- Opportunity to improve net member growth
- Broad product suite with a needed understanding of value to them
- Considering new markets and target demographic
Results
Planning
Set appropriate net member growth goals
Metrics
Effectively tested retention metrics and identified retention risk
Budget
Implemented a budgeting strategy for new target development
The Solution
Churn Probability Model
We built an algorithm that leverages usage, interaction and sales data by member and product type to predict the likelihood of churn for each member, each year.
This model uncovers what matters, sets expected member and dollar losses annually and identifies members at risk of churn.
Power BI Dashboard
We developed a reporting mechanism to highlight at-risk customers and the drivers of that risk.
This dashboard is utilized by several departments in the organization including client services, sales, finance, and marketing to target retention opportunities, determine retention strategies, standardize practices, and set budgets.
The AMEND Process
Design and Discovery
Met extensively with the executive team to fully understand the strategic goals of the business. This discovery uncovered the need to better assess member health and capture drivers of churn.
Data Architecture
In collaboration with the IT team, we connected and cleaned data sources into a single source of truth in Power BI.
Model Development and Implementation
Using more than 15 years of member churn data, a logistic regression model was built to predict the likelihood of churn by member and report back on the five biggest drivers of churn.
