The Import List Wizard allows you to either Subscribe or Unsubscribe a list of contacts all at once.

Important things to note when importing lists:

  1. The Import List Wizard requires a minimum of two contacts on your file to import.

  2. There is a file size limit of 250 MB, for either the One-Time Import or Recurring Import option. However, files larger than 250 MB can be zipped to be uploaded.

  3. If a contact is currently unsubscribed from a list they will not be resubscribed during the list import process.

  4. To subscribe or unsubscribe an individual contact, use the Subscribe/Unsubscribe feature. To learn more, read the Subscribe or Unsubscribe Contacts Individually article.

  5. It's best to set up your profile fields prior to importing your list. Examples of profile fields include first name, last name, and preferences. However, you can add profile fields during the import process as well as noted below.

  6. Email is the primary key and must be provided to add a new contact.

  7. Acceptable import file formats include:
    • Microsoft Excel (.xls, .xlsx)
    • Zip file (.zip)
    • Plain text (.txt, .csv)

To begin, navigate from the home menu to Contacts > Import List Wizard.

  1. Choose between a One-Time Import or Recurring Import.

    1. If you are performing a One-Time Import, move on to step 3

    2. If you are configuring a Recurring Import:

      • Select an existing FTP integration from the drop-down

      • Enter an expected File Name, which may include wildcard characters denoted by asterisks (*)

  2. Choose the contacts' main identifier.

    1. Email Address: Uses the email addresses in the file as the main identifier of the contacts.

      • Always use this type when importing new contacts.

    2. External Contact ID: Uses another value, like a customer ID in the file as the main identifier of the contacts.

      • ONLY select this option to add/update attributes to existing contacts or to trigger a Custom Event in a Journey. that may use a customer ID as the identifier.

        💡 If you do not see this option in your account please contact your Account Manager to request access.

  3. Choose the purpose of your import.

    1. Add/Update Subscribers: Imports a list of new and existing subscribers. You can add, update, or overwrite the contacts you want to subscribe to.
      ⚠️ This option will import the entire file. If a contact is already on a list their information will be updated, but they will not be subscribed a second time.

    2. Update Existing Subscribers: Updates only subscribers that are currently on the list. If you have 100 contacts to import, of which only 75 are currently on your list, only those 75 contacts will be updated. The additional 25 contacts that do not match any records on the list will be disregarded.

    3. Unsubscribe Contacts: Removes customers from the list. Use this option to unsubscribe a list of contacts.

    4. Unsubscribe Contacts and Delete Personal Data: Removes customers from the list and immediately deletes profile data and personal data associated with past orders. Please email the Listrak Privacy Team at privacy@listrak.com for any GDPR right to know or to access privacy requests.

  4. Click Choose file and select the file you'd like to import.

  5. Click Next Step.

  6. Configure the imported file.
    💡 The configuration steps are different depending on the purpose of the important:

    1. Click here to learn how to Unsubscribe or Delete Personal Data.

    2. Follow the steps below to Add/Update or Update Existing Subscribers.

Add/Update or Update Existing Subscribers

Data Settings

In the data settings, you have two options. These will vary depending on the type of file you are importing and are explained below.

  • Does the first line of this file contain column names? The first question is in place to establish whether or your file starts with column headers. You can either define column headers, like email, first name, last name, or you can leave them undefined. Most people define column headers simply for consistency

  • If a subscriber already exists on the list, I want to... This option helps the system figure out what to do if a customer is already subscribed to the list. You have three options:

    • Update the Specified Fields: This is the default and recommended choice. This option will update only the fields that you are specifying in your file. If there is a blank in the file for one of the records, this function will skip over the field and leave what was there already in place.

    • Append New Fields: This option only adds new information. For example, if we are importing a file that includes first name and last name, and the contact we are importing has a first name, but no last name already on the list, it will only add the last name column to that contact's profile.

    • Overwrite All Fields: This option will update and overwrite every field in the file. For example, if you have a file that contains blanks in the first name column, and you have contacts that have a first name, this will overwrite the value with blank instead of skipping over the field.

Configuration Options (optional)

After you have defined the data settings, you have the option to configure the import to only process rows where the selected column has a defined value.

For example: Your file may have a column labeled "optIn" with the values "true" and "false". You would select the "optIn" column using the drop-down, and enter "true" into the adjacent textbox. This would ensure that the only rows of data processed by this import were for those records where "optIn" was "true".

Import Trigger Settings (optional)

Next, you have the option to enter these contacts into a list subscription journey and/or trigger a custom event. This import feature is available for both one-time and recurring list imports.

  • Enter subscribers into all List Subscription Journeys associated with this list: Selecting this option will only add net-new contacts (that have not been previously subscribed and are not currently subscribed) will be entered into a journey.
    For example: If you are importing contacts to the Master List and have a List
    Import Journey where the entry event is configured for the Master List, check
    the box to allow all contacts imported via the list import to be entered into the
    journey.

  • Allow this import to trigger a Custom Event: Checking this option will trigger the contacts into a custom-made journey event. Simply select from the dropdown to enter them into that journey.

💡 You can select either one or both trigger options.

Import Layout Settings

Finally, you must define the Import Layout.

If column headers have the exact same name as the profile value, the application will match the column to the profile field automatically. If they are not named the same, you will have the option to select with which profile field the column should be associated:

  • Click the Please Select drop-down menu.

  • Find the corresponding profile field.

  • Repeat for each column as necessary.

  • Click Next Step.

    1. After you have selected with which profile field the column should line up, you have the option to give the field a default value. This will take any blank field and populate it with a value. For example, if you wanted to add a default first name, you could give each customer that doesn't have a first name, the name of "Loyal Customer."

    2. If you'd like to add a profile field that was not in your file, you can use the ADD FIELD button to add subsequent attributes. To learn how to do this, read more in Add Profile Fields Using the Import List Wizard.

  • Confirm that each column is going to the right profile field.

Once you have confirmed your settings and file layout, depending on the import type, a button will prompt you to:

  1. Import File for One-Time Imports

  2. Save for Recurring Import settings.

    After the process is done importing the contacts, you will receive a List Import Summary confirmation email.


Unsubscribe Contacts

If you want to unsubscribe a list of contacts, use the Unsubscribe Contacts option.

⚠️ If you unsubscribe a list of contacts, you can't re-subscribe them by the List Import Wizard and would need to contact Listrak Support by emailing support@listrak.com or by calling 717-627-4528 x1.

  1. Click Next Step.

  2. You will be presented with a confirmation screen.

  3. After you have confirmed the settings, click Unsubscribe Contacts to finish the unsubscribe import.

After the import has been completed, you will receive a List Import Summary confirmation email.


Did this answer your question?