CRM & Client Lifecycle

Purpose

Guide the design, implementation, and optimization of client relationship management systems and lifecycle workflows for wealth management and advisory firms. This skill covers client segmentation models, household structure management, service tier frameworks with defined SLAs, review scheduling and preparation workflows, lifecycle stage tracking from prospect through estate succession, CRM data architecture and integration with portfolio management and custodial systems, and client engagement analytics including retention risk identification and wallet share analysis. It enables a user or agent to design CRM strategies, evaluate CRM platforms, build client service programs, and troubleshoot relationship management workflows that maximize client retention, deepen relationships, and ensure systematic service delivery across the entire book of business.

Layer

10 — Advisory Practice (Front Office)

Direction

both

When to Use

• Designing or evaluating a client segmentation model for an RIA or broker-dealer
• Building household structures that link individuals, accounts, trusts, and entities
• Defining service tier frameworks with SLAs, review cadences, and service menus
• Designing client review scheduling workflows and preparation checklists
• Tracking client lifecycle stages from prospect through estate succession
• Integrating CRM with portfolio management systems, custodians, and financial planning tools
• Identifying at-risk clients using engagement analytics and retention scoring
• Analyzing wallet share and held-away asset opportunities
• Building referral tracking and client satisfaction measurement programs
• Evaluating CRM platforms (Salesforce, Wealthbox, Redtail, Microsoft Dynamics) for advisory firms
• Designing advisor assignment and team-based service models
• Standardizing contact logging, activity tracking, and opportunity management workflows

Core Concepts

Client Segmentation Models

Client segmentation assigns every household to a category that determines the level of service, contact frequency, review cadence, and resource allocation the firm provides. Without systematic segmentation, advisors default to reactive service — responding to whoever calls — rather than proactive, tiered engagement that matches effort to relationship value.

AUM-based segmentation is the most common starting point. A typical three-tier model:

Tier	Household AUM	Typical Label
A	$2,000,000+	Platinum
B	$500,000 - $1,999,999	Gold
C	Under $500,000	Silver

AUM-based segmentation is simple to implement because AUM data is readily available from the custodian or portfolio management system. However, AUM alone is an incomplete measure of relationship value.

Revenue-based segmentation uses total annual fees generated by the household rather than asset levels. This captures value more accurately when fee schedules vary across clients, when some households pay financial planning fees in addition to AUM fees, or when clients have complex billing arrangements. Revenue data comes from the billing system and should be annualized to smooth quarterly fluctuations.

Multi-factor segmentation combines quantitative and qualitative dimensions for a more complete picture:

• Assets under management (current relationship size)
• Revenue generated (actual economic value to the firm)
• Growth potential (age, career trajectory, expected inheritances, held-away assets not yet consolidated)
• Referral activity (clients who actively refer new prospects)
• Relationship depth (number of services engaged — investment management, financial planning, tax planning, estate planning, insurance)
• Strategic importance (centers of influence, professional advisors who refer, board members, community leaders)

Behavioral segmentation classifies clients by engagement patterns rather than dollar amounts. Categories might include: highly engaged (frequent contact, attends events, uses the client portal), moderately engaged (responds to outreach, attends annual reviews), passively engaged (minimal contact, rarely initiates), and disengaged (does not respond to outreach, skips reviews). Behavioral segmentation identifies retention risk and helps advisors tailor their communication approach.

Segmentation review cadence. Client segments should be re-evaluated at least annually, typically after year-end billing and performance reporting. Major life events (inheritance, business sale, divorce, retirement) can trigger an immediate re-segmentation. The CRM should flag households whose AUM or revenue has crossed a tier boundary so the advisor can adjust the service level.

Household Management

The household is the fundamental unit of relationship management in wealth advisory. A household groups related individuals, their accounts, and associated entities into a single relationship view that reflects how the family thinks about its finances.

Household composition typically includes:

• Primary client (the individual who is the main point of contact and decision-maker)
• Spouse or partner
• Dependent children (relevant for 529 plans, custodial accounts, and beneficiary designations)
• Adult children who may be clients in their own right or future clients
• Trusts (revocable, irrevocable, charitable) established by the primary client or spouse
• Business entities (LLCs, S-Corps, partnerships) owned by household members
• Family foundations or donor-advised funds

