When a CSV file is processed certain rules are applied:
- CSV files with unique names are processed and loaded into the platform
- If the platform receives a file e.g. filename_20201117095800.csv if the platform receives filename_20201117095800.csv again - it won't process the file as it has already seen this.
- Inside the CSV columns will represent certain items like phone and email
- If a phone or email is repeated in the file the platform will only send a survey to the contact only once. It ignores multiple occurrences of the contact. This check is case sensitive - .e.g. tom@gmail.com is considered different to Tom@gmail.com
- If a column represents a mobile number AND a country code is set in the CSV setting the platform will put the number mobile into an international format for that country.
- Typically a CSV file corresponds to a campaignID but columns in a file can be used to make a decision of what campaign the file is mapped to
- e.g. if a column contains a set of variables these can be used to assign that line to a certain campaignID. This isn't configurable via the portal. If you require this please raise a support ticket
- Columns headers can be used in the platform to represent Custom Contact Variables where plain text is present
- If a column header is Account_type the CCV is {{{Account_type}}}
- Physical CSV files (transferred via SFTP) are deleted after 10 days