Welcome to ReSci!
When you're getting started, it's important to make sure that your users' data is imported correctly from the Mailchimp platform into Cortex. This article shows how to amend the standard subscribed users file from Mailchimp and upload into Cortex.
Below is an example of the data that is included in a Mailchimp subscribed users list.
Step 1: Delete the columns with the data we don't need.
Step 2: Rename the column headers with the supported names.
- Use the formula =CONCATENATE(col1," ",col2) to combine your first and last name columns with a space between them or view: How to merge First Name and Last Name to full_name.
Step 3: Format date to yyyy-mm-dd
Step 4: Save as a "Comma Separated Values (.csv)" file
Step 5: Upload
- Now that the spreadsheet is ready, go to your Cortex admin to upload the list.
- Go to the Smart Segments page from the menu on the home page. It will be under the Audience section of the menu.
- Scroll down to Your Segments section and select Upload.
- Now you'll be in the New List page where the list can be named and the .csv uploaded.
- Alternatively, you can copy and paste the data from your excel sheet if it is a short list.
What about my other files?
- Unsubscribed: This list should be uploaded with the UNSUB_TIME column header changed to "date_unsubscribed".
- Cleaned: This list can be ignored or uploaded with the CLEAN_TIME column header changed to "date_unsubscribed".
- Non-subscribed: The users in this list may not be aware their email address is in your mailing list. If you want to include these users as subscribers, you may want to consider reaching out to them with special targeted campaigns to reintroduce your brand.