Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Commercial Platform
  • User Guide

Exporting Data

Written by rob g

Updated at March 2nd, 2021

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Commercial Platform
    User Guide Commercial Reports How to Videos
  • Benefits Platform
    User Guide Benefits Data
  • Recent Updates
  • User Questions
+ More

Table of Contents

OverviewExport FileStandard Export FieldsCarrier Search add-on Data FieldsExport Package add-on Data FieldsExperience Mod ExportingExporting LimitationsCommon Questions

Overview

Downloading

Search Results can be downloaded by clicking the Export button located at the bottom of your List View‍ 

Export File

CSV

Not to be confused with an Excel file, the export is a CSV file (comma-separated values). CSV files can be opened with a number of applications including Microsoft Excel, Apple Numbers, LibreOffice, Google Sheets, etc.

If you do not have Excel, we recommend Google Sheets, however these instructions will apply to most other applications-

  1. Open Sheets
  2. Choose "file" - "import" - "upload"
  3. Select the file and follow prompts to import

Standard Export Fields

Standard Fields

  1. Company ID - this is our internal ID
  2. Name - business name
  3. Lat/Long - the latitude & longitude of business address
  4. ID - list order
  5.  Address - street address
  6. City
  7. State
  8. Zip
  9. Phone
  10. County
  11. Effdate - WC renewal date of coverage (label needs correction)
  12. Class - primary WC class code of business's operations
  13. Classdesc - class code description (as available)
  14. Baserate - class code Loss Cost
  15. PEO
    1.  = non-PEO policy type (> or equal to 2 indicates leasing/PEO type policy)
  16. Peoprovider - name of PEO provider
  17. Residual
    1.  = voluntary market
    2.  = assigned-risk

Carrier Search add-on Data Fields

Carrier Search Data Fields

  1. Carrier - Incumbent WC Carrier
  2. LCM - carrier's current LCM filing (as available)
  3. Premium - WC premium (as available)
  4. Policynum - WC policy number


Carrier Search add-on

this add-on enables the Carrier targeting in your Search Menu‍ and adds the data to your export file. Note you do not need this add-on to view the information in your Details Modal‍ 


Export Package add-on Data Fields


Export Package Data Fields

  1. FEIN
  2. Employees
  3. Sales
  4. Contact info
    1. contact fields are numbered (i.e. email1, email2, name1, name2, phone1, phone2, position1, position2, etc)

Experience Mod Exporting

Info

Experience Mod data is available in the following states: DE, MN, NC, NJ, PA

Exports from these states' datasets will include Exp Mod data fields

Note

Renewal mods are released approximately 90 days in advance of a renewal. If a renewal mod is issued for an account you have exported it will be the first mod value in the sheet ('mod'). Users are advised to check a couple listings' Business Details‍ screen to verify if renewal mods have been issued. Renewal mods display in the upper left pane of the Modal, while current and historical mods are displayed with the coordinating policy in the Carrier History section. 


Exporting Limitations

Single User

Record Count - 200 exports per billing cycle

Date range - 90 days in advance, based on renewal date of coverage. i.e. if it is 3/1 you can export up to 200 records renewing through 5/30 (3/1 to 5/30 is 90 days, 6/1 would be 92 days..)

Team's Monthly

Record Count - up to 1,000 records per export. Unlimited exporting.

Date range - 90 days in advance, based on renewal date of coverage. i.e. if it is 3/1 you can export records renewing through 5/30 (3/1 to 5/30 is 90 days, 6/1 would be 92 days..) 

Team's Annual

Record Count - up to 1,000 records per export. Unlimited exporting.

Date range - annual plans are given a 14 month window for exporting. For example, if your subscription starts on 3/1/21 you can export businesses renewing through 5/1/22. For obvious reasons we cannot allow annual plans to export an annualized list on the last days of their subscription, so we include a 2 month buffer to allow for continued activity.

* we can waive this restriction with a written confirmation of your subscription renewal, via email. 

Note

The Export Package increases the per export limit of Team plans from 1,000 to 4,000 records per export. This add-on does NOT increase the single-user plan's cap of 200 exports per billing cycle.


Common Questions

Export Count is Lower than my Search Results

  • this is due to one of the above limitations (i.e. double check the date range of your search)

LCM Values are Inconsistent

  • Possibility 1 - we store LCM's historically. So the same carrier may have two different LCM filings in your export, which will depend on a given prospect's renewal date and the effective date of the Carrier's LCM filing. The easiest way to check for this is by checking out the Carrier History section of the Business Details - in this scenario, the 5/1 renewal has the 'old' LCM, however a 9/1 renewal with the same carrier may have the 'current' LCM. 
    ‍
  • Possibility 2 - multi-state accounts. as of this writing we are in the process of resolving a glitch, which causes the LCM from another state's policy coverage to export. For example, if you export a business based in NC that also has operations (and active coverage) in TN, the LCM value from the TN policy may show up on your NC export. This is limited only to businesses which have active coverage in multiple states. The easiest way to check for this is by checking out the Carrier History section to see if multiple states are listed.



Was this article helpful?

Yes
No

Related Articles

  • Pipeline
  • CRM - Scheduled Events & Flagging Accounts
  • OSHA Data
  • Search Results/List View

Links

  • Terms of Service
  • Privacy Policy
  • PEO
  • Loss Runs

Contact Info

support@insurancexdate.com

1-888-567-4119

Recent Posts

  • 2021 – Q1 Updates – Mobile App, CRM Enhancements, Integrations & New Tools
  • WC Class & GL Lookup
  • CA Data Available

InsuranceXdate, LLC

Definition by Author

0
0
Expand