Account-to-household linking. Every account in the portfolio management system and custodian must be linked to a household in the CRM. Account types within a household commonly include: individual taxable, joint taxable, traditional IRA, Roth IRA, SEP IRA, rollover IRA, inherited IRA, revocable trust, irrevocable trust, UTMA/UGMA custodial, 529 plan, entity accounts, and charitable accounts. Accurate linking is essential for household-level AUM aggregation, fee tier determination, consolidated reporting, and holistic financial planning.

Household AUM aggregation. The CRM should display total household AUM by pulling position-level data from the portfolio management system or custodian feeds. Aggregation must handle: accounts at multiple custodians, held-away assets (employer retirement plans, outside brokerage accounts, bank accounts) that are tracked but not managed, and assets under advisement (where the firm provides guidance but does not have discretion).

Multi-generational relationships. Wealth management relationships increasingly span generations. The CRM should support parent-child household linking so that when a client's adult child becomes a client, the advisor can see the full family relationship, track generational wealth transfer, and coordinate estate planning across generations. This is critical for client retention during the estimated $84 trillion intergenerational wealth transfer projected over the next two decades.

Primary and secondary advisor assignment. Each household should have a designated primary advisor (responsible for the relationship and investment decisions) and optionally a secondary advisor or client service associate. The CRM should track these assignments and use them for routing service requests, scheduling reviews, and generating workload reports. When an advisor departs the firm, the CRM's advisor assignment data drives the client reassignment process.

