The Report Builder lets you ask your own questions, such as every MAPD policy written during AEP, or active clients in one sub-agency.
Step 1 — Add filters
Click Select... under Filter by and pick a field. Fields are grouped: Organization, Client, Policy, Writing, Dates and Commission.
Under Match, leave IS or switch to IS NOT.
Under Refine, check the values you want and click Add filter. For a date field, pick From and To and click Add.
Add as many filters as you need. Filters on different rows all have to match. Values in the same row are either/or.
Step 2 — Narrow by effective date (optional)
Most filters show a Policy effective date range beside them. Leave it at All time, or set From and To to count only policies that took effect in that period.
After you add a date filter, shortcut buttons appear on its row: Year to date, This month, and AEP on Application date.
Step 3 — Run it
Click Run Report. Click it again whenever you change a filter or an option.
Client rows or policy rows
The results change shape depending on what you asked for.
Client rows appear when you only use Organization and Client filters. You get one row per client, with an Agency column.
Policy rows appear as soon as you use a Policy, Writing, Dates or Commission filter, or set a Policy effective date. You get one row per policy, showing the agent, member, policy, dates, how it was written, and billing.
Including terminated policies
Policy-row reports leave out policies that are Replaced, Canceled, Disenrolled, Declined, Withdrawn or Terminated. Check Include terminated / replaced policies and run again to count them.
If your Policy status filter asks for one of those statuses, they're included anyway.
Group by
To see totals instead of a list, choose a Group by option and run the report:
Writing agent
Agency
Company
Plan type
Effective month
You get a Group and a Count, biggest first. Set Group by back to None to see the rows behind the totals.
Columns and pages
On client-row results, click Include to choose which columns show.
Results show 25 to a page. Change Rows per page at the bottom to 50, 100, 250 or All.
Build it with AI
Click Build with AI and describe the report in plain English. AI sets up the filters for you. Check them, then click Run Report.






