Introduction
The Contact lists tab allows you to create two types of lists:
- Static lists: Can be updated manually, either individually or from a file.
- Dynamic lists: Update automatically by retrieving a file from an SFTP server.
Once the contact fields have been defined, the next step consists in configuring each columns of the list.
Edit columns
Column mapping is pre-filled according to the list configuration parameters already filled in, as well as the file analysis.
Primary key
- primary key(s) define the uniqueness of your contacts;
- it's necessary to choose at least one;
- the contact fields selected are automatically configured as primary keys, but can be deselected.
For more information on primary keys, please refer to the article Understanding primary keys.
Must be filled
- a column identified as mandatory must contain values for all lines in the file;
- a column defined as a primary key is necessarily mandatory.
Column's name
- corresponds to the name of the column in the list;
-
is pre-filled with the column name in the source file, replacing spaces with underscores and removing special characters.
- If the source file does not contain a column name, the name is generated auomatically as follows: COLUMN_1, COLUMN_2 etc.
- If the source file contains columns with the same name, the names of these columns are suffixed with _DUPLICATED_0, _DUPLICATED_1, etc.
- the fields selected in the contact keys step are renamed EMAIL, MOBILE and COUNTRY_CODE and cannot be renamed;
- column name must start with a letter, be in uppercase and without spaces or special characters (except for underscore).
- all column names must be filled in, unique and not correspond to a reserved value:
"CDE"
"CODE_ENVOI"
"DCALCUL"
"DDERNIEREREACTION"
"DMAJ"
"E"
"EMAIL_VALIDATED"
"ENV"
"I"
"ID_MAILING"
"ID_MAILINGTELMOBILE"
"ID_UE_ENVOVOI"
"ID_UT_ENVOI"
"ID_TYPECONSENT"
"ID_TYPOLOGY"
"ID_VERSION"
"IDCOL"
"IDENVOI"
"IDU_EMAIL"
"IDU_TELMOBILE"
"GRP_TEMOIN"
"M"
"MM_SENDER_DOMAIN"
"MOBILE_INTL"
"ORDER"
"R"
"RG"
"ROW_ID"
"SEGMENT"
"SID"
"TELMOBILE"
"UG"
"UPDATED_AT"
Type
- defines the type of value this column should contain (e.g.: text, integer...);
- is pre-filled with the type detected in the source file, but can be edited to align with the full dataset and the intended use.
To better understand, please refer to the article How to choose the column type.
Two pieces of information are available to help with column configuration:
- Source : name of the column in the source file;
- Preview : sample values in source file.
Conclusion
Once this configuration is complete you can move on to the next step and Configure import for a dynamic list or validate the static list summary: Understand the summary step.