How to Import existing users

You are here:
Estimated reading time: 2 min

This article covers how to import existing users into our platform. There are 3 ways to add email addresses into the system, available in Users > Import Users.

Ways to Import Users

  1. Manually copy and paste emails, one per line
  2. Import from Mailchimp (requires integration, using a MailChimp APIKey)
  3. Upload CSV files

All those options are available under Users > Import Users

Using Copy Paste

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

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.

Important:

  • 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.

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

Choose your local CSV file and upload it for Import

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.

Important:

  • File must be encoded as UTF-8.
  • 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

Import Options

Choose a recipient list (default is main list)

When importing users they will be added by default to your main list. If you want to use a different list you might need to create one first and select that during import

Add/update 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.

Examples:

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:

Was this article helpful?
Dislike 0
Views: 47