Import your contact lists

Import your contact lists

Preparing your file

Before we cover the process, let's talk about file preparation. The following are a few tips for a smooth import experience.
  1. Utilize a spreadsheet application to easily view and edit your data file. Organize each point of data into its own column.
  2. Only email address data is required. But, we encourage you to store additional data that you can use to personalize your emails.
  3. A header row with column names is not required. If you choose to include a header row, the columns do not need to be in any particular order and the columns names do not need to be standardized. You have the opportunity to match your rows to Delivra field names during the import process.
  4. Export or save your spreadsheet in the CSV (comma delimited) format. If you began with an Excel spreadsheet, use Save As to change the file format to CSV. If your contact management system will export to the CSV format, and you don't need to view or edit the data, there is nothing more to do to prepare the file.

Now that you know how to prepare your file we’re ready to walk through the import process. If you are not there already, navigate to your Contacts dashboard.


Prefer to watch a quick video?


How-To

Locate and click the “Import” button from the “All Contacts” tile in your Contacts dashboard.

Click the "Browse Files" button to open the file directory on your computer. Find and double-click your CSV file to select it. Then click the "Next" button on the Delivra screen.

Note: When a file is selected, the system will run a few checks on the file selected to ensure it's in the CSV format and that the file is not corrupted. When the process is complete, the box will turn green. This will take only a second or two.

Map Data. Each column from your CSV file will be listed on-screen as a row. If needed, use the drop-down menu to match the Delivra field, identifying where the data should be stored.

    • The importer may attempt to match Delivra fields based on the column name from the CSV uploaded. Please note that this may not always be accurate; double check each row before proceeding.
    • When a row was not matched automatically simply click open the drop down and scroll to find the field.


Define Import Rules. Configure settings for how your account should process the CSV file. Options include:

    • Import action - choose to send or not send an automated message to imported contacts, like a welcome.
    • Ignore blank fields - choose to ignore blank cells in the uploaded CSV file. This eliminates the possibility of existing data being overwritten with a blank if a contact already exists in your account.
    • Report Held and Unsubscribed addresses - collects contacts that already exist in your account in the Held or Unsubscribed status. This information will be sent to you in a report and those contacts will be skipped.
    • Create new tag - check the box to label the contacts being imported now with a name. This creates a group in the system that can be used to target a specific audience for an email later.


Assign Tags. If you need to also add the contacts being imported now to an existing Tag, you can select one or more by moving them to the right column.


Click “Import” at the bottom of the page to start the import process. You will be redirected to a landing page that outlines next steps.

Click the "Done" button. You will receive an email from the system when the import is complete.

Notes

  1. Contact file imports must be in CSV format.
  2. Email address is the only required data, unless importing data to one-to-many custom table(s).
  3. An Import Report will be emailed to you when the import process has completed that explains how many contacts were imported, how many contacts failed and other import details.

    • Related Articles

    • Manage tags & view subscriber lists

      What is a tag? You can apply tags to your contact records to help you sort them into mailing lists. An individual contact may have an unlimited number of tags applied—allowing your email subscribers to be grouped in various ways that make sense to ...

    • Reviewing Past Imports (Import History)

      Sometimes you may need to revisit previous imports, whether completed via FTP or CSV, to review your data updates or troubleshoot any issues. Delivra offers an Import History feature that provides a detailed summary of each upload Import History ...

    • How do I import a list of unsubscribed contacts to my account?

      If you have previously used an email service provider like Delivra, we recommend that you migrate any email subscribers that opted-out of campaigns you sent through that system. This way, you're ensuring that you don't all of a sudden start emailing ...

    • Why does my tag not include all contacts from an import?

      You may have noticed that your list of contacts in your CSV import is significantly more that what ends up in a new tag created when importing. For example, there may be 2000 rows in an import but only 1000 contacts when viewing the subscribers in ...

    • Do expired status contacts show up in import reporting?

      No, contacts in the expired status in your account will not be included in the error report for an imported CSV file like held and unsubscribed contacts do. Resources For more information on import error imports and import troubleshooting, please see ...