CSV import FAQs

My segment is showing a lower count than the count of my import

This issue is likely due to one of the following.

Duplicates

Vero will still try and process every line of a CSV, even if there are duplicates, it will also display the number of rows processed on the import page.

The best way to determine if you have duplicate users in your CSV is by using a tool in the spreadsheet application you are using. For example, Excel has a "remove duplicates" tool that will automatically do this for you.

Users without an email address

By default, the id or "identifier" is the key field to identify a user in Vero. If users are imported with id and no email, those user profiles will be updated. However, if your user does not have an email property they will not display in a segment. You can't segment on profiles that have no identifiable way to message them (email or push token).

Receiving a 500 error after selecting a file for import

This issue occurs when attempting to import a CSV that is not encoded in UTF-8. Often we see files being saved with a Latin character set (ex: ISO-8859-1). At this time, Vero only accepts files with UTF-8 encoding.