Skip to main content

Exporting client & lead data

Agents and agencies can export data from the HealthSherpa account.

A
Written by Amber Blank
Updated this week

Siga las instrucciones aquí para traducir esta página a otro idioma usando Chrome.


Export functionality lets agents and agencies download data from the HealthSherpa account into a Comma Separated Values (CSV) file for tracking and reporting. The data included depends on the export selected, and available exports depend on whether the export is generated at the agent level or the agency level.

In this article we’ll cover:

Export functionality is not available within HealthSherpa Enrollee Assistance Full-Service account types.


Agent exports

Agents can export different pieces of information from the HealthSherpa account. For column definitions, refer to the export legends.

Clients

The clients export pulls data about consumers listed on the Clients page and includes plan information, application details, and more. Agents commonly use this export to support policy effectuation, reporting, & reconciliation.

Any filters currently in use on the Clients page apply to the clients export when generated. To initiate the clients export, go to the Clients page and select Export.

Agents are prompted to select a date range and make customizations:

  • Date Range: The last time an application was submitted, including submissions where changes were reported.

  • Include unsubmitted search & claimed applications: Select the checkbox to include applications that have been searched & claimed into the Clients page, but not submitted from the HealthSherpa account.

  • Include 3-way call-resolved Invalid Action applications: Select the checkbox to include enrollments that were submitted via 3-way-call with the Marketplace after the agent received the Centers for Medicare & Medicaid Services (CMS) Invalid Action error on HealthSherpa.

Select Export to generate the report.

Large exports of thousands of clients can take additional time for the email to arrive.

Client follow-ups

Agents often need to manage several different types of follow-ups to ensure their consumers effectuate.

To access the client follow-ups export, go to the Clients page, select the Client follow-ups tab, and select Export contacts list.

Leads

The leads export pulls data about consumers listed on the Leads page and reflects any filters currently in use on the Leads page.

To initiate the leads export, go to the Leads page and select Export.

AOR at-risk clients

The Agent of Record (AOR) at-risk clients export helps agents prioritize outreach to reduce the chance of losing AOR.

To access the AOR at-risk clients export, go to the Exports page and find the AOR at risk clients section. Select Export from the Actions column.

EDE permission lost clients

Centers for Medicare & Medicaid Services (CMS) grants Enhanced Direct Enrollment (EDE) permission to agents for their enrollments, which enables data syncs. When an application has an EDE data sync, the HealthSherpa dashboard shows the most up-to-date application information.

The EDE permission lost clients export displays applications where the EDE connection has been lost, which can prevent HealthSherpa from showing the most up-to-date application details.

To access the EDE permission lost clients export, go to the Exports page and find the EDE permission lost clients section. Select Export from the Actions column.

Invalid Action error tracker

Centers for Medicare & Medicaid Services (CMS) may return an Invalid Action error during an enrollment submission. The Invalid Action error tracker export helps agents track consumer progress when a consumer uses a resume link to complete the enrollment after the error occurs.

To access the Invalid Action error tracker export, go to the Exports page and find the Invalid Action error tracker section. Select Export from the Actions column.

DMI follow-ups

A Data Matching Issue (DMI) occurs when the information entered on a consumer’s subsidy application does not match what is on file with the government, or is not available in government records, and needs to be verified. The DMI follow-ups export lists DMIs with a due date from the past two months through future due dates so agents can track what needs attention.

To access the DMI follow ups export, go to the Exports page and find the DMI follow ups section. Select Export from the Actions column.

SVI follow-ups

A Special Enrollment Period (SEP) Verification Issue (SVI) occurs when the information entered for a SEP does not match what is on file with the government, or is not available in government records, and needs to be verified. The SVI follow-ups export lists SVIs with a due date from the past two months through future due dates so agents can track outstanding verification items.

To access the SVI follow ups export, go to the Exports page and find the SVI follow ups section. Select Export from the Actions column.

If an agent is part of an agency and does not see export functionality, an agency administrator may have disabled exports. Work with the agency administrator with questions.


Agency exports

In addition to agent exports, agency administrators can generate exports that pull data at the agency level. For column definitions, refer to the export legends.

