client center

B2B Appending File Format

Create two separate files:

  1. Your corporate postal records* that are missing emails  [*Note: Standard contracts include one file in and one file out. Any stitching and/or splitting of files may be subject to a nominal fee. Please direct any questions to your Account Executive or Project Manager.]
  2. As your project nears the messaging phase, we will request an unsubscribe file detailing the email addresses that have previously opted-out from your email communications. (For additional information regarding unsubscribes, please see FAQsView formatting instructions for your Unsubscribe List

Format the list designated in #1 above as a tab delimited text file (*.txt) with a header row. Please do not include quotes or other text qualifiers. The following fields are required unless otherwise noted:

  • UNIQUE-ID
  • FIRST NAME
  • MIDDLE NAME (optional)
  • LAST NAME
  • COMPANY NAME
  • COMPANY ADDRESS1
  • COMPANY ADDRESS2 (optional)
  • CITY
  • STATE
  • ZIP

Please use the following naming convention for your file:

[FreshAddress job number]_toprocess_[record count].txt
Ex: 1010_toprocess_500700.txt

Excluding brand fields or any other extra field necessary to process your job, your input file may contain up to 3 additional fields (which will be returned with your results for no additional fee).

Your file should not contain any unnecessary sensitive information of any kind, such as social security numbers, credit card numbers, financial information, birth dates and medical information. Files that contain any such data will be destroyed upon receipt.

FreshAddress will segment your results by engagement and deliver them in 3 tab-delimited text files with the following fields:

  • UNIQUE-ID
  • FIRST NAME
  • MIDDLE NAME (optional)
  • LAST NAME
  • COMPANY NAME
  • COMPANY ADDRESS1
  • COMPANY ADDRESS2 (optional)
  • CITY
  • STATE
  • ZIP
  • EMAIL

NOTE: Improperly-formatted lists will be charged a Data Formatting Fee and may cause delays in processing.

If you have any data formatting questions, contact the FreshAddress List Processing Team either via email or at 617.965.4500 x 222.