Contact Fields in the eSputnik System

This article contains instructions on how to import a file with the contact list into your account in the eSputnik system.

Preparation

The file formats that are supported for import are: xlsx, xls, csv, and txt.

Before you import your contact list into the system, make sure to check the following:

  • Available email and/or phone number are a must for import.
  • All contacts must be saved in one worksheet (Excel) and organized into columns. If the file contains two or more worksheets, the system will not process them: only the contacts from the first worksheet will be imported.

All contacts must be saved in one worksheet

When you import contacts into the eSputnik system, map the columns in your import file to the fields in the eSputnik contact list, using the below dropdown menu. The mapped columns are highlighted green.

Matched columns are highlighted green

Important: fields with errors will not be imported into the system.

Standard Fields

By default, the following standard fields are available for each account:

1. Text Fields

Text fields are designed to include all the available customer data in order to personalize emails and segment the database. They consist of First Name, Last Name, and all columns of the Address fields.

Text fields

  • First Name

This field can contain up to 50 characters (text only, no special characters, for example, % ^ * | ~ ). It is used to personalize emails, and can be put both in the body of the message and in the subject line.

  • Last Name

Similar to First Name, this field can also contain no more than 50 characters.

  • Address

The Address fields can consist of several columns with the full postal address of each contact. The field supports text and numbers, and can’t include special characters.

You can add to the field the following categories: Country, Region, City, Street, Post Code, etc. Each category should be organized in a separate column.

Address field

  • Language

The Language field is to be filled for contact base segmentation and sending multilingual campaigns. It supports text coded according to the international standard of RFC 5646 Language Tags:

"es," "en";

"es-AR" (Spanish, Argentina), "en-US" (English, USA).

These fields are used to create dynamic segments. For example, you need to select all London residents and notify them of the opening of a new store. If you have filled a City column, you can create the segment choosing the necessary condition:

City column

2. Email

This is the main field used to send emails. There is one email line available for each contact. Make sure the email address has no spelling mistakes (gmeil.com, mail..com, etc.). If you want to specify several emails, you may create an additional field, but campaigns will be sent only to the address specified in the main field.

3. Phone Number

The Phone Number field can contain only numbers; no text or special characters are supported.

These contacts are used to send SMS and Viber messages. The number should be specified in the international format:

380955547708

447911123456

0207183 8750

1229501112325

Note: you can import only phone numbers valid in the country that you have selected while registering in the system. If you want to import phone numbers valid in other countries, contact our support.

4. Date of Birth

This field supports the following formats: yyyy-MM-dd, dd/MM/yyyy, dd.MM.yy, dd.MM.yyyy.

Date of birth

Important: this format is supported for a file import only. For an import via API, use only these formats: YY-MM-DD, DD/MM/YY, DD.MM.YY.

5. Contact Key

This field is designed for external contact identifiers and can be useful when you import a database and want to keep the contact ID from the original database.

6. Gender

When importing the contact base, you can choose between the two options - M (male) or F (female) - set by default in the system. If you want to add more options, go to Personal Profile > Settings > Additional Fields > Gender.

Additional fields

Es Contact ID

An internal contact ID is assigned by the eSputnik system to each contact after the import. It consists of numbers only.

Additional Fields

If standard fields are not enough to include all the necessary data, you can go to Settings and add additional fields. You can add unlimited number of fields in any order.

Additional fields

Choose Add list, type the title of the list and save it.

Add additional list

To add new fields to the new list, click on Add field, fill in Name, and choose a field type from the dropdown list.

Add field

In the field type, you can choose one of 8 available options:

  • Text box;
  • Text area;
  • Number;
  • Fractional Number;
  • Date;
  • Date with time;
  • Dropdown list;
  • Checkbox list.

Text box

Can include up to 1,000 characters, both text and integer numbers. Special characters (for example, % ^ * | ~ {) are not supported.

Text area

Can include a large amount of data of up to 5,000 characters, both text and integer numbers. Special characters are not supported.

Use Text box and Text area to specify:

  • position, workplace, etc.;
  • number of employees, number of positions;
  • any additional data needed to segment your contacts.

Number

Supports only integer numbers in the range from - 2147483648 to 2147483647. Can be used for email personalization and segmentation, for example, based on the amount of bonuses a customer has accumulated.

Fractional Number

Supports fractional numbers.

Date

The supported format: YYYY-MM-DD.

There is a Regular Date option designed to specify a creation date, anniversary, etc.

Regular date

Tick the corresponding box to use this date to create dynamic segments:

Use Regular Date to create dynamic segments

Date with Time

The supported format: YYYY-MM-DDTHH:mm

Dropdown List

You can add unlimited number of options, but choose only one of them when creating a contact profile.

Dropdown list

Checkbox List

You can add unlimited number of options, and choose any of them when creating a contact profile.

Checkbox list

Important: you can also add additional fields right when you map imported columns to the fields in the system.

How to add additional fields during contact matching

File Example

To see how contacts can be organized in an Excel worksheet, download our file example. It contains standard fields: subscriber email, first name and last name. You can also add unlimited additional fields, such as phone number, address, etc.

Read the article on how to import a file into the eSputnik system. Once you import a file into the system, a confirmation email with the import results will be sent to your email address.

Import results for your account