Fields in add attribute details page

The description of all the fields and their details, seen in the Add attribute details page, are as follows:

Table 1. Fields in Add Attribute Details Page
Field Name Description
Display name Specify the label to identify the attribute for users. For example, "Interest Rate". Double quotes in attribute display names are not supported.
Internal name

Specify a name to identify this attribute when you write a query or custom macro. Use the same name as the Attribute display name, but without any spaces (for example, "InterestRate").

The internal name must be globally unique, must start with an alphabetic character, cannot include spaces, and are not case-sensitive.
Description A description of the attribute.
Form element type Specify the type of data to be stored in the attribute field for offers.
Important: After you add the custom attribute, you cannot change its data type.
Form element type

Text field - String

 Specify a maximum string length to indicate the maximum number of bytes to store for any value of this attribute. For example, if you enter 32, single-byte languages such as English store 32 characters but double-byte languages store only 16 characters.
Important: Decreasing the length of an existing attribute truncates existing values, which, if the field is used for matching purposes, can adversely affect response tracking.
Form element type

Text field - Numeric

 Specify the number of decimal places to display to the right of the decimal point.
Note: If you decrease the value for an existing attribute, the display is truncated in the user interface. However, the original value is retained in the database.
Form element type

Text field - Date
Form element type

Text field - Currency

 Specify the number of decimal places.
Important: The currency value reflects the number of decimal places that are customarily used in the local currency. If you specify a number for decimal places that is less than the number commonly used, the currency value is truncated.
Form element type

Select box - String
  • Specify a Maximum string length
  • Optionally, check Allow addition of list items from within edit forms to allow any user to add new unique values to the list of available values when creating or editing an offer template, or an offer that includes this attribute. For example, if a Select Box on an offer template contains the values Small, Medium, Large, a user could add the value Extra Large when creating an offer or editing the offer template.
    Important: After the offer template, or offer is saved, the user cannot remove the new list item. The value is saved in the custom attribute definition and is then available to all users. Only administrators can remove items from lists, by modifying the custom attribute.
  • Populate the Source list of available values to specify which items are available in the Select Box. Enter values in the New or selected item field and click Accept. To delete a value, select it in the Source list of available values and click Remove.
  • Optionally, specify a Default value for the Select Box. The default value is used on the offer unless the user specifies a different value when creating or editing the offer.
  • Specify the Sort order to determine how values appear in the list.
Form element type

Select box - Database

 This element type attribute does not support Engage integration. You must provide values for the following fields:
  • Use values from this table - Lists the tables or the database view of the Unica Campaign schema for the logged in user's partition. You can create LOOKUP tables in Campaign schema for this feature. You cannot access LOOKUP tables from any other schema, for example Unica Plan. To access LOOKUP tables of other schema, you must create a DB view in the Campaign schema pointing to the table from the other schema.
  • Key column - Lists all the columns for the selected database table.
    Note:
    • Key column supports Text-based data types and following numeric-based data types: SMALLINT, INT, and INTEGER. The column should be a primary key to avoid duplicates. Using a column containing duplicates results in unexpected behavior when retrieving values.
    • If you have used a lookup table key-value pair at offer template level or offer level, do not delete these rows from the lookup table. If you delete the key-value pair from the lookup table, the system may not work as expected in all the cases.
  • Display column - Lists all the columns of the selected table.
    Note:
    • Display column supports the following text-based data types: VARCHAR, NVARCHAR, CHAR, TINYTEXT, TEXT, and MEDIUMTEXT.
    • Display column supports the following numeric-based data types: SMALLINT, INT, INTEGER, DOUBLE, and FLOAT.
    • Display column supports the following date-based data types: DATE and TIMESTAMP. The dates will appear as per UTC time zone.
  • Sort by column - Lists all the columns of the selected table.
    Note:
    • If your database does not support a particular data type for sorting, avoid using that data type. For example, LONG
    • Sort by column supports the following text-based data types: VARCHAR, NVARCHAR, CHAR, TINYTEXT, TEXT, and MEDIUMTEXT.
    • Sort by column supports the following numeric-based data types: SMALLINT, INT, INTEGER, DOUBLE, and FLOAT.
    • Sort by column supports the following date-based data types: DATE and TIMESTAMP.
  • Sort order - The order for sorting. Available options are Ascending and Descending.

The following field is optional:

  • Default values for the field -
Note: Attribute values at template level and offer level has the same upper limit as that of Centralized Offer Management attributes.
Form element type

Text field - Integer

 You can use the Integer attribute type to fill numeric data without decimal places.
Form element type

Check box - Boolean

 You can use the Boolean attribute type to select or deselect a checkbox (for example true or false) for the attribute.
Note: Currently the systems leveraging Centralized Offer Management treats the Boolean attribute as numeric with possible values of 0 or 1. Here, 0 means FALSE and 1 means TRUE. So, if you are parameterizing the Boolean attribute, or exporting the attribute, it will be represented as 0 or 1.
Form element type

Picker - URL

 You can define the attribute of type URL. When integrated with Unica Content Integration, you can configure a URL for searching content from target content management system. For more information see Unica Content Integration Installation and Configuration Guide.

If you have hosted Unica on an SSL setup (https) and the CMS is on a non-SSL setup (https), the thumbnails for the images might not appear. You have to configure your browser to view the thumbnail of the content. For more information on configuring the browser, see Browser configurations if CMS is hosted on non-SSL setup.
Form element type

Text field - Rich text

 This element type attribute does not support Engage integration. You can use the Rich text attribute to write and format content. The Rich text attribute provides an editor containing the following formatting options:
  • Bold
  • Italics
  • Underline
  • Strikethrough
  • Font size
  • Font color
  • Background color
  • Paragraph formatting
  • Ordered list
  • Unordered list
  • Inserting a hyperlink
  • Inserting a table
Note:
  • Rich text attribute is supported only in internal attributes and static attributes section.
  • The tooltip for font color and background color does not support localization. This is a limitation in the editor.
  • Within the rich text editor, copying formatted text from an external source and pasting it to the editor is supported. However, sometimes, the formatting may not be retained during the copy-paste. In such cases, you can reapply the formatting.
  • Microsoft Internet Explorer users cannot access the hyperlink due to limitations in Internet Explorer. Google Chrome users can access the hyperlink by right-clicking the hyperlink and opening it in a new tab, new window, or in incognito mode.
Mandatory If you want to require a value for this attribute, select Mandatory.
This setting has the following result:

  • For offers, administrators are required to specify a value when the attribute is added to an offer template. The specified value is used for any offers that are based on that template unless the user specifies a different value when creating or editing the offer.

If you change this option after an attribute is in use:
  • If you change from mandatory to non-mandatory, a value is no longer required when the attribute is used.

  • If you change from non-mandatory to mandatory, a value is required whenever this attribute is used in the future. This change has no effect on existing objects unless you edit them.