Retention Analytics Uncovered Hidden Attrition Risks (Saved $85K)
Executive Summary
Richardson & Associates, a Registered Investment Advisor (RIA) managing over $250 million in assets, struggled with unexplained client attrition that impacted firm profitability. By implementing retention analytics using their existing client data, they identified key risk factors driving churn. Proactively addressing these concerns with at-risk clients resulted in preventing the loss of approximately $85,000 in annual recurring revenue and strengthening client relationships.
The Challenge
Richardson & Associates experienced a concerning trend: an average client attrition rate of 6% annually over the past three years. While a certain level of attrition is expected, the firm lacked a clear understanding of the underlying reasons, making it difficult to develop targeted retention strategies. Preliminary analysis revealed that the largest losses typically occurred within the first 18 months of a client relationship, with an average client bringing in $10,000 in annual revenue.
The problem was exacerbated by a lack of readily available data. Client information was scattered across multiple systems, including their CRM, portfolio management software, and a collection of spreadsheets. This made it extremely difficult to identify patterns and correlations between client demographics, investment behavior, communication frequency, and attrition. Specifically, they suspected that clients with certain investment strategies, like those heavily invested in growth stocks, might be more sensitive to market volatility and therefore more likely to churn during downturns. However, without a unified view of their data, they were unable to confirm or refute this hypothesis.
Further complicating matters, Richardson & Associates relied heavily on reactive retention efforts. When a client initiated the process of transferring their assets to another firm, the team would scramble to understand the reasons for their dissatisfaction and attempt to salvage the relationship. However, this approach was often too little, too late. The firm needed a proactive strategy to identify at-risk clients before they decided to leave. The lack of proactive strategy, coupled with client attrition costing roughly $60,000 per year, meant that a more proactive plan would save money and maintain AUM.
The firm also recognized that certain segments of their client base were more prone to attrition. For example, clients acquired through referrals from existing high-net-worth clients tended to be more loyal, while those acquired through online marketing campaigns were more likely to churn. However, they didn't have the data to quantify this difference or to target their retention efforts accordingly.
The Approach
Richardson & Associates decided to implement a data-driven retention strategy to proactively identify and address client attrition risks. The approach consisted of three key phases: data consolidation, risk factor identification, and proactive intervention.
Phase 1: Data Consolidation. The first step was to consolidate client data from various sources into a central repository. This involved extracting data from their CRM (Salesforce), their portfolio management system (Orion Advisor Tech), and their accounting software (QuickBooks). This data was then cleaned and standardized to ensure consistency across different systems. Key data points included client demographics (age, income, location), investment portfolio characteristics (asset allocation, risk tolerance), communication history (frequency of phone calls, emails, meetings), and financial planning activity (frequency of financial plan updates, participation in educational events).
Phase 2: Risk Factor Identification. Once the data was consolidated, Richardson & Associates used Tableau to visualize and analyze the data to identify key risk factors associated with client attrition. They began by examining the characteristics of clients who had churned in the past. This involved identifying common patterns and correlations between various data points and attrition. For example, they discovered that clients who had not had a financial planning review in the past year were significantly more likely to churn. They also found that clients with a higher proportion of their assets in volatile investments were more likely to leave during periods of market uncertainty.
Phase 3: Proactive Intervention. Based on the identified risk factors, Richardson & Associates developed a proactive intervention strategy to address the concerns of at-risk clients. This involved segmenting clients based on their risk profile and developing tailored communication and engagement strategies for each segment. For example, clients who had not had a financial planning review in the past year were proactively contacted to schedule a review. Clients with a higher proportion of their assets in volatile investments were provided with additional education and reassurance about their investment strategy. They also began proactively contacting clients who were nearing the 18-month mark of their relationship to check in and address any potential concerns.
The overall strategy involved a shift from reactive firefighting to proactive relationship management. This proactive approach allowed Richardson & Associates to anticipate client needs, address potential concerns before they escalated, and ultimately strengthen client relationships. They implemented a quarterly review of attrition trends and proactively contacted the highest risk group.
Technical Implementation
The technical implementation involved integrating various data sources, developing a risk scoring model, and implementing a workflow for proactive intervention.
Data Integration: Richardson & Associates used Tableau Prep to extract, transform, and load data from their CRM, portfolio management system, and accounting software into a centralized data warehouse hosted on Amazon Web Services (AWS). Tableau Prep allowed them to clean and standardize the data, ensuring consistency across different systems. They used the AWS Glue catalog to maintain metadata for the data warehouse.
Risk Scoring Model: Richardson & Associates developed a risk scoring model in Tableau based on the identified risk factors. The model assigned a score to each client based on their individual characteristics and behavior. Key factors included:
- Time Since Last Financial Plan Review: Clients who had not had a financial plan review in the past year were assigned a higher risk score. Specifically, the algorithm deducted 5 points for each quarter since the client's last review.
- Investment Volatility: Clients with a higher proportion of their assets in volatile investments were assigned a higher risk score. The volatility score was calculated using the standard deviation of the client's portfolio returns over the past three years. A standard deviation above 15% resulted in a 10 point deduction from their overall score.
- Communication Frequency: Clients who had limited communication with the firm were assigned a higher risk score. The team tracked the number of phone calls, emails, and meetings with each client over the past three months. A score of less than 3 interactions a month resulted in a 7 point deduction.
- Net Asset Flow: Clients experiencing withdrawals beyond regular distributions are flagged. A withdrawal of more than 5% of assets in a quarter resulted in a 8 point deduction.
The final risk score was a weighted average of these factors, with weights determined based on their correlation with attrition in the past. The risk score was then categorized into three tiers: low, medium, and high.
Proactive Intervention Workflow: The risk scores were integrated into the firm's CRM system (Salesforce). A custom dashboard was created in Salesforce that displayed each client's risk score and provided recommendations for proactive intervention. The dashboard also included a task management system that allowed advisors to track their progress in addressing the concerns of at-risk clients. Advisors would receive automated reminders to contact high-risk clients and schedule financial planning reviews.
The firm implemented a strict policy that advisors would spend a minimum of 2 hours each week proactively reaching out to clients who were flagged by the system as being at high risk of churn. During these calls, the advisors were required to use a standardized script and to record detailed notes in the CRM about the client's concerns and any action steps that were taken. All activity was automatically logged and reported to management.
Results & ROI
The implementation of retention analytics yielded significant improvements in client retention and firm profitability.
- Reduced Attrition Rate: The annual client attrition rate decreased from 6% to 3% within the first year of implementation. This represents a 50% reduction in attrition.
- Increased Client Retention: The client retention rate increased from 94% to 97%.
- Revenue Savings: By preventing the loss of approximately 8.5 clients (based on the pre-implementation attrition rate), Richardson & Associates saved approximately $85,000 in annual recurring revenue ($10,000 per client).
- Improved Client Satisfaction: Client satisfaction scores, as measured by the firm's annual client survey, increased by 15%. This indicates that the proactive intervention strategy was successful in addressing client concerns and strengthening relationships.
- Increased Advisor Efficiency: The data-driven approach allowed advisors to focus their efforts on the clients who were most at risk of churning, leading to increased efficiency and productivity. Advisors reported spending 20% less time on reactive retention efforts and 10% more time on proactive relationship building.
The ROI of the retention analytics initiative was significant. The initial investment in data integration, software licenses, and training was approximately $20,000. The annual cost of maintaining the system was estimated at $5,000. The return on investment was therefore calculated as follows:
ROI = (Revenue Saved - Initial Investment - Annual Maintenance Cost) / Initial Investment ROI = ($85,000 - $20,000 - $5,000) / $20,000 ROI = 3.0 or 300%
This demonstrates that the retention analytics initiative was a highly successful investment for Richardson & Associates.
Key Takeaways
- Data is Key: Client data is a valuable asset that can be used to identify and mitigate attrition risks.
- Proactive is Better than Reactive: A proactive retention strategy is more effective than a reactive one.
- Personalized Communication Matters: Tailored communication and engagement strategies are more effective than generic approaches.
- Integrate Data with CRM: CRM systems are a good place to integrate your retention analysis.
- Continuous Monitoring and Improvement: It is important to continuously monitor attrition trends and refine the retention strategy over time.
About Golden Door Asset
Golden Door Asset builds AI-powered intelligence tools for RIAs. Our platform helps advisors proactively manage client relationships, identify growth opportunities, and improve operational efficiency. Visit our tools to see how we can help your practice.