Select a CSV file to validate prior to an SFTP import. This will validate against the required formatting for event or profile imports.
This is most useful when building out an SFTP import workflow and confirming the data structure of the first few files before moving to a scheduled job.
This validates the following:
- Presence of a required identifier (email, phone number or External ID).
- Validity of email or phone formatting.
- Presence of required headers for event imports or profile imports.
- Valid timestamp formatting for event imports.
- Valid consent strings.
- Valid consent timestamp formatting.
- Presence of � character (Unicode replacement character).
Select a file type (required). Optionally, choose to save line-level validation errors to an output file. This is is only available in Chrome. Header errors and row numbers (for the first ten rows) for rows with issues will be displayed on this page.