Data Normalization

This topic shows how to perform data normalization for the Facebook connector.

The following table lists the data format layout information for the Facebook connector:


Key	Guidelines	Remarks
`EMAIL` criteria: email address	Hashing required Trim leading and trailing white space and convert all characters to lowercase.	Data normalization and hashing requirement is taken care by Link connector.
`PHONE` criteria: phone numbers	Hashing required Remove symbols, letters, and any leading zeroes. You should prefix the country code if `COUNTRY` field is not specified.	Data normalization and hashing requirement is taken care by Link connector except country code validation.
`GEN` criteria: gender	Hashing required Use these values: `m` for male and `f` for female.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`DOBY` criteria: birth year	Hashing required Use the `YYYY` format from `1900` to current year.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`DOBM` criteria: birth month	Hashing required Use the `MM` format: `01` to `12`.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`DOBD` criteria: birthday	Hashing required Use the `DD` format: `01` to `31`.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`LN and FN` criteria: last and first names	Hashing required Use `a-z` only. Lowercase only, no punctuation. Special characters in UTF-8 format.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`FI` criteria: first name initial	Hashing required Use `a-z` only. Lowercase only. Special characters in UTF-8 format.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`ST` criteria: U.S. states	Hashing required Use the 2-character ANSI abbreviation code, lowercase. Normalize states outside U.S. in lowercase, no punctuation, no special characters, no white space.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`CT` criteria: city	Hashing required Use `a-z` only. Lowercase only, no punctuation, no special characters, no white space.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`ZIP` criteria: zip code	Hashing required Use lowercase, no white space. Use only the first 5 digits for U.S. Use Area/District/Sector format for the UK.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`COUNTRY` criteria: country code	Hashing required Use lowercase, 2-letter country codes in ISO 3166-1 alpha-2.	User needs to prepare their data as per given data format. Hashing requirement is taken care by Link connector.
`MADID` criteria: mobile advertiser ID	Hashing NOT required Use all lowercase, keep hyphens.	User needs to prepare their data as per given data format.