From advisory-practice
Designs and optimizes CRM systems and client lifecycle workflows for advisory firms, covering segmentation, household management, service tiers, and retention analytics.
npx claudepluginhub joellewis/finance_skills --plugin advisory-practiceThis skill uses the workspace's default tool permissions.
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 da...
Creates isolated Git worktrees for feature branches with prioritized directory selection, gitignore safety checks, auto project setup for Node/Python/Rust/Go, and baseline verification.
Executes implementation plans in current session by dispatching fresh subagents per independent task, with two-stage reviews: spec compliance then code quality.
Dispatches parallel agents to independently tackle 2+ tasks like separate test failures or subsystems without shared state or dependencies.
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.
10 — Advisory Practice (Front Office)
both
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:
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.
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:
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 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.
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:
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:
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.
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.
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:
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.
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:
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).
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:
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.
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:
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.
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:
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.