This article covers how to import existing users into our platform. There are 3 ways to add email addresses into the system:
- Manually copy and paste emails, one per line
- Import from Mailchimp (requires integration, using a MailChimp APIKey)
- Upload CSV files
1.Manually copying users
Just copy and paste a list of email addresses, one per line.
Note: make sure the email addresses are valid, and have no typos, like yahop.com
2. Import users from Mailchimp
Importing from Mailchimp will copy an existing list of users to our system. Note that only subscribed emails will be imported.
If you added your Mailchimp Api Key in the integration section, you just need to select the list you want to import and then click import list.
- we only import email addresses (no first / last name)
- only first 10.000 emails are imported. If you have a bigger list it’s better to export it manually for importing into our service
- large lists might take up to 10-15 minutes to be synchronised with our storage systems.
3. Upload CSV file
If you have a CSV file you can upload it to our system, and also save some other attributes (name, location, gender).
The CSV should contain a header row describing the fields, like below. Make sure it’s encoded with UTF-8 without BOM.
Select the file from your computer and upload it.
Match CSV columns to user attributes.
We try to determine CSV delimiter used, but you can select the right one.
In the following example we have multiple columns in the CSV, but we will only save Cognome (last name), Nome (first name) and Indirizzo email (email address). All other columns will be ignored.
On the right columns you will see a preview of the first lines available in the file.
Note: large CSV files might take up to 10-15 minutes to be synchronised with our storage systems.
- Values in the CSV file must be casted to the right value for matching user respective.
- Please use Pre-validate button button to have a first check if data seems valid or not. Look for the warning triangle to make sure you have the right data
- To import dates (like birthdate) please make sure the value is in seconds. If you’re not sure about that check this website: EpochConverter
- Also boolean values can be either true, false, or 0,1
Add new attributes to imported users
When importing new emails, we only add default values to these emails. You might want to add various values for each import, and here’s how you can do it.
For example you want to subscribe all emails to newsletter, or set acquisition source to a specific value (if you have your emails collected from offline shops). Note that these values will overwrite any existing ones! Some attributes are not overwritten and will be removed: “createdOn”, “updatedOn”, “email”, “isSpam”, “isHardBounced”.
Note: when importing users and set isSubscribed true, existing users who previously clicked isSpam or hard bounced will not be updated to true!
You can save these new attributes as a set to add them later with another import.
Check import results
Imports done asynchronously are reported by email and inside Account History. If you need to see the results of the import you can go to your Account History where you’ll have entries like the one below: