Skip to main content

Agency Quick Reports

The Quick Reports panel on the agency Reports page has ready-made reports for the questions agencies ask most. Click one and it runs right away.

The Production Report has its own article. The rest are below.

→ See The Agency Production Report


Close Ratio by Agent

Shows how many agency leads each agent closed.

  • Leads — agency leads assigned to the agent.

  • Sold — leads marked Sold.

  • Closed (lost) — leads closed another way, such as Not interested or Bad number.

  • Open — leads still being worked.

  • Close ratio — Sold divided by Sold plus Closed (lost).

Set Disposition from and to and click Apply to look at one period. Leave them blank for all time.

Good to know: Only leads the agency handed out are counted. An agent's own leads aren't included.


Lead Status

Shows how many agency leads each agent has at each status, such as New, Contacted, Appointment Set and Sold, with a total. It uses the same date range as Close Ratio.


Appointments Assigned

Shows appointments booked through your agency's Calendly connection.

  • Appointments — bookings assigned to the agent.

  • New profiles — bookings that created a new client profile.

  • Existing profiles — bookings for someone already in the CRM.

  • Canceled — bookings that were canceled.

Set Booked from and to and click Apply to choose the period. Agents with no appointments aren't listed.


Agent Activity

Shows when each agent last signed in, so you can spot who has stopped using AdvantaCRM.

Activity

Last signed in

Active

Within the last 10 days

Idle

11 to 30 days ago

Dormant

More than 30 days ago

Onboarding

Never

Agents who need attention are listed first. Use Activity Status and Apply to show one group.


Agent Roster

Lists every agent with their email, phone, role, agency, NPN, status, and how many clients and policies they have.

It starts with active agents. Change Agent Status to Inactive or All and click Apply to see the others.


Client Summary

Shows the size and makeup of each agent's book.

  • Total — every client in the agent's book.

  • New — clients added in the date range.

  • Active, Prospect, Inactive — how the book splits by status today.

Good to know: The date range only changes the New column. The other columns always show the book as it is now.


Payment Risk

Lists policies where the writing agent may not get paid, because of a problem with their carrier appointment.

Risk reason

What it means

not appointed

The agent isn't appointed with that carrier.

pending

The agent's appointment with that carrier is still pending.

carrier not contracted at agency level

Your agency doesn't have a contract with that carrier.

Fix these under Carrier Appointments.


Filter shortcuts

These four load filters into the Report Builder and run them. Change the filters afterward if you like.

Shortcut

Filters

Pending apps

Policy status is Pending/Submitted

MAPD policies

Plan type is MAPD

New to book

New to book / rewrite is New to Book

AEP MAPD (effective)

Plan type is MAPD and Election period is AEP


Saving your own

  1. Build your filters in the Report Builder.

  2. Click Save to Quick Reports.

  3. Enter a Report name and click Save.

Your report appears under Saved at the bottom of Quick Reports. To remove one, hover over it, click the trash icon, then click Remove.

  • Only the filters are saved. Group by and the terminated-policies checkbox go back to their defaults.

  • Saved reports are yours. Other people in your agency don't see them.

Did this answer your question?