v7
Manage enumerations
An enumeration (also known as ‘itemized list’) is a list of values suggested by the system to populate certain fields. Enumerations let you standardize the values of these fields, and help with data input or use within queries.
The list of values appears as a drop-down list from which you can select the value to be entered in the field. The drop-down list also enables predictive input, where the operator enters the first few letters, and the application fills in the rest.
Some of the console fields have been defined with this type of enumerations. Enumerations are called “open” if you can add values by direct input in the corresponding field.
Access to values
The values for this type of field are defined and overall administration of these fields (adding/deleting a value) is performed via the Administration > Platform > Enumerations node of the tree.
-
The upper section offers a list of fields for which an itemized list has been defined.
-
The lower section lists the proposed values. These values will be repeated in the editors that use this field.
To create a new enumeration value, click Add.
If the Open option is selected, the user can add a new itemized list value directly in the corresponding field. A confirmation message allows you to create this value.
-
If the Closed option is selected, users will not be able to create new values, but merely choose from the values available.
Standardize data
About alias cleansing
In the itemized list fields, you can enter values other than enumeration values. These can either be stored as they are or be cleansed.
CAUTIONThe entered value is then either:
-
Added to the itemized list values: in this case the Open option must be selected,
-
or automatically replaced by its corresponding alias: In this case, this case must then be defined in the Alias tab of the itemized list,
-
or is stored in the list of aliases: an alias be assigned to it later on.
NOTEIf you need to use data cleansing capabilities, select the Alias cleansing option in the itemized list.
Using aliases
The option Alias cleansing makes it possible to use aliases for the selected itemized list. When this option is selected, the Alias tab is displayed at the bottom of the window.
Create an alias
To create an alias, click Add.
Enter the alias you want to convert and the value to be applied and click Ok.
Check parameters before confirming this operation.
CAUTION
Thus, when a user enters the value NEILSEN in a “company” field (in the Adobe Campaign console or in a form), it will automatically be replaced by the value NIELSEN Ltd. Value replacement is performed by the Alias cleansing workflow. Refer to Run data cleansing.
Converting values into aliases
To convert an enumeration value into an alias, right-click in the list of values and choose Convert values into aliases….
Choose the values you want to convert and click Next.
Click Start to run the conversion.
Once execution is complete, the alias is added to the list of aliases.
Retrieve alias hits
The values entered by the users can be converted into aliases. In effect, when the user enters a value that is not included in the itemized list, the value is stored in the Alias tab.
The Alias cleansing technical workflow recovers these values every night to update itemized list. Refer to Run data cleansing
If necessary, the Hits column can display the number of times this value was entered. Calculating this value can be both time and memory consuming. For more on this, refer to Calculate entry occurrences.
Run data cleansing
Data cleansing is performed by the Alias cleansing technical workflow. The configurations defined for enumerations are applied during execution. Refer to Alias cleansing workflow.
Cleansing can be triggered via the Cleanse values… link.
The Advanced parameters… link lets you set the date starting from which collected values are taken into account.
Click the Start button to run data cleansing.
