File Requirements for Matched Lists or Lookalike Generation
This document defines file formats that are supported for generating matched lists or lookalike audiences. For the same, files will need to be formatted as .csv (optionally gzipped) 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)
For users who are generating matched lists with CSV files and also using Excel to view/edit the CSV files, please follow the instructions linked here.
Supported Column Details
Zeta accepts email address in US and international formats. Zeta accepts up to 5 email addresses as separate attributes.
Up to 5 clear text email addresses may be considered in a single input record, in the matching waterfall order of: email, email1, email2, email3, email4.
E.g., If there is no match for “email”, the next field considered for matching is “email1”, and so on.
Zeta accepts email address in US and international formats in md5 hash format.
Zeta accepts email address in US and international formats in sha256 hash format.
Cookie ID for a visitor from Zeta integrated site.
Cookie ID surfaced in the bidstream of our Demand Side Platform (DSP).
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.
First line of the postal address
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.
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.
Mobile Advertising Identifier (MAID) is used to target Mobile phones and tables using Android as GAID (Google Advertising ID) and IOS as IDFA (Identifier for Advertising) .
Zeta accepts 10-digit phone numbers.
Phone numbers must include a US country code to be used for matching; 1 must precede a phone number in the United States.
The Matched List won’t accept any non-numerical characters such spaces, periods, etc.
Zeta accepts up to 5 phones as separate attributes.
Up to 5 phones may be considered in a single input record, in the matching waterfall order of: phone, phone1, phone2, phone3, phone4.
E.g., If there is no match for “phone”, the next field considered for matching is “phone1”, and so on.
The name and postal match can only be performed if all the required/mandatory fields (marked with a *) have values inserted:
and at least one of city, state, or zip
If the aforementioned requirements are not met in the input file, the (name + postal) stages match process will yield 0 results.
Unless the fields matched upon are (name + postal), only one field needs to be in the header of a matched list seed file. However, a seed file’s header may contain multiple fields. Even so, only one populated field per record is required to yield results, with the exception of the record only containing (name+postal).