Enrollments

The Enrollments export pulls data about consumers listed on the Clients page of all HealthSherpa accounts linked to the agency hierarchy.

The Enrollments export includes plan information, application details, and more. Agencies commonly use this export to support policy effectuation, reporting, & reconciliation.

To access the Enrollments export, go to the Agency page and select the Exports tab. Locate the Enrollments row and click Export from the Actions column.

Agency administrators are prompted to make customizations:

  • Exchange: On-Ex is chosen by default. Choose Off-Ex to capture enrollment submission data about applications done Off-Marketplace.

  • Date Range: The last time an application was submitted, including submissions where changes were reported.

  • Include archived applications: Select the checkbox to include applications that have been archived from the Clients page.

  • Include unsubmitted applications: Select the checkbox to include applications that have been searched & claimed into the Clients page, but not submitted from the HealthSherpa account.

  • Include 3-way call-resolved Invalid Action applications: Select the checkbox to include enrollments that were submitted via 3-way-call with the Marketplace after the agent received the Centers for Medicare & Medicaid Services (CMS) Invalid Action error on HealthSherpa.

Select Export to generate the report.

Large exports of thousands of clients can take additional time for the email to arrive.

Agent roster

The Agent roster export pulls data about each HealthSherpa account linked to the agency hierarchy. Agency administrators commonly use this export to conduct outreach to their downline, and conduct operational checks such as confirming settings and enrollment volume.

To access the Agent roster export, go to the Agency page and select the Exports tab. Locate the Agent roster row and click Export from the Actions column.

DMI follow-ups

A Data Matching Issue (DMI) occurs when the information entered on a consumer’s subsidy application does not match what is on file with the government, or is not available in government records, and needs to be verified.

The DMI follow-ups export pulls data from each HealthSherpa account linked to the agency hierarchy.

The DMI follow-ups export lists DMIs with a due date from the past two months through future due dates so agency administrators can track what needs attention. This data is especially helpful for agencies with internal teams dedicated to DMI resolution.

To access the DMI follow-ups export, go to the Agency page and select the Exports tab. Locate the DMI follow-ups row and click Export from the Actions column.

SVI follow-ups

A Special Enrollment Period (SEP) Verification Issue (SVI) occurs when the information entered for a SEP does not match what is on file with the government, or is not available in government records, and needs to be verified.

The SVI follow-ups export pulls data from each HealthSherpa account linked to the agency hierarchy.

The SVI follow-ups export lists SVIs with a due date from the past two months through future due dates so agency administrators can track what needs attention. This data is especially helpful for agencies with internal teams dedicated to SVI resolution.

To access the SVI follow-ups export, go to the Agency page and select the Exports tab. Locate the SVI follow-ups row and click Export from the Actions column.

AOR at-risk clients

The Agent of Record (AOR) at-risk clients export helps agency administrators prioritize outreach to reduce the chance of losing AOR.

The AOR at-risk clients export pulls data from each HealthSherpa account linked to the agency hierarchy, and may include enrollments that have transferred to another agent in the agency.

To access the AOR at-risk clients export, go to the Agency page and select the Exports tab. Locate the AOR at-risk clients row and click Export from the Actions column.

EDE permission lost clients

Centers for Medicare & Medicaid Services (CMS) grants Enhanced Direct Enrollment (EDE) permission to agents for their enrollments, which enables data syncs. When an application has an EDE data sync, the HealthSherpa dashboard shows the most up-to-date application information.

The EDE permission lost clients export displays applications where the EDE connection has been lost, which can prevent HealthSherpa from showing the most up-to-date application details.

The EDE permission lost clients export pulls data from each HealthSherpa account linked to the agency hierarchy.

To access the EDE permission lost clients export, go to the Agency page and select the Exports tab. Locate the EDE permission lost clients row and click Export from the Actions column.

Payouts awaiting consent upload

HealthSherpa requires consent documentation for all Enrollee Assistance Program (EAP) submissions. EAP compensation cannot be administered until documentation has been received.

The Payouts awaiting consent upload export pulls data from each HealthSherpa account linked to the agency hierarchy. Agency administrators commonly use this export to ensure the proper consent documentation can be submitted.

