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 below.
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.
We intentionally choose this CSV header in Italian to better exemplify how matching of column names and user attributes works.
Note: large CSV files might take up to 10-15 minutes to be synchronised with our storage systems.
To import dates (like birthdate) please make sure the value is in seconds. If you’re not sure about that check this website: EpochConverter
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.