Skip to main content
A basic .CSV is required to have the following information fields (columns) in or
Field NameExampleNotes
First NameSarahColumn Required, but contact will still import if not available for certain contacts
Last NameStevensColumn Required, but contact will still import if not available for certain contacts
Email[email protected]A contact must have either a phone number and/or email to be imported.
Phone Number401-017-1947A contact must have either a phone number and/or email to be imported.
StatusWorkingColumn Required, but contact will still import if not available for certain contacts
Hatch directly supports the following additional fields. We recommend you add the following if they are readily available:
Field NameExampleNotes
Created Date2/15/2020This field can be used for contact created date, or appointment created date.
Updated Date2/20/2020This is often a ‘Last Modified Date’ or a ‘Last Updated Date/Time’ field
External ID10710393If the contact as an ID associated, such as appointment or opportunity ID. This field will take place of that.
Other DetailsRepresentative Name, House Color, Address, Spouse Name, Appointment Time, SourceAll other details will still import into Hatch. They will show up in the contact as details. There details can still be used for targeting and campaign language.
If you need an example, copy our Template to get started.

​
Creating Campaigns with Imported Contacts

​
Creating a List for Campaign

Contacts can be launched into a campaign using any details that were added upon import. To learn more about Campaign in general, click here. If you like to segment contacts prior to importing into Hatch, we recommend adding a ‘tag’ upon import to easily find contacts for launch.
  1. When creating your CSV, add a column called “Campaign Tag”. For each contact, add a value that will be unique for that list of contacts. For example “Rehash21024” or “HomeshowOctober”. Here you can see a tag of “HomeshowOctober” was added to the contact record. We will use that to search for later in Hatch.
  2. Go to the Contacts Page within Hatch and click Import CSV. Make sure fields have matched up appropriately, and confirm the import.
Import your CSV, and then confirm all the fields are matching up appropriately. Fields that don’t match will still come through as Details.
  1. Once contacts are imported you can locate the list in the audience builder by selecting the Imported as the source option on the contacts page within the Audience Builder and selecting the column name you decided on your tag. Using this criteria you can also can save the audience for these contacts and use that group to automatically launch contacts into the campaign via workflow.
Using the tag we’ve added on in the CSV, we can now search for our unique list of contacts in Hatch.

​
Frequently Asked Questions

Currently Hatch only supports the importing of .CSV files.However, many common spreadsheet formats can easily be converted to a .CSV using Google Sheets or Microsoft Excel. If you can export as a .XLS, .XLSX, or a .TSV these formats can be saved as a .CSV with little to no data loss.
We recommend adding a unique tag on the CSV that you can search for later in Hatch. Click here to learn more.
While Hatch will not stop you from importing your .CSV, it’s important that these are two separate fields.Our recommended messaging is built around only using the customer’s First Name. If these two fields are joined, then the customer will always be called by their Full Name.
Hatch only supports matching one phone number to a contact. If you have multiple columns of phone numbers, we recommend mapping the Hatch Field to any mobile numbers columns you have available.If you wish to target different kinds of phone numbers for different customers located across multiple columns, you’ll have to combine those columns together so every contact has a phone number in Hatch.
Reach out to us at [email protected] so we can get it answered for you!