The CSV upload feature allows you to upload a list of contacts to your audience and create a static segment that includes those contacts.
Use cases for this include:
- Create a segment of contacts to send a blast campaign.
- Backfill a list of contacts who are not already in your Regal Voice audience.
- Enrich the profiles of your contacts by adding new contact properties or updating existing ones.
To upload a static segment, navigate to the Segments page and click on '+ New segment' in the upper right hand corner of the screen.
From here you'll be taken to the 'Set Up New Segment' page where you can choose the the criteria for your upload and select the journeys (if any) you'd like to trigger off of this upload.
Note: Uploading a CSV may generate 'Subscribed', 'Unsubscribed', and/or 'Contact Created' events. If you have any journeys that use those events as triggers, they will be triggered unless you specify under 'Trigger other journeys from this segment?'
CSV formatting and required fields
Formatting Note for CSV Uploads
Below are descriptions of accepted properties. The only required properties are contactPhone, or email, or externalId.
Click here to view an example CSV.
If you're uploading a Segment containing non-US numbers, be sure to include a "+" before the digits in the contactPhone column - any phone number without a "+" will attempted to be imported as a 10-digit US number.
By default, all values will be ingested as string type, which may cause problems with using those values in Journeys. You can explicitly indicate the data type for any column of values by including an additional header row. See an example CSV with an additional data header row here.
If uploading a csv with this additional data type header, you must also check the box that says “My file contains an additional header…”
Supported data types are BOOL, FLOAT, DATETIME, and STRING. Columns without a data type in the header, or values that cannot be converted to the specified type, will default to String type.
BOOL: used for boolean values. Can accept true and false, and is not case sensitive.
FLOAT: used for numeric values, including integers and decimals.
DATETIME: used for date properties. Acceptable formats include:
- yyyy-MM-dd HH:mm:ss ZZ
- yyyy-MM-dd HH:mm:ss
- yyyy-MM-ddTHH:mm:ss.SSSZZ
- yyyy-MM-dd
STRING: used for text.