To access the Payouts awaiting consent upload export, go to the Agency page and select the Exports tab. Locate the Payouts awaiting consent upload row and click Export from the Actions column.

Payouts program report

Agencies participating in a HealthSherpa Agency JMA can use the Payouts program report export to review bonus dollars paid to the agency for a selected date range. The Payouts program report export pulls data from direct downline agents linked to the agency.

To access the Payouts program report export, go to the Agency page and select the Exports tab. Locate the Payouts program report row and click Export from the Actions column.

Invalid Action error tracker

Centers for Medicare & Medicaid Services (CMS) may return an Invalid Action error during an enrollment submission. The Invalid Action error tracker export helps agency administrators track consumer progress when a consumer uses a resume link to complete the enrollment after the error occurs.

To access the Invalid Action error tracker export, go to the Agency page and select the Exports tab. Locate the Invalid Action error tracker row and click Export from the Actions column.

Intake

The Intake export provides agency administrators with unique intake links associated with consumers working with downline agents, which can be shared with consumers as needed.

To access the Intake export, go to the Agency page and select the Exports tab. Locate the Intake tracker row and click Export from the Actions column.

Client follow-ups

Agents often need to manage several different types of follow-ups to ensure their consumers effectuate.

To access the client follow-ups export, go to the Agency page and select the Tasks tab. Select Client follow-ups from the menu, and select Export contacts list.


Viewing exports

Once an export is generated, HealthSherpa sends an email with a link to download the CSV file to the email address associated with the HealthSherpa account.

Agents and agency administrators can also access export history from the HealthSherpa account. To access export history, go to the Exports page and select the Exports History tab.

From the Exports History tab, agents and agency administrators can access and re-download previously generated exports, view when the export was requested, and check the export type and status.

If an export was requested but the CSV email was not received, check the Exports History tab to confirm the status.

If the export is processing, allow more time for the email to arrive. If the export failed, request the export again or contact Agent Support. If the export succeeded and download is ready, check email settings to confirm emails from HealthSherpa are being received. If the HealthSherpa account unsubscribed from HealthSherpa emails in the past, contact Agent Support to resubscribe.


Export legends

Export legends include descriptions of what specific columns and values mean for each available export. Select the export legend that matches your HealthSherpa account type, then use the tabs to find the export being requested and review the column definitions.


Disabling export functionality

Agency administrators can disable export functionality for direct downline agents.

To disable exports, go to the Agency page and select the Exports tab. Find the Allow exports for my agents section, and adjust the toggle to Prevent exports.

Preventing exports for direct downline agents does not impact sub-agencies linked to the agency hierarchy. Sub-agency administrators will still have access to exports when Prevent exports is selected.


Frequently asked questions

Do exports ever change?

Yes. The format or columns of an export report may change. Use the export legends to confirm column definitions.

How long is the export link active?

Export URLs expire approximately one hour after the export email is generated.

Why are some fields showing asterisks?

Due to updated Centers for Medicare & Medicaid Services (CMS) restrictions, CMS no longer allows Enhanced Direct Enrollment (EDE) entities to export certain data including Social Security Numbers, dates of birth, and household income. To comply with CMS rules, HealthSherpa masks this data with asterisks.

Why is the “3 way call completed” field in the Invalid Action error tracker export not displaying accurate information?

Agents who complete a three way call with the Marketplace may not see updated information in this column if the application details have not been synced in HealthSherpa, the update has not appeared in information HealthSherpa received from Centers for Medicare & Medicaid Services (CMS), or the call happened before the last week of November 2024.

HealthSherpa pulls three way call submission information from CMS on a per application basis. If a three way call was not completed with a consumer and Yes displays in this column, the call may have been completed by another agent.


Additional resources

For help using HealthSherpa or for other assistance, contact Agent Support. Agent Support is available by phone at (888) 684-1373, by email at Agent_Support@HealthSherpa.com, or by chat directly from your account.

For agency specific needs, contact our Agency Success team at Agency.Success@HealthSherpa.com.

Did this answer your question?