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
Build your filters in the Report Builder.
Click Save to Quick Reports.
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.









