client center

ECOA File Format

Create two separate files:

  1. Your entire undeliverable (bounce) or inactive file*.  [*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. Providing the following fields will yield the best results:

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

Otherwise, the minimum required fields are:

  • UNIQUE-ID
  • EMAIL ADDRESS

NOTE: Not providing postal information may result in lower match rate.

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 input 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
  • EMAIL ADDRESS
  • FIRST NAME
  • MIDDLE NAME (or initial)
  • LAST NAME
  • ADDRESS1
  • ADDRESS2 (optional)
  • CITY
  • STATE
  • ZIP
  • CODE
  • NEWEMAIL
  • ESPENDSCORE *

The following fields will be part of the results if no postal information was provided:

  • UNIQUE-ID
  • EMAIL
  • CODE
  • NEWEMAIL
  • ESPENDSCORE *
    * Only if you purchased the eSpend Score® add-on service

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.