Related Data Criteria

A Related Data segment condition is based on whether or not the Related Data contains a certain value. Alternatively, a condition can be based on the number of records in a related data set for a certain user. 

You can use this type of selection in any area in Mapp Engage, including in CMS message paragraphs and profile-based automations.

Related Data Condition

With the ​Related Data Condition ​criterion, you can create simple queries to related data sets. This criterion creates segments that are based on the values in the related data attributes for the contact. The logic of the segment criteria depends on the type of data that is stored in the attribute. The system offers different operators for different types of data.

 Configuration
SettingDescription
BooleanBoolean attributes contain a value true or false. The attribute can also be empty.
DateDate attributes contain a calendar date.
Enumerated String​

A string attribute can contain any characters (including letters, numbers, and special characters). Enumerated means that all possible values are defined in advance. For example, language and country are enumerated attributes.

Not Enumerated String​

A string attribute can contain any characters (including letters, numbers, and special characters). Not enumerated means that the values are not defined in advance. For example, the standard attribute Last Name is not enumerated.

NumberThe number data type stores data as a positive or negative numeric value. For example, a mobile number is stored as a number. Number attributes can either be enumerated or not enumerated.

For conditions based on multiple values in the same row of the dataset, all the criteria must be defined in the same ​RelatedDataCondition​. To define these criteria, use the ​Add Filter​ option.

Example 1

Delete contacts who have purchased a certain type of product on a certain date. The implicit logical operator here is always AND. For conditions based on multiple values that can be in different rows, define each criteria as a separate ​RelatedDataCondition​.

Example 2

Select contacts who purchased a certain type of product AND made any purchase on a certain date. The two criteria can be true in the same row or in two different rows. In this example, OR logic can be used instead.

Transaction

The ​Transactions​ criterion works just like ​Related Data Condition​ criterion, but with predefined related data.

 Predefined related data
  • orderID
  • product SKU
  • productName
  • productPrice
  • productQuantity
  • returnedQuantity
  • imageURL
  • category
  • brand
  • variant
  • storeID
  • currency
  • discountValue
  • purchaseSource
For more information see System Transactions.

Abandoned Cart

Selects contacts with certain products and/or product value in their cart.

 Configuration
SettingDescription
Add FilterFilters based on the productSKU value, and/or productPrice value.
​In TimeframeSee Date Picker in Mapp Engage.
Number Of OccurrencesFilters based on the number of times the contact abandoned their cart.
Include contacts out of datasetYes/No

Wishlist

Selects contacts with certain products and/or product value on their wish list.

 Configuration
SettingDescription
Add FilterFilters based on the productSKU value, and/or productPrice value.
​In TimeframeSee Date Picker in Mapp Engage.
Number Of OccurrencesFilters based on the number of occurrences
Include contacts out of datasetYes/No

Number Of Occurrences

This section is used to define the number of occurrences and add contacts outside the data set. There are three operators to specify how the search conditions should be applied. All these operators specify the number of occurrences the engine should search.

Operator

Description

Equals

The exact amount of occurrences should be found in the Data Set.

If zero is selected - the contacts that exist in this particular datasets, but have no such records will be returned. In this case, it is also possible to include the contacts that are not presented in this particular Data Set.

Is Greater ThanThere should be a strictly greater amount of such records in the Data Set.
Is Less ThanThere should be a strictly less amount of such records in the Data Set. It is possible to enter any value from 2 to 999. In this case, it is also possible to include the contacts that are not presented in this particular Data Set.

Related Topics