ECOA File Formatting

Help Center   ❯  FreshAddress Client Portal   ❯  Format Your File

---

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.

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.

You are welcome to use a file name of your choosing, however referencing the quantity of records will be helpful for our team’s QC of your data 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 20 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

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

• UNIQUE-ID
• EMAIL
• CODE
• NEWEMAIL

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 Client Services Team either via email or at 1-332-245-4415.