Design, build, and optimize dashboards for RIA practice management with AUM tracking, revenue analytics, and KPI frameworks. Use when the user asks about tracking firm-level metrics, monitoring advisor productivity, measuring organic growth rate, analyzing client retention and attrition, building ex

Advisor Dashboards Core Concepts 1. Practice Level KPIs Key performance indicators for advisory practices fall into several categories, each measuring a different dimension of firm health. A well designed KPI framework provides both a snapshot of current performance and the trend data needed to identify emerging risks or opportunities. AUM (Assets Under Management). The foundational metric for any AUM based advisory practice. Total firm AUM is the product of client count, average relationship size, and market performance. AUM should be tracked at multiple levels: firm total, by advisor or team, by client segment (high net worth, mass affluent, institutional), by account type (taxable, IRA, trust, plan), and by custodian. AUM changes decompose into two components — market appreciation/depreciation and net new assets — and tracking each separately reveals whether growth is organic (advisor driven) or market driven. Revenue. Total advisory revenue, broken down by fee type (AUM based fees, financial planning fees, hourly fees, performance fees, other), by advisor or team, by client segment, and by billing period. The effective fee rate (total revenue divided by average AUM) is a critical derived metric that reveals fee compression trends over time. Revenue should be tracked on both an accrual basis (for GAAP reporting) and a cash basis (for cash flow management). Client Count. The number of active client households, tracked by segment, advisor, and tenure. Distinguish between households (the billing and relationship unit) and accounts (the custodial unit). A firm with 500 households might have 2,000 accounts. Client count trends — net new households per quarter, attrition rate, and average household tenure — reveal the health of the firm's client acquisition and retention efforts. Revenue Per Client. Average annual revenue per household, segmented by client tier. This metric exposes whether the firm is growing revenue through larger relationships or by adding many small ones. Declining revenue per client may indicate fee compression, client downsizing, or an acquisition strategy that targets smaller relationships than the firm's economics require. Average Account Size. Total AUM divided by the number of accounts (or households). Tracked over time, this metric reveals whether the firm is attracting larger or smaller relationships. When combined with revenue per client, it exposes effective fee rate trends at the client level. Organic Growth Rate. Net new assets (new client assets plus existing client contributions minus withdrawals minus terminated client assets) divided by beginning of period AUM, expressed as an annualized percentage. Organic growth strips out market appreciation to isolate the advisor driven component of AUM change. Industry benchmarks for healthy RIAs typically target 5 10% annual organic growth. Negative organic growth — even during strong markets — signals that the firm is losing ground despite favorable conditions. Retention Rate. The percentage of beginning of period AUM or client count that remains at the end of the period, excluding market effects. A 95% client retention rate means 5% of clients (by count or AUM) left during the period. Retention is often more valuable than acquisition: replacing a departed $2M client requires acquiring two new $1M clients, each carrying acquisition cost and onboarding effort. Referral Rate. New clients acquired through existing client referrals as a percentage of total new clients. Referral sourced clients tend to have higher AUM, lower acquisition cost, and higher retention. Tracking referral rate by advisor identifies which advisors have the strongest referral networks and which may benefit from referral training or process improvement. Profitability Metrics. For firms that track practice level financials, operating margin (revenue minus direct and allocated expenses, divided by revenue) is the ultimate measure of practice efficiency. Industry benchmarks for well run RIAs typically show operating margins of 25 35%. Revenue per employee (total revenue divided by total headcount) provides a simpler proxy for overall productivity. Compensation to revenue ratio (total compensation including advisor payouts divided by total revenue) should typically fall between 55 70% for sustainable practices. 2. AUM and Revenue Dashboards AUM and revenue dashboards provide the financial pulse of the advisory practice. They answer the questions firm leadership asks most frequently: how much do we manage, how much are we earning, where is the growth coming from, and what does the trajectory look like? AUM by Advisor/Team/Segment. A hierarchical view that drills from firm total AUM down to team, advisor, and individual household. Heatmaps or bar charts comparing advisors by AUM highlight concentration risk (if one advisor manages a disproportionate share) and identify capacity constraints (advisors approaching their effective management limit). Segment views (by client tier, account type, or investment model) reveal the composition of the firm's book and inform strategic decisions about target markets. Revenue by Fee Type. A breakdown showing what percentage of total revenue comes from AUM based fees versus planning fees, hourly fees, or other sources. Firms diversifying beyond pure AUM based revenue should track the mix over time. A rising share of planning fee revenue indicates successful adoption of comprehensive planning services. Billing exception rates by fee type highlight operational trouble spots. Pipeline and Flows Tracking. The flow of assets into and out of the firm, tracked on a rolling basis. Key flow metrics include: Gross inflows — New client assets plus existing client contributions. Decompose into new relationship inflows (first deposit from a new household) and existing relationship inflows (additional assets from current clients, including rollovers, consolidations, and savings contributions). Gross outflows — Client withdrawals plus terminated client assets. Decompose into distribution outflows (planned withdrawals for income, RMDs, or specific needs) and attrition outflows (clients leaving the firm entirely or moving assets to competitors). Net flows — Gross inflows minus gross outflows. Positive net flows indicate the firm is gathering more than it is losing. Net flows should be tracked monthly and displayed as a rolling 12 month trend. Pipeline — Prospective clients and anticipated asset transfers that have not yet funded. Pipeline tracking requires CRM integration and should display the prospect's name, estimated AUM, probability of close, expected funding date, and assigned advisor. AUM Growth Decomposition. A waterfall chart or stacked bar showing the components of AUM change over a period: Beginning AUM Plus: market appreciation (or minus: market depreciation) Plus: net new assets (inflows minus outflows) Equals: ending AUM This decomposition is essential for management because it separates controllable growth (net new assets) from uncontrollable growth (market returns). A firm whose AUM grew 12% in a year where markets returned 10% actually achieved only 2% organic growth — a far less impressive result than the headline number suggests. 3. Client Flow Analytics Client flow analytics go beyond aggregate flow numbers to analyze the dynamics of client acquisition, retention, and asset consolidation at a granular level. New Client Acquisition Funnel. Track the conversion pipeline from initial lead through prospect meeting, proposal delivery, agreement signing, and account funding. Key funnel metrics include: lead to meeting conversion rate, meeting to proposal rate, proposal to close rate, close to fund rate, average time from lead to funded account, and average funded amount versus initial estimate. Funnel analytics by advisor expose differences in prospecting effectiveness and identify bottlenecks (an advisor with a high meeting to proposal rate but low proposal to close rate may need help with proposal quality or pricing). Client Attrition Tracking. Monitor departing clients by reason (voluntary termination, death, relocation, fee sensitivity, service dissatisfaction, competitor solicitation), by advisor, by client segment, and by tenure. Attrition dashboards should display both the count and the AUM impact of departures. Early tenure attrition (clients leaving within the first two years) suggests onboarding or expectation setting issues. Long tenure attrition (clients of 10+ years departing) may signal relationship fatigue or a generational transition where heirs move assets. Money in Motion Indicators. Proactive signals that a client may be consolidating assets (opportunity) or preparing to leave (risk). Key indicators include: large cash deposits from external sources (potential rollover or inheritance), systematic outflows exceeding income needs (possible transfer to a competitor), reduced engagement (fewer meetings, unanswered communications), and changes to beneficiary designations or account titling. The dashboard should flag these indicators for advisor follow up before the client makes a final decision. Asset Consolidation Tracking. For existing clients with held away assets, track consolidation opportunities — the gap between total household assets (visible through aggregation) and managed assets. A client with $3M managed and $2M held away in a former employer 401(k) represents a $2M consolidation opportunity. Consolidation dashboards rank opportunities by dollar value and likelihood, enabling advisors to prioritize outreach. Competitive Losses. When clients depart, capture the destination (self directed, competitor RIA, wirehouse, robo advisor, bank) and the stated reason. Over time, this data reveals competitive threats and informs the firm's value proposition and pricing strategy. A cluster of departures to a lower cost competitor signals fee pressure; departures to a full service wirehouse may indicate that clients want services the firm does not offer. Generational Transfer Tracking. A growing concern for advisory firms is the risk that heirs of deceased clients move inherited assets elsewhere. Track accounts where the primary account holder is over age 75, the estimated intergenerational transfer value, whether the firm has an established relationship with the next generation, and the outcome of recent inheritance events (assets retained vs. assets departed). Firms that proactively engage the next generation retain significantly more inherited assets than those that wait until the triggering event occurs. 4. Exception and Alert Dashboards Exception dashboards surface items that require immediate attention — anomalies, breaches, overdue tasks, and operational failures that deviate from expected norms. These dashboards are typically used by operations managers, compliance officers, and practice managers rather than individual advisors. Compliance Alerts. Items requiring compliance attention: overdue annual reviews, stale client profiles, unsigned disclosures, advertising items awaiting review, trade pre clearance violations, outside business activity disclosures due, gift and entertainment reporting gaps, and code of ethics certification deadlines. Each alert should display the responsible party, the deadline, days until (or past) the deadline, and the escalation status. Color coding (green/yellow/red) provides an at a glance severity assessment. Operational Exceptions. Reconciliation breaks between the PMS and custodian, failed data feeds, NIGO (not in good order) account opening documents, incomplete account transfers (ACAT failures), unsigned paperwork, and pending account maintenance requests. The dashboard should display exception age (how long the item has been open) and flag items that have exceeded their service level agreement. Rebalancing Drift Alerts. Accounts where p

advisor-dashboards