To analyze a payer care gap report with AI, first confirm the tool has signed a business associate agreement (BAA). Then upload the file as-is. Ask it to map each payer's columns to one layout, dedupe patients across payers, and rank who has the most open gaps. Then verify the counts against the payer portal before any outreach.
Takeaways
BAA first, upload second
A gap report is protected health information. Consumer AI plans, and team plans such as ChatGPT Business and Claude Team, are not covered by a BAA.
Let the AI do the mapping, but check it
Ask it to show the column mapping and the dedupe rules before it applies them.
Ask questions, not just for a cleaned file
Who has two or more open gaps? Which PCP panels are behind? Who is due for an annual wellness visit?
The payer's portal is still the source of truth
Reconcile your totals against it. The AI does not change any patient's official gap status.
Why the monthly gap report is so hard to use
A care gap is a recommended service a patient has not received yet, such as a mammogram or a diabetic eye exam. Payers send practices lists of these gaps, usually monthly. Each list tells you which attributed patients still count against you on quality measures like HEDIS, the measure set most health plans use.
The trouble is that every payer sends a different file. One calls the member ID MBR_ID. Another calls it SUBSCRIBER_NO. One lists each gap on its own row. Another puts every measure in its own column with a 0 or 1. Measure names show up as codes like BCS, COL, EED or GSD, sometimes with no legend.
So someone on your team spends days copying, renaming and pasting before anyone calls a patient. By the time the list is clean, the next file has arrived. That is the work an AI workspace is good at, as long as it is the right kind of workspace. See our care gap glossary entry if you need the basics first.
The workflow, step by step
- 1
Confirm the tool has a BAA
A vendor that stores or processes PHI for you is a business associate under HIPAA. Get the BAA signed before a single row goes in. If the tool will not sign one, do not upload the file.
- 2
Upload the files as-is
Upload the raw Excel or CSV files from each payer. Do not rename columns first. The AI needs the original headers to map them, and you keep an untouched copy to check against.
- 3
Map columns and dedupe across payers
Ask it to map every file to one layout and show you the mapping. Then dedupe patients who appear on more than one payer's list, flagging near-matches for a person to review.
- 4
Enrich the list
Rivvi enriches uploads against CMS and NPI registry data. Add your own EHR export for last visit date and phone numbers.
- 5
Ask questions
Which patients have two or more open gaps? Which PCP panels are furthest behind? Who is due for an annual wellness visit? Ask, read the answer, then ask the next question.
- 6
Build the prioritized list
Turn the answers into one ranked outreach list with phone, preferred language, PCP and the open gaps for each patient. Export it to Excel or keep it in the workspace.
- 7
Act and track
Run outreach by call or text, or hand the list to staff. Log every outcome. Next month, compare the new file to this one to see what closed.
Step 1 matters more than the rest
Under HIPAA, a business associate is anyone who "creates, receives, maintains, or transmits" PHI on behalf of a covered entity. An AI vendor holding your gap report fits that definition. Many popular plans do not offer a BAA. OpenAI says ChatGPT Free, Plus, Pro and Business are not eligible services. Anthropic says its Team and individual plans cannot enable HIPAA. Our guide to whether ChatGPT is HIPAA compliant covers the details.
Rivvi includes a HIPAA BAA on the free plan, and PHI access is logged. You can start in the HIPAA-compliant AI chat with your actual file, not a scrubbed sample.
Check the mapping before you trust it
AI can map a column wrong. A field named DT might be date of birth in one file and date of service in another. Ask the AI to show its mapping as a short list before it applies anything. Then spot-check five rows from each payer against the original file.
Once the mapping is right, ask the AI to remember it. In Rivvi, that goes into memory your team can view, edit or remove. Next month starts from the saved mapping instead of from scratch.
10 prompts to run on your gap report
Copy these, then change the names and numbers to fit your files.
- "Here are this month's gap files from three payers. Map each file's columns to one layout: member ID, name, date of birth, phone, PCP, payer, measure, gap status. Show me the mapping before you apply it."
- "Dedupe patients across all three files. Match on last name plus date of birth. List possible matches separately so I can review them instead of merging them."
- "List every patient with two or more open gaps, sorted by gap count, then by PCP."
- "Which PCP panels have the most open gaps? Show the count and the share of each panel that has at least one open gap."
- "Break open gaps down by measure and by payer. Which single measure has the most open gaps across all payers?"
- "Using our visit export, flag patients with no annual wellness visit or Welcome to Medicare visit in the last 12 months."
- "Which open gaps need an office visit, and which might close with a lab result or records we already have?"
- "Check every PCP NPI against the NPI registry. Flag any that don't match the provider name in the file or belong to someone who left our group."
- "Build one outreach list: patients with two or more gaps first, then AWV due, then single gaps. Include phone, language and the open items for each."
- "Compare this file to last month's. Who closed, who is new, and which gaps stayed open both months?"
For prompt 6, remember the Medicare rule. A patient qualifies for an annual wellness visit once they are more than 12 months past the start of Part B. They also must not have had an IPPE or AWV in the past 12 months. Ask the AI to apply both conditions, not just the second.
Turn the list into action
A ranked list sitting in a shared drive closes nothing. The next step is reaching patients, and each practice does this differently.
Some teams export the list and split it across staff. Others use the action layer on the same workspace. On Rivvi's Team plan, the AI can call or text patients from the list, in Spanish plus 30 more languages. When a patient wants to book and your schedule lives in the EHR, Rivvi does not book into it. It warm-transfers the patient live to your scheduler, or creates a follow-up task with the details. A warm transfer means the patient stays on the line while the call is handed to a person.
Every outcome is recorded in Rivvi. If you connect HubSpot, Salesforce or Zoho, outcomes are pushed there too. TCPA opt-out is honored on every outreach path. For more on turning a roster into a call list, read how to build a care gap outreach list from an attribution file.
Then track. Next month, upload the new payer file and run prompt 10. You will see which gaps closed after outreach and which patients still need a second try.
Upload one payer file
Start free with a BAA included. Ask your gap report who to reach first.
What AI can't do with a gap report
Be clear with your team about the limits.
- It does not change official gap status. Only the payer closes a gap, based on claims or supplemental data you submit. The AI's list is a working copy.
- Payer files lag. A gap you closed last week may still show as open because the claim has not processed. Check recent visits before calling.
- Counts can drift. After mapping and dedupe, compare your totals by measure to the payer portal. If the AI's breast cancer screening count doesn't match the portal's, find out why before acting.
- It can be wrong. AI tools can produce confident errors, often called hallucinations. Spot-check named patients against the source file.
- Send only what you need. HIPAA's minimum necessary standard asks you to limit PHI to what the task requires. If the analysis does not need Social Security numbers, delete that column before you upload.
Used this way, the AI does the copying, renaming and sorting. Your team spends its time on the patients. If you want a dedicated workflow on top of this, see care gap closure.
Ask your gap report who to call first
Free for you and two colleagues, with a HIPAA BAA. No card. No clock.