Agencies and Agents can export their full book of business, including over 100 columns of enrollment data!

The export is a .csv file which contains applicant information, plan details, follow-up statuses, and many many more columns of data. For a description of what every column means, please refer to this Excel file legend.

Agents and Agencies commonly export their books to update their own tracking systems or their CRM. Other reasons include:

  • Helping to effectuating policies

  • Targeting outreach to a particular group of clients

  • Doing custom reporting for their business

Client Exports

Exporting clients as an agent

From your Clients tab, click the Export button:

You'll then see this pop-up:

From here, select the date range you'd like to export from (the date range refers to the last time an application was submitted, including Report Changes submissions). Then press Export Clients, at which point you'll be sent an email with a link to download the .csv file (large exports of 1000s of clients can take a bit for the email to arrive).

Exporting clients as an agency

The agency version of the Client Export works just like the agent export described above, but includes clients from every agent in your downline.

To access the agency export, you must be a Primary Admin or Agency Admin. Go to your agency page, then click the Export button in the top right.

Lead Exports

Agents can export additional columns about their leads too. The Leads Export is available from the Leads page, on the top right side of the Leads Table. Click that Export button to get an email with the .csv file. This export is very similar to the Clients Export, just with a slightly different set of columns.

Agency Roster Exports

On top of the Clients and Leads exports, Agency Admins are also able to export a roster of their downline agents. This makes it easier for Agency Admins to do the following:

  • Email their downline agents who have linked HealthSherpa agent accounts

  • Check whether their downline agents’ settings are accurate

  • Confirm their downline agents have enabled EDE

  • Assess enrollment volume at the downline agent-level

To download the roster, admins will click the ‘Export’ button from the Agency tab. A modal similar to the example below will appear. Admins need to click ‘Export agents’ to receive a copy of their Agency’s roster.

Click here to see a legend of all the columns in the Agency Roster Export. Columns may change in this export, so bookmark this link to have an up-to-date reference.

Agency DMI Exports

In addition to Agency Roster exports, HealthSherpa has an export that reports Agency-level DMI statuses. This feature should be especially helpful for Agencies who have internal teams dedicated to DMI resolution.

This new Agency Admin report will pull DMIs with a due date from the past two months to anytime in the future. For all DMIs within that timeframe, the export includes the following information:

  • Agent name

  • Client FFM app id

  • DMI type

  • DMI status

  • DMI Due date

  • URL Link to Client Details Page

Click here to see a legend for these columns, including definitions for each field.

Agency admins can pull this export by clicking on the ‘Export’ button above the table in the ‘Clients’ tab, and then hitting the 'Export DMIs' button as shown in the image in the previous section.

Additionally, all Agency Admins can automatically receive this export in a weekly email if they are opted into receiving them from the ‘Settings’ tab.

Export Security

We strongly recommend that all Agencies and Agents set up 2-factor authentication (2FA) for their HealthSherpa accounts to keep their book’s data as secure as possible. Click here for instructions on how to enable 2FA and give your account an added layer of security.

FAQ

Why don't I see any Export button?

Please do note that if you are a member of an agency and you see no Export button, you may need to ask your administrator to access that report.

Why can't I access my Export?

After you export, you'll get an email with a link to download your export. If your Export is for thousands of clients, it may take a while for the email to arrive. If you have issues accessing the link located in your email, open the link in an incognito tab, log back in, and it will load for you. Please contact Agent Support for assistance if needed.

Does the Export ever change?

While infrequent, the format or columns of the export report may change. This Excel file legend will always be up-to-date with the latest.

Did this answer your question?