This post is a part of the Marketing Cloud Email Specialist Certification Tutorial Series
SFTP
Marketing Cloud offers these advanced options for using FTP to import your large subscriber data files into a subscriber list:
- The basic FTP option allows you to upload files to our FTP site and import them through Marketing Cloud and the Import Subscriber wizard.
- The encrypted FTP option allows you to use encrypted import files for greater security.
- The enhanced FTP option provides the greatest level of security, as it gives your organization its own FTP directory.
Format Requirements
- Format: When you create the file of subscriber data to be imported into the application, save it as a tab-delimited TXT file or a comma-delimited CSV file. (Many applications offer these formats as “save as” options.)
- Header row: A header row (a row at the top of the file labeling the columns in the file) is recommended for mapping purposes. If the labels in the header row do not exactly match the names of the attributes in your account, the application cannot map the data for you by default.
- Attribute data type: If you’re importing subscriber attributes, the data in the import file must be of the same data type (text, date, or numeric) as the attribute field in the application.
- Attributes with restricted values: When importing subscriber data into attribute fields that restrict the possible values, the import data must exactly match one of the values defined as allowable for that attribute.
- Preferences: If you’re importing subscriber preference data, your import file must use only the values Yes and No.
Check the other parts of the tutorial series – Marketing Cloud Email Specialist Certification Tutorial Series
Tutorial Series
Thanks for all the marketing cloud resources. You rock!
LikeLike