The table below contains details about the data types that are supported when creating conditions and rules within a Segment.
Field data type |
Description |
Data types supported in Segmentation |
---|---|---|
Single Line of Text |
This field can contain up to 4,000 text characters. You can set the maximum length to be less than this. This field has several format options that will change the presentation of the text. These options are Email, Text, Text Area, URL, Ticker Symbol, and Phone. More information: More information: Single line of text format options |
string |
Multiple Lines of Text |
This field can contain up to 1,048,576 text characters. You can set the maximum length to be less than this. When you add this field to a form, you can specify the size of the field. |
string |
Option Set |
This field provides a set of options. Each option has a number value and label. When added to a form, this field displays a control for users to select only one option. When this field is displayed in Advanced Find, users can use a picklist control to select multiple options to include in their search criteria. |
choice |
MultiSelect Option Set (Choice / Pick) |
This field provides a set of options, where multiple options can be selected. When added to a form, this field uses a control for users to select multiple options. When this field is displayed in Advanced Find, users can select multiple options from the list to include in their search criteria. |
NONE |
Two Options |
This field provides two options. Each option has a number value of 0 or 1 corresponding to a false or true value. Each option also has a label so that true or false values can be represented as “Yes” and “No”, “Hot” and “Cold”, “On” and “Off” or any pair of labels you want to display. Two option fields don’t provide format options at the field level. But when you add one to the form you can choose to display them as radio buttons, a check box, or a select list. |
yes/no - 0/1 + boolean + |
Status (State) |
A system field that has options that generally correspond to active and inactive status. Some system attributes have additional options, but all custom attributes have only Active and Inactive status options. You can also include custom state transitions to control which status options are available for certain entities. More information: Define status reason transitions |
All
|
Status Reason (Status) |
A system field that has options that provide additional detail about the Status field. Each option is associated with one of the available Status options. You can add and edit the options. |
All
|
Whole Number |
Integers with a value between -2,147,483,648 and 2,147,483,647 can be in this field. You can restrict the maximum or minimum values in this range. This field has format options None, Duration, Time Zone, and Language that change depending on how the field is presented. More information: Whole number format options |
int32 |
Floating Point Number (Double) |
Up to 5 decimal points of precision can be used for values between -100,000,000,000 and 100,000,000,000 can be in this field. You can specify the level of precision and the maximum and minimum values. More information: Using the right type of number |
decimal or float |
Decimal Number |
Up to 10 decimal points of precision can be used for values between -100,000,000,000 and 100,000,000,000 can be in this field. You can specify the level of precision and the maximum and minimum values. More information: Using the right type of number |
decimal |
Currency |
Monetary values between -922,337,203,685,477 and 922,337,203,685,477 can be in this field. You can set a level of precision or choose to base the precision on a specific currency or a single standard precision used by the organization. More information: Using Currency Fields |
money/decimal |
Date and Time |
This field has format options to display Date Only or Date and Time. |
All
|
Lookup |
Displays either a list of values that is retrieved from a table or query, or a set of values that you specified when you created the field. The Lookup Wizard starts and you can create a Lookup field. The data type of a Lookup field is either Text or Number, depending on the choices that you make in the wizard. |
All
|
Owner |
A system lookup field that references the user or team that is assigned a user or team owned entity record. |
All
|
Unique Identifier |
A system field stores a globally unique identifier (GUID) value for each record. |
All
|
Customer |
A lookup field that you can use to specify a customer, which can be an account or contact. |
All
|