File Requirements for Matched Lists or Lookalike Generation
This document will review the file format requirements that are supported for generating matched lists or lookalike audiences and how to upload them successfully.
Files will need to be formatted as UTF-8 encoded text files with headers designating each column.
Column headers are limited to a maximum of 256 characters
Column values are limited to a maximum of 1024 characters
Column headers are case-insensitive
Max file size: 1GB (drag and drop) and 10GB (SFTP)
Supported Columns Details Below
Zeta accepts email address in US and international formats. Zeta accepts up to 5 email addresses as separate attributes. Additional Email addresses must be provided with column headers as Email1, Email2, Email3 and Email4
Zeta accepts email address in US and international formats in md5 hash format.
Cookie Id for a visitor from Zeta integrated site
Zeta accepts first name and first name initial, with or without accents. Initials can be provided with or without a period.
Zeta accepts full last names with or without accents.
Zeta accepts full city names as they normally appear.
Zeta accepts full names of US and international states and provinces, as well as the abbreviated versions of US states.
Address Line 1
First line of the postal address
Address Line 2
Second line of the postal address
Zeta accepts US and international zip and postal codes. US zip codes may include a 4-digit extension as long as they are separated by a hyphen. The extension is not required and will not further improve the match rate.
Minimum groupings required
["first_name", "last_name", "address_line_1", "address_line_2", "city", "state", "zip"]
Example File can be downloaded here