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

1. 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.
2. 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.
3. 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.
4. 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.
5. 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

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 place. Those tools are built for combining data across many disconnected systems; if you only have one system of record, the dashboard already sitting inside it will answer most of the questions a small or mid-size agency actually asks week to week.

Why don't insurance KPI guides written for carriers apply to my agency?

Loss ratio, combined ratio, and claims cycle time are underwriting and claims metrics that live on the carrier side, not the agency side. A Medicare, ACA, or life agency doesn't adjudicate claims — the numbers that matter are production, retention, commissions actually paid, and whether the team is working the leads it has.

How do I see production for agents inside my agency, not just my own book?

Production by Agent attributes every policy to its Contact Owner, so an agency owner or sub-agency admin sees each captive agent's, LOA agent's, or CSR's policies, premium, clients, and trailing-12-month production in the same table — useful for spotting an agent who isn't writing before it shows up at renewal time.

Can I export a client list with names on it for an outside accountant?

Only if you're allowed to disclose that data, and you should treat it as a disclosure, not a routine export. Prefer the commission module, which is aggregate and doesn't carry client-identifying columns, unless the recipient genuinely needs PHI and has a business reason to receive it.

What if I don't have RingCentral connected?

The Calls tab simply won't populate, but the Executive Dashboard, Production by Agent, and Commissions by Agent views don't depend on it — they work from your CRM and commission data alone.

An agency operations dashboard isn't a project. It's four numbers you already have, looked at on a schedule instead of guessed at. AgencyView puts the policy book, the commission book, call activity, and a custom report builder on one Analytics page, so building the dashboard is a matter of opening it rather than assembling one from scratch.

Cover photo: Vitaly Gariev / Pexels

Where AgencyView fits

• Insurance commission tracking
• Downline management for FMOs and IMOs

Keep reading

• A CRM Checklist for Recruiting Your Next Insurance Agent
• Downline Production Reporting: A Practical Guide
• Onboarding a New Downline Agent: A Step-by-Step Guide

Share: Facebook · LinkedIn · X · Email

All articles · AgencyView