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, that is, how many
Include contacts out of datasetYes/No

Related Topics

Using joined Data Views vs AND operator