This article describes how to upload contacts into Higher Logic Thrive Marketing Professional (Thrive Marketing Professional) via AutoFTP.
AutoFTP
AutoFTP lets you manually upload files that contain lists of contacts. These are processed by Thrive Marketing Professional as a contact upload. The format of the files must match a data format in your Thrive Marketing Professional account before the files are uploaded through the AutoFTP website.
The AutoFTP site allows users to drag-and-drop files or to browse and upload. Thrive Marketing Professional checks for new files to process every few minutes.
Prerequisites
In order to upload files via AutoFTP, you must:
- Create the required Personal Info and Demographic Profile Fields in Thrive Marketing Professional that you will use in your upload's data format. See Profile Fields Overview.
- Have a data format in Thrive Marketing Professional that matches the data coming from the AutoFTP process. See Data Formats to Upload Subscribers.
- Save your list of contacts as a tab-delimited text file. Refer to Understanding contact upload data files, below, to learn more.
NOTE: The tab-delimited text file:
- The name of the file must not contain contain spaces or symbols.
- In the file, email addresses must be in the first column.
If you need assistance with accessing AutoFTP, create a case with Higher Logic Support.
Contact upload process
TIP: If you have not uploaded Contacts via this process before, we recommend that you review the information in Understanding contact upload data files in order to ensure that you correctly prepare your upload file and data to meet the requirements; doing so will avoid upload issues and delays.
The sections that follow detail the three-step upload process.
Step 1 - Choose a contact upload method
- Navigate to Contacts > Upload > Contacts.
- Choose an Upload Method: a file or email addresses.
- Select Upload a file and click Choose File to select your saved tab-delimited file.
OR...
- Select Enter email addresses to manually specify (type or paste) a list of email addresses, one per line.
TIP: If you're uploading data other than just email addresses, the Upload a file is the better method. Also, you can include other data fields with the email addresses by using the following delimiters: "|", "~", "," and tab.
- Upload source - Optionally, select an Upload source from the dropdown menu. Use this to indicate the source of this upload, such as those who visited your booth at a recent conference or trade show.
- Subscriber delivery format - Accept the default (HTML version) or click the dropdown to select Text version as the format of email messages that are sent to the contacts who are included in this upload.
-
- If you check the Apply to existing subscribers box, the selected email-message format will be applied to messages sent to any existing contacts who are included in this upload, irrespective of their current message-format settings. Also, refer to Manage Contact's delivery formats, below.
NOTE: Subscriber delivery format is an optional extension that can be enabled upon request. If this option does not display in your account, create a case with Higher Logic Support and request that it be enabled.
- Click Next.
Manage Contact's delivery formats
You can manually manage the delivery format for individual contacts.
- Navigate to Contacts > Search.
- Hover on the options menu to the left of the contact you want to manage and choose Modify.
- On the Edit tab, click the Format dropdown and choose either HTML or Text.
- Click Submit.
Step 2 - Select a data format
- Choose the data format to use for this list. Thrive Marketing Professional will present only those data formats that have the same number of columns as the incoming data file. See Data Formats to Upload Subscribers for more information.
NOTE: The data format should have been created before uploading contacts. Thrive Marketing Professional previews the data to help you to choose the appropriate data format. If the data format was not yet created, you can create one by selecting Create New (to learn how to create data formats, check out the link above).
- Once the data format is selected, click Next.
Step 3 - Select interests
For this step, you will associate interests to the contacts you're uploading. There are two methods to do so: Simple and Advanced.
Simple method
With this method, you'll simply select interests to associate to ALL uploaded contacts.
NOTE: Keep in mind the following:
1. You must select at least one interest for contacts before uploading.
2. Unless otherwise configured, interests will be applied to all contacts being uploaded.
3. Check the Replace Existing Subscribers box to remove all existing contacts from the selected interest(s). The removed contacts will not be unsubscribed—they will be replaced with the email addresses found in your upload list.
4. Check the Remove Existing Subscribers box to remove the uploaded contacts from the selected interests. The removed contacts will not be unsubscribed.
5. Before uploading, consider the "empty Personal Info fields" checkbox. If checked, and your upload contains empty Personal Info fields for an existing contact, any existing data in those fields will be removed (and cannot be retrieved). You may want to use this option if, for example, you want to update specific Personal Info fields for a batch of contacts as part of the upload process.
6. Clicking << Remove will remove all selected interests.
To add interests:
- Select the interest(s) to associate with the contacts you're uploading; there are two ways to do so:
- Select existing interests - Any existing interests are listed in the Available Interests box. To use these, click to highlight one or more and then click Select >> to move them to the Selected Interests box.
TIP: To select multiple at once, hold Ctrl or Shift and then make your selections.
- Create new interest(s) - At the bottom of the dialog is an area enabling you to add an interest on the fly. To do so, give it a name, select the folder where it should reside, and then click Add. The interest displays in the Available Interests box, where you can now click to highlight it and click Select >> to move it to the Selected Interests box.
TIP: To remove an interest, select it in the Selected Interests area and click << Remove. It will move back to the Available Interests area.
- The interest(s) you're going to associate to the contacts are listed in the Selected Interests box. After verifying this is accurate, click Upload.
A confirmation message displays noting that your contacts are being uploaded. You'll receive a confirmation email when your upload is complete. Click Click Here to view the results in your Upload History (view by navigating to Contacts > Upload > History).
Advanced method
This method enables you to associate interests in a more granular fashion: to all uploaded contacts, to only new contacts, and to existing contacts. The best part is you can split interests into these three buckets. For example, you can associate some interests to all contacts, a few to only the new contacts, and even a few specifically for existing contacts.
NOTE: Keep in mind the following:
1. You must select at least one interest for All contacts or New contacts before uploading.
2. Any interest added to All will be assigned to both New and Existing contacts when uploaded.
3. You cannot add an interest to New or Existing contacts that is already in All contacts.
4. You cannot place an interest into All contacts that is already in New or Existing contacts.
5. Selecting multiple interests from each group and clicking << Remove will remove all selected interests.
To associated interests via this method:
Click Show Advanced Options at the bottom right of the dialog to expand additional options.
Now:
- Determine which interest(s) you want to associate to each group: All, New, or Existing. There are two ways to do so:
- Select existing interests - Any existing interests are listed in the Available Interests box. To use these, click to highlight one or more and then click All >>, New >>, or Existing >> to move them to the appropriate box.
TIP: To select multiple at once, hold Ctrl or Shift and then make your selections.
- Create new interest(s) - At the bottom of the dialog is an area enabling you to add an interest. Specify a name for the interest, select the folder where it will reside, and click Add. The interest displays in the Available Interests box, where you can now associate it to a group.
TIP: To remove an interest, select it in the Selected Interests area and click << Remove. It will move back to the Available Interests area.
- The interest(s) you're going to associate to each group of contacts are listed in their associated boxes. After verifying they are accurate, click Upload.
Result
A confirmation message displays noting that your contacts are being uploaded. You'll receive a confirmation email when your upload is complete. Click Click Here to view the results in your Upload History (view by navigating to Contacts > Upload > History).
Understanding contact upload data files
To send messages via Thrive Marketing Professional, you must have -- at a minimum -- the email addresses of the people with whom your organization wants to communicate. In Thrive Marketing Professional, each email address is the basis for a contact.
Uploading is the process that takes data from either a file or a list of email addresses, and creates contacts in Thrive Marketing Professional. This is done using a delimited text file (usually created in Microsoft Excel and usually the delimiter is a TAB or |) that includes email address and, optionally, other personal information (e.g., first name, last name, organization name, membership date).
How much data should I upload?
While an email address is required, having additional data to do personalization and targeting is an extremely good practice to embrace. You don't want to take every field you have and upload that into Thrive Marketing Professional, but select a meaningful data set that gives you options.
Every field you upload can be used to personalize your message to your contacts. The appropriate use of personalization is a great way to engage your reader. You can, of course, put personalization codes inside your messages, but did you know you can even personalize your subject line and even the friendly from? These are great opportunities for you to create next-level messaging experiences.
This additional data can also be used to create target groups to use to send your messages to. Every additional piece of data gives you another way to segment - or "slice and dice" - your own data.
Header rows
Thrive Marketing Professional doesn't use the header row to extract incoming field names, so it's best if you remove it. Not doing so, however, won't cause a problem because that row will be bypassed during the upload. You will create a data format to map which incoming column goes to a Thrive Marketing Professional field.
Blank columns
Remove any blank columns in your data file. Unhide any hidden columns so you know what's contained in the worksheet. If a blank column is in the data file, Thrive Marketing Professional will interpret that as a column with the expectation that it will be mapped to an existing Thrive Marketing Professional profile info field.
As part of the contact-upload process, Thrive Marketing Professional presents only those data formats that have the same number of fields as your data file has columns. This means that a data file with five columns of data and two blank columns would be considered as seven incoming columns. Thrive Marketing Professional will present all data formats that have seven fields in the format.
Blank fields
As great as it would be to have every piece of data we need for every contact, that's not always possible. If a field in the data file is blank, Thrive Marketing Professional will bypass it.
Hidden columns
Make sure that you're aware of any hidden columns in a worksheet. Unhide all columns and then remove those that you don't want to upload to Thrive Marketing Professional.
Special characters
If your data file contains fields with special characters (e.g., a letter with an accent, alternative punctuation, etc.), this may cause challenges down the road, either in creating target groups or in rendering the data when used as a personalization field. Being mindful of special characters is just something to be aware of during your testing.
File formats
If you're creating this file using an export option from another system, be sure to specify that this is at tab-delimited text file format. Other text file types work too, but tab-delimited is the standard.
File names
If you're planning to use the contact upload feature on a regular basis, it's well worth your time to devise a file-naming convention. This should be used by all Thrive Marketing Professional users so that you have consistency. A very common format is YYYYMMDD DescriptiveWord1 DescriptiveWord2 (optional) WhereUsed.
Some examples:
- 20160113 Members Active
- 20161113 Invitees - Emeritus Staff - Annual Lunch
- 20161113 Students - 4 Year - Graduate May 2016
Alternatively, if you are more project focused, you can lead with the event or project label and then add more after that. For example:
- Annual Meeting 2016 - 2015 Attendees - Early Bird Discount - 20160113
- New Product Launch - NP100-01 - Dealer Network Webinar - 20160113
- 5K Run - NY Runners Club invite - 20160113
In addition to creating a good process that everyone can adhere to, a well-crafted file name will also provide visibility as to "what file was loaded when" on the Upload History page.
Tools you can use - Microsoft Excel
The most common data preparation tool is Microsoft Excel. Most mature systems have a feature to export to Microsoft Excel. Once your data is in Microsoft Excel, you can sort it, filter it, and massage it to ensure it's what you want to upload to Thrive Marketing Professional.
Additionally, you can use Microsoft Excel's many functions to synthesize new data by combining cells. For example, if you have a First Name column (B2) and a Last Name column (C2), you can concatenate them - with a space in between - into a single column, for Full Name, by using a formula like this:
=B2 & " " & C2
View contact upload history
After a list of email addresses is uploaded, it becomes a Target Group in the Interest folder.
To see the details of any uploaded list:
- Navigate to Contacts > Upload > History.
See View Contact Upload History for more information.