Hello there! After a file import from SFTP to a data extension in Automation Studio, the Data Extension Import Notification email lists the results, but I haven't been able to find anything in the AS documentation defining the "Skipped" scenarios.
https://help.salesforce.com/s/articleView?id=mc_as_use_an_import_activity.htm&type=5&language=en_US
Most are pretty self-explanatory, but can anyone validate my assumption that "Skipped" means I had duplicate primary keys in my file? I'm using the "Add and Update" method.
- Inserted: successfully created a new record based on primary key
- Updated: successfully updated an existing record based on primary key
- Skipped: duplicate primary key in my file (?)
- ValidationErrors: check attached file for missing data, unexpected field types, etc.
Thanks!
5 answers
Skipped :
If you select the skip rows with bad data, you are skipping bad data :)
In advance options:
it's asking you if you want to skip the import if any of the conditions?