Use these operators to compare the integer or BigDecimal values associated with transaction metrics. Operators follow the attribute using dot notation, for example: currentUserGroup.numberOfTxns >= 10
.
Operator | Definition |
---|
== | True if value equals the specified value |
!= | True if value does not equal the specified value |
> | True if value is greater than the specified value |
>= | True if value is greater than or equal to the specified value |
< | True if value is less than the specified value |
<= | True if value is less than or equal to the specified value |
isNull | True if the attribute value is null |
isNotNull | True if the attribute value is not null |
Profile: currentUserGroup
Attribute: numberOfTxns
Meaning: Total number of transactions made by the group since creation.
Type: Integer
Sub-Attribute: NA
Syntax: currentUserGroup.numberOfTxns [Operator] [Value]
Profile | Attribute | Sub-Attribute | Operator | Example |
---|
currentUserGroup | numberOfTxns | NA | == | currentUserGroup.numberOfTxns == 1 |
currentUserGroup | numberOfTxns | NA | >= | currentUserGroup.numberOfTxns >= 10 |
currentUserGroup | numberOfTxns | NA | isNull | currentUserGroup.numberOfTxns.isNull() |
currentUserGroup | numberOfTxns | NA | isNotNull | currentUserGroup.numberOfTxns.isNotNull() |
Example 1 : Identify groups with at least 10 transactions. |
---|
Expression: currentUserGroup.numberOfTxns >= 10 |
Example 2 : Target groups with exactly 1 transaction. |
---|
Expression: currentUserGroup.numberOfTxns == 1 |
Example 3 : Check for groups missing transaction data. |
---|
Expression: currentUserGroup.numberOfTxns.isNull() |
Profile: currentUserGroup
Attribute: numberOfTxnsToday
Meaning: Number of transactions made by the group on the current day.
Type: Integer
Sub-Attribute: NA
Syntax: currentUserGroup.numberOfTxnsToday [Operator] [Value]
Profile | Attribute | Sub-Attribute | Operator | Example |
---|
currentUserGroup | numberOfTxnsToday | NA | == | currentUserGroup.numberOfTxnsToday == 0 |
currentUserGroup | numberOfTxnsToday | NA | >= | currentUserGroup.numberOfTxnsToday >= 1 |
currentUserGroup | numberOfTxnsToday | NA | isNull | currentUserGroup.numberOfTxnsToday.isNull() |
currentUserGroup | numberOfTxnsToday | NA | isNotNull | currentUserGroup.numberOfTxnsToday.isNotNull() |
Example 1 : Target groups with at least one transaction today. |
---|
Expression: currentUserGroup.numberOfTxnsToday >= 1 |
Example 2 : Identify groups with no transactions today. |
---|
Expression: currentUserGroup.numberOfTxnsToday == 0 |
Example 3 : Check for groups missing today's transaction data. |
---|
Expression: currentUserGroup.numberOfTxnsToday.isNull() |
Profile: currentUserGroup
Attribute: numberOfVisits
Meaning: Number of unique days on which the group made transactions.
Type: Integer
Sub-Attribute: NA
Syntax: currentUserGroup.numberOfVisits [Operator] [Value]
Profile | Attribute | Sub-Attribute | Operator | Example |
---|
currentUserGroup | numberOfVisits | NA | >= | currentUserGroup.numberOfVisits >= 5 |
currentUserGroup | numberOfVisits | NA | == | currentUserGroup.numberOfVisits == 10 |
currentUserGroup | numberOfVisits | NA | isNull | currentUserGroup.numberOfVisits.isNull() |
currentUserGroup | numberOfVisits | NA | isNotNull | currentUserGroup.numberOfVisits.isNotNull() |
Example 1 : Identify groups active on at least 5 distinct days. |
---|
Expression: currentUserGroup.numberOfVisits >= 5 |
Example 2 : Target groups with exactly 10 visit days. |
---|
Expression: currentUserGroup.numberOfVisits == 10 |
Example 3 : Check for groups missing visit data. |
---|
Expression: currentUserGroup.numberOfVisits.isNull() |
Profile: currentUserGroup
Attribute: lifetimePurchase
Meaning: Total value of purchases made by the group since creation, including the current transaction.
Type: BigDecimal
Sub-Attribute: NA
Syntax: currentUserGroup.lifetimePurchase [Operator] [Value]
Profile | Attribute | Sub-Attribute | Operator | Example |
---|
currentUserGroup | lifetimePurchase | NA | > | currentUserGroup.lifetimePurchase > 1000 |
currentUserGroup | lifetimePurchase | NA | <= | currentUserGroup.lifetimePurchase <= 1000 |
currentUserGroup | lifetimePurchase | NA | isNull | currentUserGroup.lifetimePurchase.isNull() |
currentUserGroup | lifetimePurchase | NA | isNotNull | currentUserGroup.lifetimePurchase.isNotNull() |
Example 1 : Identify groups with lifetime purchase exceeding 5000. |
---|
Expression: currentUserGroup.lifetimePurchase > 5000 |
Example 2 : Target groups with lifetime purchase exactly equal to 1000. |
---|
Expression: currentUserGroup.lifetimePurchase == 1000 |
Example 3 : Check for groups missing lifetime purchase data. |
---|
Expression: currentUserGroup.lifetimePurchase.isNull() |
Profile: currentUserGroup
Attribute: initialLifetimePurchase
Meaning: Total value of purchases made by the group before the current transaction.
Type: BigDecimal
Sub-Attribute: NA
Syntax: currentUserGroup.initialLifetimePurchase [Operator] [Value]
Profile | Attribute | Sub-Attribute | Operator | Example |
---|
currentUserGroup | initialLifetimePurchase | NA | >= | currentUserGroup.initialLifetimePurchase >= 3000 |
currentUserGroup | initialLifetimePurchase | NA | < | currentUserGroup.initialLifetimePurchase < 2000 |
currentUserGroup | initialLifetimePurchase | NA | isNull | currentUserGroup.initialLifetimePurchase.isNull() |
currentUserGroup | initialLifetimePurchase | NA | isNotNull | currentUserGroup.initialLifetimePurchase.isNotNull() |
Example 1 : Identify groups with pre-transaction lifetime purchase above 2000. |
---|
Expression: currentUserGroup.initialLifetimePurchase > 2000 |
Example 2 : Target groups with pre-transaction lifetime purchase exactly 1500. |
---|
Expression: currentUserGroup.initialLifetimePurchase == 1500 |
Example 3 : Check for groups missing initial lifetime purchase data. |
---|
Expression: currentUserGroup.initialLifetimePurchase.isNull() |