Adding attributes

To add an attribute, go to Tables structure app (Apps > Data > Tables structure).

info

In Actito, you can add new attributes to your database profiles at any time.

To ensure communication consistency, only users with the rights configuration 'Admin' or 'Advanced user' can delete or modify attributes by themselves in the interface.

Choosing the table to be edited

Select the profile table whose structure you wish to modify. Then, click on 'Update'.

Adding an attribute

To add an attribute in the selected table structure, click on the '+ Add' button.

List of predefined attributes

Birthdate

The advantages of using the 'birthdate' predefined attribute to store a birth date instead of creating a normal 'date' type attribute are:

• Actito will calculate automatically the age of the profile. For targeting or personalization, you can select 'all people between 25 and 55 years old'. You will not have to parameter your target with a birth date.
• This date will be used for specific reports such as an age pyramid.

Email Address

The predefined attribute 'emailAddress' is the only field that you can use to send e-mails with Actito.

This field will be created by default as mandatory and unique.

Acceptance rule for an 'e-mail address' field type:

• It must respect the following syntax: xxx@yyy.zzz
  • the xxx value (meaning the user name before the @) cannot contain the following characters (é,è,à,ç,ù,ï...)
  • the zzz value must be part of the international list of authorized extensions
• Please note that:
  • the username can contain following characters 'a -> z', 'A -> Z', '0 -> 9', de '-', '_', '.' and special characters '!#$%&'*+-/=?^_`{|}~'
  • use of an '@' is mandatory
  • at least 1 character is mandatory before the '@'
  • the domain name and the suffix must follow the @
  • the domain name cannot start or end by '-'
  • the suffix must contain at least two characters
  • several dots ('.') cannot follow each other (ex: '...')
• Subdomains are allowed (ex: subdomain.mydomain.com) and accent are allowed in domain names.

Before each sending, Actito will check if the address can be reached (if not, it will be filtered).

Encrypted Email Address

The predefined attributes 'emailAddressMD5' and 'emailAddressSHA256' allow you to encrypt the value of the 'emailAddress' with the MD5 or SHA256 hashes.

These algorithms are useful if you need to communicate email addresses to external tools (through link query parameters, as reconciliation key of an import/export) but do not want to use the clear value for security reasons.

Both 'hash' predefined attributes are special in the sense that they computed by Actito:

• Their value is automatically calculated from the value of the 'emailAddress' attribute.
• Therefore, they can only be added in the profile table contains an 'emailAddress' attribute, and they must share the same properties (unicity, mandatory).
• Users cannot write the value for a hash attribute in the profile table through any mean.
• The hash is calculated on the hexadecimal lowercase value of the 'emailAddress'

For example, here are the hashed values of the e-mail address "support@Actito.com":

• emailAddressMD5 : b87e913e711d2211acffdc7a5b1703f0
• emailAddressSHA256 : 7e413502940e598d242f58f2c71ac09660c093ecbfc03c3f2b8fe68c3a2316ef

First Name and Last Name

The predefined attributes 'firstName' and 'lastName' are simple text fields (max. 64 characters).

By default, the predefined attribute 'lastName' is a mandatory field

Mobile Phone Number

The predefined attribute 'gsmNumber' is the only field that you can use to send SMS with Actito.

Only numbers with international format may be contacted:

• France: +33 6 XX XX XX XX
• Belgique: +32 4XX XX XX XX

The acceptance rule for for a 'gsmNumber' field type is that it can contain the following characters (and nothing else):

• +().- /0123456789 ( Note: the empty space is included)

Mother Language

The predefined attribute 'motherLanguage' is a 'language' field type (2 letters country code, called ISO 639-1 code).

This field will be used to send campaigns to profiles in the correct language.
If you do not have a 'motherLanguage' attribute (because all your profiles are contacted in the same language), you will have to untick the preselected 'language' box at the targeting stage of your e-mail campaign.

Number of Children

The predefined attribute 'nbreChildren' is an integer field type (equal to or over zero).

Postal Address (addressCountry, addressLocality, addressPostalCode, addressStreet, addressNumber, addressBox)

The combination of these fields allows you to stock the partial or complete postal address of a profile.

• The predefined attribute 'addressCountry' is a 'country' field type (represented by the two letters ISO 3166-1 country code)
• The predefined attribute 'addressLocality', 'addressPostalCode', 'addressStreet', 'addressNumber', 'addressBox' are text fields of maximum 50 characters. This allows you to store English postal codes such as SW15 5PU or house numbers such as '41b'.

Profession

The 'profession' predefined attribute is a 'large text' field type (max. 50 characters). No default value is defined in Actito.

Sex

The 'Sex' field can only contain two possible values: M or F (for Male and Female).

Actito does not offer any predefined attribute such as 'civility' (Mr, Mrs, Ms), because calling a young woman 'Ms' is not allowed anymore in some countries.

In personalizations, the gender test will allow the use of the 'sex' field to customize the greeting.

Phone Number

The 'telephoneNumber' predefined attribute is a telephone number field type.

Marketing Consent

The 'marketingConsent' predefined attribute is a Boolean field type.

By default, the 'marketingConsent' is set-up as 'mandatory'.

This attribute is used within the framework of the GDPR to store the consent of a profile to be contacted by marketing campaigns (see here for more information).

Tracking Consent

The predefined attribute 'trackingConsent' is a Boolean field type.

It is used to store the consent of a profile for his behaviour to be tracked when he received a campaign, namely the fact of opening or clicking in a campaign, saving information about their type of device, or reaching goals (see here for more information).

Step 1: Parameters

To add an attribute, you have the choice to either:

• Select one of the attributes predefined by Actito.
  The parameters will be pre-filled based on standards defined by Actito.
  It is highly recommended to choose predefined attributes: for further information go to 'Using predefined attributes'.

  Note: if needed, it is possible to modify some parameters of predefined attributes (for example, the name or whether a field is mandatory). However, the technical name must not be modified.

• Set up the attribute and its parameters by yourself. It is recommended to define every parameters of your attributes.

Parameters to be filled in are as follows:

• Technical name: technical ID for each attribute. It cannot be modified later on and predefined attributes must not be modified. It will be used for any 'communication' with tools external to Actito (exports, synchronizations, imports, external customization...)
  Maximum number of characters: 50
• Name: functional ID of each attribute. It can be modified later on.
• Mandatory: defines the optional or mandatory nature of an attribute
  • mandatory: does each profile in my Actito database must include this information?
  • optional: is this information not required for all profiles in my Actito database?
• Multi-valued: defines the number of values collected for this attribute
  • simple valued: only one value will be allowed
  • multi-valued: several values can be saved for this attribute (for example: the attribute 'hobbies' can contain: football, theatre, cooking…)
• Unicity: checks the unique nature of this attribute
  • non unique: the value can be found several times in the database and be linked to several profiles
  • unique: the value of the attribute will be unique in the whole database (for example: client number)
  • unique for each profile: only for multi-valued attributes, the value can only be found once in the selected profile. To activate the display of the 'unique for each profile', it is necessary to go to step 2 in order to define the possible values, then to go back to step 1 via the breadcrumbs trail at the top of the screen.
• Comment: provides complementary information about the created attribute.

Step 2: Value type

• Value type: You can choose between several types of information to be stored in Actito (text, date, number...). Correctly typing a data will allow you to only have relevant data (e.g. an e-mail address must have an '@') and will simplify your targeting (e.g. the target criteria on a date are different from criteria on a number or a text).
• Restrictions: You can define restrictions on possible values. The type of restrictions varies depending on the selected type of value (e.g. a 'language' value can be limited to French, English and Dutch if you do not want to communicate in other languages and therefore you do not want other values for this attribute in your profiles).
• Default value: You can define a default value for this attribute. It guarantees the information to be present for each profile. This is important if your attribute is mandatory: in this case, if the data is missing at profile creation, the default value will be given.

Step 3: Existing Profiles

The purpose of this step is define what to do for profiles already existing in your database.

Depending on the mandatory or optional nature of the new attributes, you will have the following options:

• Value to set
  • Default value: if a default value was defined (at the previous step), it will displayed. You can choose to update all profiles with this value.
  • No value: if an attribute is not mandatory, you can choose to leave the value empty when creating the attribute. (You can populate it at a later stage with the 'profile import').
  • A specific value: you can choose to update all profiles with a specific value that you will directly determine.

Step 4: Confirmation

Before the actual creation of this new attribute in Actito, the last stage is to confirm if you really want to create it.

The creation will only be launched after clicking on the 'Add' button.

After the addition of the attribute, a message will confirm the success of the operation.