Before you can start sending emails and SMSes, you need to import your contact database into the system.
You can import your contacts from the following sources:
If you're going to import your contacts from an Excel spread sheet, we recommend that you first take the following steps to prepare the data:
You can also download the Import Example File if you get stuck.
Once imported, contacts are stored in the system in lists which are basically spread sheets housing each contact's details.
To start importing contacts, go to Contacts > Import and then click the New Import button. Click the icon for the source of your import. We will cover each of these options in detail below.
Use this option when you have a database of contacts on the computer you are working on. We support TXT, CSV, XLSX and XLS file formats.
If you only have a small number of contacts to import, you can use the copy and paste function to manually add your contacts. Make sure that each email address is on its own line. If you want to include properties for contacts you can do so using commas to separate the properties.
You can include column names in the import by pasting them into the first row, and our system will use them to map your data. Download the example file linked above to see how the column names should be formatted. These names the names of your fields, including any custom fields you may have set up before starting the import.
You can upload from an HTTP, FTP, or SFTP file server. For files hosted on an HTTP server, paste the URL into the field provided. If your file is hosted on an FTP or SFTP server, enter the server URL, username, password, and file name when promoted to.
Once you have uploaded from the server you have the following options:
Follow these steps to import a list of contacts from a web-based service such as Google, Salesforce or Shopify:
Once you have uploaded from the selected service you have the following options:
Once you have specified the source for your import, click Continue to move on to step 2.
In this step, you tell Everlytic which field it must apply to each column of your data. If the wrong field has been applied, you can change it by clicking the drop-down menu and choosing the correct one. A column will be excluded from the import until you allocate the correct field to the data.
The system will display the number of rows there are, the number of matched columns, and the total number of columns. If your first row is made up of field names, use the "Import first row" radio button to unmap it. It will not be imported.
If your data uses something other than commas to separate fields, you can select a new delimiter from the drop-down menu in the Advanced Options section.
If you have a custom ID that you want to use to identify your contacts, you'll need to create a custom field before you start the import. You can then assign it to your data in this step. Once you've created the custom field, check the Update with my own custom ID checkbox, and choose the relevant field from the drop-down menu.
You can import your customers using your own unique reference number as the contact reference in the system. You’ll be able to search the database, view contact reports, and update contact details using this reference number.
You will have to create a custom field for the unique identifier before starting the import.
Follow these steps to use a unique identifier:
Once you're happy with the fields assigned to your import, click Continue.
You can now import contacts with multiple-value custom fields. These fields must exist as custom fields, set to Multiple Value, before they can be imported with your contact. Use the sanitized name found under Custom Fields as the import values. You can comma separate them to apply more than one option.
In the import document, each multi-value option must have it's own column. Before importing, set the value in the file to either On/true for true, or Off/false for false.
You can add your contacts to an existing list by checking the checkbox next to that list's name in the table. You can also create a new list by clicking Create List. A modal will appear where you can enter the details for your new list:
In this section, you have the option to:
Review the import settings such as the import type, file name, columns mapped, list selected, options used, and if you need to, set any scheduling. If you notice any errors you can return to a previous step by clicking the Back button.
Check the checkbox to confirm that your list is permission-based and does not contravene the system's anti-spam policy.
Once the settings are correct, click Start Import.
The final import screen will let you know how your import is going. From this screen you can also see the Import History, Lists, and Contacts.
When you click Start Import, your import goes into a queue and you can carry on with other work in Everlytic (such as composing an email campaign). You'll receive a notification email once the import is complete. This email will have a summary of how many contacts were in the import, and how many were excluded due to errors or duplication.
Once you have imported your contacts, you can view statistics on the Import listing page.
Click the name of the import, and the stats will open on the right of the page.
You can export lists of the duplicates, failed, and fixed domain contacts. Click the tab, and then click Export. The whole list will be exported in .CSV format.
You can then make any corrections you need to, and re-import the corrected .CSV list.