Here’s what you’ll need to import contacts into Roster.
The email addresses of the people for whom you want to gather social data.
A blank sheet in a spreadsheet program like Microsoft Excel or Google Sheets, saved or exported as a comma-separated value (CSV) file.
**You can also download this CSV template and fill in the relevant columns.
If you have additional data points you'd like to upload (like Purchase Info), please read the "Importing Custom Properties" section of this article prior to uploading!
Prepare For Import
To prepare your file for import, follow these steps.
In a spreadsheet program like Excel or Sheets, open your blank worksheet.
Create and label the columns for the email addresses and names. ( Note: an email or social handle is required to upload)
Validations: Ensure you have valid data for each field in the CSV.
Email: should be a valid email
Social Handle: ensure it's just the social handle without the URL or extra slashes etc...
Date: ensure dates are formatted Month/Day/Year
And check all other columns to ensure the data you're importing is clean.
4. Paste the information into the relevant fields in the spreadsheet.
5. Save the file in CSV format. This option can usually be accessed from the File menu in your spreadsheet program, labeled as “Export as .CSV” or “Download as .CSV”. Different spreadsheet programs will vary a little bit. If you use another file type, we won’t be able to process the file.
6. Any values that have commas should be enclosed in quotation marks to be a valid CSV file and keep the columns and rows correctly inline. If you save the file correctly as a CSV, the spreadsheet program will do this for you.
Importing Custom Properties
Roster now supports uploading additional data beyond basic customer information... we call these Properties. Custom properties are fields you set up for your brand to further organize or segment your contacts. You might want to upload additional customer data into Roster, such as Amount Spent, Number of Purchases, or Last Purchase Date. Essentially any information that will help you know your customer better. Additionally, if you are uploading a list of your current ambassadors, you might have additional data to include about them that you want automatically added to their profile.
*Be sure to add the Custom Properties within Roster prior to uploading your list! You can do so from the Contacts page or under Settings > Properties. If you import a CSV with additional columns that are not mapped to supported fields, then it will still be flagged for review by our team.
When mapping values to custom properties, it's typically the same as any other CSV field mapping.
Note: Checklist Custom Property Mapping: If you are mapping custom property values to a checklist field type, then the value in the CSV column needs to be enclosed in quotation marks and be a valid array of values. For example, if your property name is "Favorite Sports" the value should look something like this: "["Cycling", "Hiking", "Running"]" . Or if you just have 1 value it should look like this: "["Cycling"]"
Now that you’ve completed these steps, you’re ready to import the CSV file to a Roster list!
Map Existing Discount Codes to Contacts
Currently we don't have the built-in functionality to map CSV columns to Discount Rules and then to Contacts. However, this can be done with some help from our support team.
First what you need to do is include the discount code in the CSV as a column to have each code associated with an email address in the CSV. Ensure that each upload ONLY includes discounts codes for a single discount rule that already exists in the system.
Then upload the CSV, map the other columns you have and leave the discount code field unmapped.
Once uploaded, reach out to our support team requesting that we complete the import for you. Indicate which discount rule the codes should be associated with and our team will ensure the discount codes are imported to the contacts as well as the other mapped fields in the import.