Supported data types
Intempt supports five data types for attributes: string, integer, boolean, date, and list. By choosing the most suitable data type for your attributes, you can apply a set of operators most relevant to your attributes in Intempt, giving you richer insights about your data.
String
Alphanumeric value e.g. Plan Type = "Free", Artist Name = "Bruno Mars"
Intempt will treat any attribute value that doesn’t match any other data type as a string.
String operators
Operator Name | Description |
is | Checks if the attribute exactly matches a value. |
is not | Checks if the attribute does not match a value. |
contains | Searches within the attribute for a value. |
does not contain | Confirms the attribute does not include a value. |
has any value | Validates that the attribute has any value. |
has no value | Checks if the attribute has a blank or null value. |
Integer
Numeric (integer or decimal) value e.g. Cost = 15.00, Quantity = 5
You can apply operators such as sum, median, and percentile on integer attributes (in reports)
Integer operators
Operator Name | Description |
equals | Checks if the attribute is equal to a specified number. |
doesn’t equal | Checks if the attribute is not equal to a specified number. |
is greater than | Verifies if the attribute is greater than a specified number. |
is less than | Verifies if the attribute is less than a specified number. |
is greater than or equal | Checks if the attribute is greater than or equal to a specified number. |
is less than or equal | Checks if the attribute is less than or equal to a specified number. |
is between | Checks if the attribute is within a specified range of numbers. |
is not between | Checks if the attribute is not within a specified range of numbers. |
has any value | Validates that the attribute has any numerical value. |
has not value | Checks if the attribute has no assigned value or is null. |
Boolean
Intempt treats attribute as boolean if the value is either the JSON constant true or false, e.g., Favorited = true, Bookmarked = false.
Boolean operators
Operator Name | Description |
true | Indicates the attribute is true. |
false | Indicates the attribute is not true. |
Date
An ISO formatted date YYYY-MM-DDTHH:MM:SS in UTC e.g. Last Purchase = "2022-10-30T13:30:25", Last Login = "2022-10-29". Note that all timestamps need to be sent in UTC timezone in an ISO format.
Date operators
Operator Name | Description |
in the last | Checks if the date occurred within the specified time frame up to now. |
not in the last | Checks if the date did not occur within the specified time frame up to now. |
between | Checks if the date falls within a specified range of dates. |
not in between | Checks if the date does not fall within a specified range of dates. |
on | Checks if the date matches the specified date. |
not on | Checks if the date does not match the specified date. |
before | Checks if the date occurred before the specified date. |
since | Checks if the date occurred on or after the specified date. |
List
List. A list of values as a JSON array e.g Favourite Genres = ["Folk","Alternative"] or Favourite Numbers = [1,5,10.0]
Object. Arbitrarily-nested groups of JSON key-value pairs e.g. Experiments = {"Exp Onboarding":"Quick","Exp Checkout":"Without Coupon"}
List of objects. A JSON array of 1 level JSON objects with each object having similar sets of key-value pairs e.g. Cart = [{"Brand":"Puma","Category":"Jacket","Price":30}, {"Brand":"Adidas","Category":"Hats","Price":15}]
List operators
Operator Name | Description |
all in the list | Checks if all specified values are present in the attribute list. |
any in the list | Checks if any of the specified values are present in the attribute list. |