Household data hygiene. Common data quality issues include: orphaned accounts not linked to any household, duplicate household records for the same family, stale contact information (addresses, phone numbers, email), missing or incorrect beneficiary data in the CRM (which may differ from the custodian's records), and inconsistent naming conventions (e.g., "Robert Smith" in one record and "Bob Smith" in another). Quarterly data quality audits should identify and remediate these issues.

Service Tier Frameworks

Service tiers translate client segmentation into a concrete, actionable service delivery program. Each tier defines the minimum service standards the firm commits to providing, creating consistency across advisors and accountability for service delivery.

Service tier definition matrix:

Service Element	Platinum (A)	Gold (B)	Silver (C)
Annual reviews	4 (quarterly)	2 (semi-annual)	1 (annual)
Proactive contacts	Monthly	Bi-monthly	Quarterly
Financial plan	Comprehensive, updated annually	Modular, updated bi-annually	Goal-based, updated at review
Tax coordination	Direct CPA collaboration	Tax-aware investing	Tax-lot method guidance
Estate planning	Attorney coordination, trust review	Estate plan checklist	Beneficiary review
Event invitations	All events + exclusive dinners	All events	Educational seminars
Response time SLA	Same business day	Next business day	2 business days
Dedicated CSA	Named CSA assigned	Shared CSA pool	General service queue

SLA enforcement. Service level agreements are only meaningful if the firm tracks compliance. The CRM should monitor: days since last contact (by tier), whether the required number of reviews have been completed within the trailing 12 months, response time on service requests, and whether proactive outreach targets are being met. Advisors and practice managers should receive weekly or monthly SLA compliance reports.

Service menu per tier. Beyond the matrix above, firms should define the full menu of services available at each tier. Platinum clients might receive: proactive tax-loss harvesting, annual estate plan coordination with the client's attorney, Social Security and Medicare optimization analysis, charitable giving strategy, and invitation to an annual client appreciation event. Silver clients might receive: annual portfolio review, beneficiary verification, and access to educational webinars. The service menu should be documented and shared with all advisors and client service associates to ensure consistent delivery.

Capacity planning. Service tiers drive advisor capacity requirements. If a Platinum client requires 20 hours of advisor time per year and a Silver client requires 4 hours, an advisor's capacity determines how many clients of each tier they can serve effectively. A common capacity model: one advisor can serve 20-25 Platinum households, 40-60 Gold households, or 100-150 Silver households, with most advisors managing a blended book.

Client Review Scheduling

Systematic review scheduling ensures that every client receives the review cadence appropriate to their service tier and that reviews are prepared thoroughly, conducted effectively, and documented for compliance purposes.

Review cadence by tier:

• Platinum: quarterly reviews (every 90 days)
• Gold: semi-annual reviews (every 180 days)
• Silver: annual reviews (every 365 days)

Scheduling workflow. The CRM should automate review scheduling by tracking the date of each client's last completed review and generating scheduling tasks when the next review approaches. A 60-day advance scheduling window gives the advisor and client adequate time to find a mutually convenient date. The scheduling task should include: the client's preferred meeting format (in-person, video, phone), preferred day/time, and any special preparation notes from the prior review.

Review preparation workflow. A standardized preparation checklist ensures thoroughness and consistency:

1. Pull the current portfolio summary from the PMS (allocation, performance, drift, cash position)
2. Generate a performance report covering the period since the last review (returns vs. benchmark, attribution)
3. Review the financial plan status (funded percentage, goal progress, assumption changes needed)
4. Check for life events or profile changes recorded in the CRM since the last review
5. Review all activity since the last review (calls, emails, service requests, transactions, NBA actions taken)
6. Verify beneficiary designations are current
7. Confirm contact information and trusted contact person designation
8. Check for any compliance items due (suitability re-confirmation, disclosure delivery)
9. Prepare talking points or an agenda customized to the client's current situation
10. Pre-generate any reports or analyses the advisor plans to present

Review documentation. After each review, the advisor or CSA records in the CRM: meeting date, attendees, topics discussed, any changes to the investment strategy or financial plan, action items with responsible parties and deadlines, suitability confirmation (the client's objectives, risk tolerance, and financial situation were reviewed and remain appropriate or were updated), and the next review target date. This documentation satisfies the annual review requirement that regulators expect and provides a contemporaneous record in the event of a client dispute.

Action item tracking. Every review generates action items — rebalance the portfolio, update the estate plan, roll over an old 401(k), increase life insurance coverage. The CRM should track each action item with an owner, due date, and completion status. Open action items should appear in the advisor's task list and carry forward to the next review preparation if not yet completed.

Client Lifecycle Stages

Lifecycle stages model the client's progression through distinct financial phases, each with different needs, priorities, and service requirements. Tracking lifecycle stage in the CRM allows the firm to tailor advice, communication, and product recommendations to the client's current situation.

Prospect. An individual or household that has expressed interest or been identified as a potential client but has not yet signed an advisory agreement. CRM tracks: referral source, initial meeting date, proposal status, follow-up cadence, and conversion probability. Key metrics: prospect-to-client conversion rate, average time from first contact to signed agreement, and pipeline value (estimated AUM of active prospects).

Onboarding. The period from signed agreement through funded, invested account. The CRM tracks onboarding milestones: agreement signed, KYC/CIP completed, accounts opened, accounts funded, initial investment executed, first review scheduled. The onboarding stage typically lasts 2-6 weeks for simple accounts and up to 3 months for complex situations (trusts, entities, large ACAT transfers). See the client-onboarding skill for detailed onboarding workflows.

Accumulation. The client is actively building wealth — working, saving, contributing to retirement accounts, and growing the portfolio. Advisory focus: investment growth, tax-efficient accumulation, risk management (insurance review), debt optimization, and retirement projection. This stage may last 20-30 years for clients who engage an advisor in their 30s or 40s. CRM tracks: contribution patterns, savings rate, career milestones, and financial plan progress.

Distribution. The client has transitioned to drawing income from the portfolio — typically at or near retirement. Advisory focus shifts to: income sustainability, withdrawal strategy, Social Security optimization, Medicare enrollment, required minimum distributions, tax bracket management in retirement, and portfolio de-risking. CRM tracks: withdrawal rate, RMD compliance, income sources, and spending patterns.

Estate/Succession. The client's planning focus shifts to wealth transfer, legacy, and end-of-life financial management. Advisory focus: estate plan review, beneficiary updates, gifting strategies, charitable giving, trust funding and administration, and coordination with estate attorneys and CPAs. The CRM should track: estate plan last reviewed, trust structures, gifting history, and identified successor contacts (adult children, executors, trustees).

Dormant/At-Risk. A client who shows disengagement signals: declining assets (systematic withdrawals not explained by planned distributions), unresponsive to outreach (missed reviews, unanswered calls/emails), reduced engagement (stopped logging into the client portal, skipped events), or expressed dissatisfaction. The CRM should flag dormant or at-risk clients based on configurable rules so the advisor can intervene before the client leaves. Re-engagement strategies include: a personal call from the primary advisor, an invitation to a special event, a complimentary plan review, or an offer to review the fee structure.

CRM Data Model and Integration

The CRM is the system of record for client relationship data and the integration hub that connects to the portfolio management system, custodian, financial planning tool, document management system, and marketing automation platform.

Core CRM entities:

• Contact record: Name, demographics, contact information, employment, tax status, risk profile, communication preferences, trusted contact person. One record per individual.
• Household record: Groups related contacts. Stores household-level data: total AUM, segment/tier, primary advisor, service model, lifecycle stage.
• Account record: Links to the custodian account. Stores: account number, account type, registration, custodian, model assignment, billing status. Each account belongs to one household.
• Activity record: Every interaction with the client — calls, emails, meetings, service requests, document deliveries, review completions. Activities are linked to a contact and/or household and tagged by type and date.
• Opportunity record: Tracks potential new business — prospects, additional account opportunities, financial planning engagements, insurance referrals. Stores: estimated value, probability, stage, and expected close date.
• Task record: Action items assigned to team members with due dates, priority, and completion status.

Integration with portfolio management system (PMS). The CRM should synchronize with the PMS to display: current household AUM, account-level balances, asset allocation, recent transactions, performance summary, and model assignment. Data flows primarily from PMS to CRM (positions, performance, transactions), with some flows from CRM to PMS (household structure, advisor assignment, billing preferences). Synchronization frequency should be at least daily; real-time feeds are preferred for large firms.

Integration with custodian. Custodial data feeds provide: account positions, transactions, cash balances, pending transfers, and account status. Most CRMs consume this data indirectly through the PMS rather than through direct custodian integration, though some CRM platforms (particularly Salesforce with wealth management connectors) support direct custodial feeds.

Integration with financial planning tools. Planning tools (eMoney, MoneyGuidePro, RightCapital) hold: financial goals, plan assumptions, Monte Carlo results, cash flow projections, and Social Security analysis. Integration allows the CRM to display plan status on the client record and trigger alerts when plan assumptions need updating. Data typically flows from the planning tool to the CRM via API or file export.

Data synchronization patterns. The most reliable pattern is a single source of truth per data element: the CRM owns contact information and relationship data; the PMS owns investment data and performance; the custodian owns official account records and transactions; the planning tool owns financial plan data. Bidirectional synchronization of the same data element across systems creates reconciliation conflicts and should be avoided.

Client Engagement Analytics

Engagement analytics transform raw CRM activity data into actionable insights about relationship health, retention risk, and growth opportunities.

Contact frequency tracking. The CRM should measure the number and type of contacts (calls, emails, meetings, portal logins) per household per period and compare against the service tier's SLA targets. A contact frequency dashboard shows: households meeting their contact standard (green), approaching the threshold (amber), and in breach (red). This dashboard is a primary practice management tool for ensuring consistent service delivery.

Net Promoter Score (NPS) and satisfaction measurement. NPS surveys ask clients: "On a scale of 0-10, how likely are you to recommend our firm to a friend or colleague?" Scores of 9-10 are promoters, 7-8 are passives, 0-6 are detractors. NPS = % promoters minus % detractors. Industry benchmarks for wealth management NPS range from 40 to 70. NPS should be measured annually via a brief survey distributed after annual reviews or at a consistent point in the calendar year. The CRM should store survey results at the household level and track trends over time.

Retention risk scoring. A composite score that identifies households at elevated risk of leaving the firm. Risk indicators include:

• Declining AUM not attributable to market performance (net outflows)
• Missed or declined review meetings
• Decreased contact frequency (fewer calls, emails, or portal logins)
• Unresolved service complaints
• Recent advisor change (involuntary reassignment)
• Underperformance vs. benchmark for more than two consecutive periods
• Life transition (divorce, death of spouse, job loss) without corresponding advisor outreach
• Fee sensitivity signals (questions about fees, comparison shopping mentions)

The CRM should calculate a retention risk score for each household on a weekly or monthly basis and surface high-risk households to the advisor's dashboard for proactive intervention.

Wallet share analysis. Wallet share measures the percentage of a client's total investable assets that the firm manages. If a household has $5 million in total investable assets but only $2 million with the firm, the wallet share is 40%. Held-away asset data comes from financial planning tools, client self-reporting, and aggregation services. Low wallet share combined with a strong relationship indicates a consolidation opportunity. The CRM should track estimated total assets, managed assets, and wallet share percentage at the household level.

Referral tracking. The CRM should record: who referred each new client, the date of the referral, the outcome (converted or not), and the AUM of the resulting relationship. Referral tracking enables: identification of top referral sources for recognition and nurturing, measurement of the referral-driven share of new business, and referral attribution back to the originating client for any referral incentive programs (subject to SEC Marketing Rule compliance, Rule 206(4)-1, which permits testimonials and endorsements with required disclosures).

Worked Examples

Example 1: Designing a tiered service model for a growing RIA

Scenario: A registered investment adviser with 8 advisors managing $1.6 billion across 900 households has grown rapidly through acquisitions and organic growth. The firm has no formal service tier structure — each advisor determines their own review cadence, contact frequency, and service level. The result is inconsistent client experience: some $500K clients receive quarterly reviews while some $3M clients have not been contacted in 9 months. The firm wants to implement a standardized three-tier service model.

Design Considerations:

• Segmentation must account for the firm's diverse client base, which ranges from $100K to $20M households. A purely AUM-based model would create very uneven tier sizes given the skewed distribution.
• The firm has 3 client service associates (CSAs) shared across all 8 advisors, constraining the service capacity for lower-tier clients.
• Two recently acquired books have clients accustomed to different service levels from their prior advisory relationship, requiring a transition plan.
• The firm's compliance manual requires annual reviews for all clients, but there is no systematic tracking or enforcement mechanism.

Analysis: Start with a segmentation analysis: rank all 900 households by AUM and revenue to identify natural breakpoints. A common pattern in advisory firms follows the Pareto principle — approximately 20% of households generate 80% of revenue. Suppose the analysis reveals: 90 households above $3M (10% of households, 55% of AUM), 270 households between $750K and $3M (30% of households, 35% of AUM), and 540 households below $750K (60% of households, 10% of AUM).

Define three tiers with corresponding service standards:

Tier A (Platinum, 90 households): Quarterly in-depth reviews with comprehensive preparation package. Monthly proactive contact (call, email, or meeting). Comprehensive financial plan updated annually. Direct CPA and attorney coordination. Named CSA assigned. Same-business-day response SLA. Invitation to all firm events plus exclusive appreciation dinners. Estimated advisor time: 20 hours per household per year.

Tier B (Gold, 270 households): Semi-annual reviews with standard preparation package. Bi-monthly proactive contact. Modular financial plan updated at each review. Tax-aware investment management. Shared CSA pool. Next-business-day response SLA. Invitation to all firm events. Estimated advisor time: 10 hours per household per year.

Tier C (Silver, 540 households): Annual review with streamlined preparation package. Quarterly proactive contact (minimum). Goal-based planning conversation at annual review. Beneficiary and contact information verification at review. General service queue. Two-business-day response SLA. Invitation to educational seminars. Estimated advisor time: 4 hours per household per year.

Capacity check: each advisor averages approximately 112 households. With a blended book of roughly 11 Platinum (220 hours), 34 Gold (340 hours), and 67 Silver (268 hours) households, total advisor time is approximately 828 hours per year, or roughly 16 hours per week on client-facing activities. This is feasible given that advisors typically allocate 50-60% of their time to client-facing work.

Implementation: configure the CRM with tier assignments for all 900 households. Build automated review scheduling that triggers based on the last review date and the tier's review cadence. Create a service delivery dashboard showing each advisor's compliance with tier SLAs. For the acquired books, communicate the new service model to each client during their next review, emphasizing the enhanced structure and consistency. Clients who were receiving more frequent service than their tier warrants should be grandfathered for 12 months with a gradual transition to the standard cadence.

Example 2: Building a client review preparation workflow

Scenario: A 4-advisor RIA managing $800M across 400 households conducts annual reviews for all clients and quarterly reviews for its top 50 households. Review preparation is currently ad hoc — each advisor prepares differently, some spend 2 hours preparing and others spend 15 minutes, and the quality of the review experience varies widely. The firm wants to implement a standardized, CRM-driven review preparation workflow that ensures consistent quality while reducing preparation time.

Design Considerations:

• The firm uses Salesforce as its CRM, Orion as its PMS, and eMoney as its financial planning tool. All three systems have API capabilities.
• Review preparation should be automated where possible — pulling data from systems rather than requiring manual assembly.
• The workflow must accommodate different preparation depth for quarterly reviews (Tier A) versus annual reviews (Tier B and C).
• Compliance requires that every review include suitability confirmation and beneficiary verification.

Analysis: Design a three-phase workflow triggered by the CRM when a review meeting is scheduled:

Phase 1 — Automated data assembly (triggered immediately when the review is scheduled, no advisor time required). The CRM initiates API calls to pull: (a) from Orion — current portfolio summary, performance since last review, benchmark comparison, asset allocation vs. target, drift analysis, realized gains/losses, and cash position; (b) from eMoney — current plan status, Monte Carlo probability, goal progress, and any alerts on assumptions that need updating; (c) from CRM — all activities since last review (calls, emails, meetings, service requests), any life events recorded, open action items from the prior review, and current contact and beneficiary information. These data elements are assembled into a standardized review preparation document stored in the CRM.

Phase 2 — Advisor review and customization (15-30 minutes of advisor time, 2-3 days before the meeting). The advisor opens the pre-assembled preparation document and adds: personalized talking points based on the client's specific situation, any topics the client has requested to discuss, strategic recommendations (rebalancing, tax-loss harvesting, Roth conversion, insurance review), and questions to ask about changes in the client's life, employment, or financial situation. For Tier A quarterly reviews, this phase also includes: a market commentary tailored to the client's portfolio positioning, performance attribution discussion points, and any proactive planning opportunities identified.

Phase 3 — Post-review documentation (10-15 minutes of advisor or CSA time, same day as the meeting). The CRM presents a structured review completion form with fields for: meeting date and attendees, topics discussed (checkbox list plus free text), changes to investment strategy or plan, suitability confirmation checkbox (confirming objectives, risk tolerance, and financial situation were reviewed), beneficiary verification checkbox, action items generated (with owner and due date for each), and next review target date. Completing this form closes the review task in the CRM, starts the clock for the next review scheduling trigger, and logs the compliance-required documentation.

Estimated impact: preparation time drops from an average of 75 minutes (with wide variance) to a consistent 20-30 minutes because 60-70% of the work is automated. Review quality improves because every review covers the same comprehensive checklist. Compliance documentation is captured systematically rather than retroactively.

Example 3: Identifying at-risk clients using CRM analytics

Scenario: A wealth management firm with $2.4 billion AUM across 1,100 households lost 45 households ($180M AUM) to attrition last year — a 4.1% attrition rate by count and 7.5% by AUM, significantly above the industry average of 3-5% by AUM. The firm believes most departures were preventable and wants to build a CRM-based retention risk scoring model to identify at-risk clients before they leave.

Design Considerations:

• The firm has 3 years of CRM activity data, custodial transaction data, and a record of which households departed and when.
• Departed client analysis shows common patterns: 60% had declining contact frequency in the 6 months before leaving, 45% had net outflows in the 12 months before departure, 35% had missed their most recent scheduled review, and 25% had an unresolved service complaint.
• The firm needs a scoring model that is transparent enough for advisors to understand and act upon — a black-box score without explanation will not drive behavior change.

Analysis: Build a retention risk score using weighted indicators derived from the departure analysis. Each indicator is scored on a 0-10 scale, with weights reflecting the indicator's predictive strength based on the firm's historical data:

Contact frequency decline (weight: 25%). Compare the client's contact frequency in the trailing 6 months to the prior 6-month period. A decline of more than 40% scores 8-10. A decline of 20-40% scores 5-7. Stable or increasing contact scores 0-2.

Net asset flows (weight: 20%). Measure net flows (contributions minus withdrawals) over the trailing 12 months, excluding market-driven changes. Net outflows exceeding 10% of AUM score 8-10. Net outflows of 5-10% score 5-7. Positive net flows score 0.

Review compliance (weight: 15%). Has the client completed their most recent scheduled review? Missed the last review scores 8. Rescheduled once scores 4. Completed on time scores 0.

Service complaints (weight: 15%). Any unresolved complaint in the trailing 12 months scores 8-10 depending on severity. A resolved complaint scores 3-5. No complaints scores 0.

Performance relative to expectations (weight: 10%). If the client's portfolio has underperformed its benchmark by more than 300 basis points over the trailing 12 months, score 7-10. Underperformance of 100-300 basis points scores 3-6. At or above benchmark scores 0.

Advisor relationship change (weight: 10%). If the client's primary advisor changed in the last 12 months (due to advisor departure, reassignment, or team restructuring), score 7. If the change was in the last 6 months, score 9. No change scores 0.

Life transition without outreach (weight: 5%). If a major life event (retirement, death of spouse, divorce) occurred and the advisor did not initiate contact within 14 days, score 8-10. Timely outreach after a life event scores 0.

Composite risk score = sum of (indicator score multiplied by weight) across all indicators, producing a 0-100 scale. Households scoring above 60 are flagged as high risk (red), 40-60 as elevated risk (amber), and below 40 as low risk (green).

Implementation in the CRM: configure a scheduled automation that recalculates risk scores weekly. High-risk households appear on the advisor's dashboard with the specific risk factors driving the score (not just the number). The advisor sees: "Harrison household — Risk Score 72. Drivers: contact frequency down 55% (scored 9), net outflows of $120K / 8% of AUM (scored 7), missed Q3 review (scored 8)." This transparency allows the advisor to design a targeted intervention — in this case, a personal call to Mr. Harrison to schedule the overdue review, discuss the outflows, and understand whether there is an underlying concern.

Track the model's effectiveness by monitoring: the percentage of high-risk households that received intervention within 14 days of flagging, the retention rate for high-risk households that received intervention vs. those that did not, and the overall attrition rate over the following 12 months. Refine the indicator weights annually based on updated departure analysis.

Common Pitfalls

• Segmenting clients by AUM alone without considering revenue, growth potential, referral activity, or relationship depth — leading to misallocation of advisor time toward large but low-revenue or disengaged clients
• Failing to define household structures in the CRM, causing fragmented views of the same family across multiple unlinked records and inaccurate AUM aggregation
• Creating service tier standards that are aspirational rather than achievable — if the firm defines quarterly reviews for Tier A but advisors cannot realistically complete them, the tiers lose credibility and go unenforced
• Not tracking service tier SLA compliance in the CRM, allowing commitments to clients to go unmonitored and unfulfilled
• Treating the CRM as an address book rather than a relationship management platform — storing contact information but not logging activities, tracking opportunities, or measuring engagement
• Allowing activity logging to be optional rather than required, resulting in incomplete CRM data that undermines engagement analytics and retention risk scoring
• Defining lifecycle stages without building corresponding workflows — labeling a client as "distribution phase" has no value unless the firm adjusts its advice, communication, and service model accordingly
• Integrating CRM with other systems using bidirectional synchronization of the same data field, creating reconciliation conflicts — each data element should have a single authoritative source system
• Building retention risk models without historical departure data to validate the indicators, producing scores that do not actually predict attrition
• Neglecting multi-generational household linking, missing the opportunity to retain assets during wealth transfer events — when a client passes away and the firm has no relationship with the beneficiaries, the assets leave
• Ignoring held-away asset data and wallet share analysis, forfeiting consolidation opportunities that represent the lowest-cost source of AUM growth
• Implementing a CRM without advisor input on workflows and data entry requirements, producing a system that advisors view as administrative burden rather than a productivity tool

Cross-References

• client-onboarding (Layer 10, advisory-practice): Onboarding creates the initial CRM client record, household structure, and advisor assignment that the CRM manages throughout the relationship lifecycle
• know-your-customer (Layer 9, compliance): KYC data collected during onboarding and periodic reviews populates CRM profile fields; CRM tracks when KYC information was last verified and flags re-verification requirements
• fee-billing (Layer 10, advisory-practice): Fee tier determination depends on household AUM aggregation managed in the CRM; revenue data from the billing system feeds into CRM segmentation and revenue-per-client analytics
• client-reporting-delivery (Layer 10, advisory-practice): Client reports are generated using account and household data structured in the CRM; report delivery preferences and confirmation are tracked as CRM activities
• next-best-action (Layer 10, advisory-practice): CRM activity records, segmentation data, and lifecycle stage are primary inputs for next-best-action triggers; every NBA action updates the CRM activity log
• investment-suitability (Layer 9, compliance): Suitability profiles stored in the CRM must be reviewed and re-confirmed at each client review; CRM tracks when the last suitability confirmation occurred and flags overdue re-certifications
• privacy-data-security (Layer 9, compliance): The CRM stores sensitive nonpublic personal information protected by Regulation S-P and firm cybersecurity policies; access controls, audit logging, and data retention policies apply to all CRM records
• client-review-prep (Layer 10, advisory-practice): CRM provides client segmentation, review scheduling, and activity history used in pre-meeting review preparation