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.
The mapping step allows you to configure each of the list's columns and define its type.
Automatic type detection
The interface analyzes the first 1,000 rows of your source file to suggest the best data type for each column.
These suggestions are designed to assist you and do not count as a final validation. It is essential to review and adjust these types to ensure they align with your full dataset and intended use.
Recommendations
| Type | Source file value | Value in list | Recommended for |
| Text | PARIS 24/05/2025 04009 | PARIS 24/05/2025 04009 | A text field in the source file A field of another type in the source file to be inserted as is (for customization, for example) A decimal number with a Comma separator |
| Integer | 6050 04009 | 6050 4009 | An integer field in the source file to be normalized (removal of 0's before the 1st digit) for use with numeric operators (e.g. 'greater than') |
| Decimal number | 33.45 | 33.45 | A decimal number with separator '.' for use with numeric operators (e.g. 'greater than') |
| Boolean | true false | true false | A boolean type field to be inserted at true or false. /!\ The value in the final target will be 0 or 1. |
| Date | 20250130 01-30-2025 30/01/2025 | 2025-01-30 | A date type field to be stored in YYYY-MM-DD format and used with date operators |
| Date and time | 20250130 06:30:00 2025/01/30 06:30:00 | 2025-01-30 06:30:00.000 | A date type field to be stored in YYYY-MM-DD hh:mm:ss:.msms format (display without micro-seconds in the interface) and to be used with date operators |
Rows not respecting column types will be excluded when importing contacts.
Conclusion
Column types determine import tolerance, data formatting, and your future ability to manage and segment your contacts effectively.