Build an Insurance Agency KPI Dashboard From Your CRM Data
Forget P&C-style loss-ratio dashboards. Here's how a Medicare, ACA, or life agency builds a real operations dashboard from data it already has: production by agent, retention, commissions, and call activity.
The dashboard you need already exists inside your CRM data You don't need a separate business-intelligence tool to see how your Medicare, ACA, or life agency is actually performing. If policies, clients, calls, and commissions already live in one CRM, an agency operations dashboard is a matter of pulling four data sets you already have — production, retention, commissions, and call activity — into one screen you check on a schedule, not four spreadsheets you rebuild every month. Most "insurance KPI dashboard" guides are written for carriers and P&C shops: loss ratio, combined ratio, claims cycle time. None of that applies to a health, Medicare, or life agency. What you actually need to track is simpler and more actionable: who is writing business, who is at risk of leaving, what you're actually being paid, and whether your phones are being worked. This guide walks through building that dashboard from data your agency is already generating, without adding a new subscription. Start by separating the two halves of your book An agency's data naturally splits into two things that update on different schedules and, in most agencies, are owned by different people: The policy book — every policy, its carrier, its coverage type, its effective and inactive dates, and who the Contact Owner is. This changes every time a policy is written, renewed, or lapses. The commission book — what carriers actually paid, reconciled against statements. This updates on whatever cadence your commission sync runs, and it answers a different question than the policy book: not "what did we sell" but "what did we get paid for it." Trying to answer both questions from one spreadsheet is where most agency reporting breaks down — the policy count and the commission total almost never agree, because chargebacks, unpaid first months, and timing lag mean they're not measuring the same thing. AgencyView's CFO Center keeps the commission half separate from the policy half for exactly this reason, and the Commissions tab is where an individual agent checks what's actually been paid versus what's still pending. The four data sets worth putting on one screen 1. Production, by agent The most basic agency-health number is also the one most agencies can't answer without opening the CRM and counting manually: how many policies did each agent write in the trailing 12 months, how much premium does that represent, and how many distinct clients does it touch. In AgencyView this lives on the Analytics page's Production by Agent table, attributed by Contact Owner — the only per-agent field the policy record actually carries. Any agent working inside your agency's own CRM location — a captive downline agent, an LOA agent, or a CSR — shows up as its own row, so you don't have to ask anyone what they wrote this month. 2. Retention A trailing-12-month retention figure tells you whether the book you already have is holding, separate from whether you're writing new business. A dashboard that only shows new premium and never shows retention will make a leaking book look healthy right up until it isn't. 3. Commissions, by carrier or by agent Net versus gross, chargebacks, and how many statement rows a given carrier or agent generated in the window — broken down by whichever dimension answers the question you're actually asking that week. Some weeks that's "which carrier is slow to pay," other weeks it's "which agent's book is generating the most net commission." The CFO Center's breakdown supports both views from the same underlying data, so you're not rebuilding a report to change the angle. 4. Call activity If your phone system is connected, call volume by day and average talk time per agent answer a question production numbers can't: whether an agent's slow month is a lead problem or an activity problem. As covered in Dials Don't Pay, Talk Time Pays , dial count alone tells you almost nothing about whether an agent is actually having conversations — talk time does. If you run a captive downline, production reporting is the whole point An agency owner running captive agents, LOA agents, or CSRs inside their own CRM location has a narrower version of this same problem: you can see the agency's total production clearly, but any one agent's contribution to it is invisible unless you go looking for it. Production by Agent solves this because it doesn't depend on the agent self-reporting anything — it's attributed automatically from the Contact Owner on every policy record. That means an agency owner or a sub-agency admin sees each agent's policy count, premium, client count, and trailing-12-month production in the same table, without asking anyone to fill out a spreadsheet. For an FMO or IMO running a captive downline , this is the report that answers whether a new agent is actually writing business, agent by agent, instead of just occupying a seat. A newly added agent who hasn't written anything in their first 30 days is a coaching conversation you want to have in week three, not something you discover at the next commission cycle. Pulling this table weekly, not just at renewal season, is what turns it from a report into an early-warning system. How to build it in AgencyView, step by step Open Analytics from the sidebar (agency admins, sub-agency admins, and independent agents can access it). The Executive Dashboard tab loads first: in-force monthly premium versus a month ago, distinct clients with an in-force policy, total policies, and 12-month retention, plus a New Business by Month trend and a Line of Business breakdown. Check Production by Agent on the same tab for the per-agent view described above — this is the table to screenshot into a Monday production meeting. Switch to Commissions by Agent for the money side: net, gross, chargebacks, and clients, by carrier, line of business, agent, or plan — pick the dimension that answers this week's question. Open the Calls tab (if RingCentral is connected) for call volume, average duration, and per-agent call counts pulled directly from the phone system's own analytics, not from whatever your team happened to log. Use the Custom Report Builder when none of the above is the exact cut you need. It works against three modules — policies, commissions, clients — each with its own column set and filter rules, and it exports straight to CSV. A note on what you can safely export Before you build a "weekly dashboard export" habit, know which columns carry protected health information. A policy or client export that includes a client's name alongside a carrier, plan, or date of birth is a disclosure of health information about an identified person — it doesn't stop being PHI because it's "just a spreadsheet." AgencyView's report builder flags name, email, phone, and date-of-birth columns for this reason, and restricted seats may be blocked from exporting them at all. The commission dataset, by contrast, is aggregate and names no client, so it doesn't carry the same restriction. If you're building a recurring export for a downline or an outside accountant, build it from the commission module or strip client-identifying columns before you send it anywhere. Five numbers worth checking on a set schedule Question Where to look How often Is new premium up or down month over month? Executive Dashboard — New Business by Month Weekly Is the book I already have retained or leaking? Executive Dashboard — 12-month retention Monthly Who's actually writing business this quarter? Production by Agent Weekly What did we actually get paid, net of chargebacks? Commissions by Agent / CFO Center Monthly, at statement close Are agents on the phone, or just logged in? Calls — talk time by agent Weekly FAQ Do I need a separate BI tool like Power BI or Looker to build an agency dashboard? Not if your CRM already holds your policies, clients, calls, and commission data in one…
Where AgencyView fits
Keep reading
Share: Facebook · LinkedIn · X · Email
All articles · AgencyView