Attributes

To add an attribute, go to the Tables structure module (Hub > 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.

Choose whether you want to update it through the interface or from a JSON file. Here, we are going to do it from the interface.

Adding an attribute

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

List of predefined attributes

Actito offers the following predefined attributes. It is highly recommended to use them: their parameters are pre-filled based on Actito standards.

Predefined attribute	Field type	Description
birthdate	Date	Stores a birth date. Actito automatically calculates the profile's age, so you can target ranges such as "all people between 25 and 55 years old" without configuring a date. Also used for reports such as the age pyramid.
emailAddress	Email address	The only field you can use to send emails with Actito. Created by default as mandatory and unique. See the acceptance rule below.
emailAddressMD5, emailAddressSHA256	Hash (computed by Actito)	Encrypt the emailAddress value with the MD5 or SHA256 hash, e.g. to share addresses with external tools without exposing the clear value. Automatically calculated from emailAddress, so they require an emailAddress attribute and share its properties (unicity, mandatory). Their value cannot be written manually.
firstName, lastName	Text (max. 64 characters)	Simple text fields. lastName is mandatory by default.
gsmNumber	Mobile phone number	The only field you can use to send SMS with Actito. Only international-format numbers can be contacted (e.g. France: +33 6 XX XX XX XX; Belgium: +32 4XX XX XX XX). See the acceptance rule below.
motherLanguage	Language (two-letter ISO 639-1 code)	Used to send campaigns to profiles in the correct language. If you do not use it, untick the preselected "language" box at the targeting stage of your email campaign.
nbreChildren	Integer (zero or more)	Stores the number of children of a profile.
addressCountry	Country (two-letter ISO 3166-1 code)	Part of the postal address block. Stores the country.
addressLocality, addressPostalCode, addressStreet, addressNumber, addressBox	Text (max. 50 characters)	Store the rest of the postal address. Allows values such as the postal code "SW15 5PU" or the house number "41b".
profession	Large text (max. 50 characters)	No default value is defined in Actito.
sex	Text (M or F)	Can only contain M or F (Male or Female). Actito offers no civility attribute (Mr, Mrs, Ms). In personalizations, the "gender test" uses this field to customize the greeting.
telephoneNumber	Telephone number	A telephone number field.
marketingConsent	Boolean	Mandatory by default. Stores a profile's consent to be contacted by marketing campaigns, within the framework of the GDPR (see /docs/Managing_the_Explicit_Consent).
trackingConsent	Boolean	Stores a profile's consent for their behaviour to be tracked in a campaign, e.g. opens, clicks, device type, or goals reached (see /docs/Managing_the_Explicit_Consent).
whatsAppBSUID	WhatsApp User ID	A stable WhatsApp identifier used to keep addressing a contact when their phone number is not available. Unique by default and cannot be modified once set. When sending, Actito uses it in priority and falls back to gsmNumber. See the note below.

Acceptance rule for the emailAddress field

• It must respect the following syntax: xxx@yyy.zzz
  • the xxx value (the username 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 "a -> z", "A -> Z", "0 -> 9", "-", "_", "." and the special characters "!#$%&'*+-/=?^_`{|}~"
  • use of an "@" is mandatory
  • at least one character is mandatory before the "@"
  • the domain name and the suffix must follow the "@"
  • the domain name cannot start or end with "-"
  • the suffix must contain at least two characters
  • several dots (".") cannot follow each other (e.g. "...")
• Subdomains are allowed (e.g. subdomain.mydomain.com) and accents are allowed in domain names.

Before each sending, Actito checks whether the address can be reached (if not, it is filtered).

Hash example for the address "support@actito.com":

• emailAddressMD5: b87e913e711d2211acffdc7a5b1703f0
• emailAddressSHA256: 7e413502940e598d242f58f2c71ac09660c093ecbfc03c3f2b8fe68c3a2316ef

Acceptance rule for the gsmNumber field

The field can contain the following characters only: +().- /0123456789 (the empty space is included).

About the whatsappBSUID attribute

WhatsApp is rolling out an optional usernames feature. Once a contact adopts a username, their phone number is no longer guaranteed to appear in webhooks. The Business-scoped User ID (BSUID) is a WhatsApp identifier that lets you keep contacting these profiles.

• This attribute is unique by default and cannot be modified once set.
• Actito keeps the value in sync: if the BSUID changes on WhatsApp's side, it is automatically updated in Actito.
• The value must respect the expected format. If the format is incorrect, the profile cannot be saved.
• The attribute can also be set through the API, both when creating and when updating a profile.

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.

  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 parameter 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": must each profile in my Actito database 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 (e.g. 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 (e.g. 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 "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 data will allow you to only have relevant data (e.g. an email 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 to 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 be 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 whether 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.