In the Marketer+ plan, you have the option to segment your contacts using your own specific queries and their combinations. This article will help you understand Ecomail Query Language (EQL)
Within EQL you can use the following data:
all basic contact fields (e.g. name, surname, email)
custom contact fields
purchase properties (transaction.props)
You can use these operators:
EQUALS
EQUALS_NOT
CONTAINS
CONTAINS_NOT
LOWER
HIGHER
CONTAINS_ONE_OF
DOES_NOT_CONTAIN_ONE_OF
Examples
You can make a custom query similar to this:
email EQUALS 'some@mail.cz' OR (email CONTAINS_NOT 'seznam.cz' AND name EQUALS 'Jan') AND phone CONTAINS '+420'
The values for CONTAINS_ONE_OF and DOES_NOT_CONTAIN_ONE_OF must be in square brackets separated by a comma, for example:
name CONTAINS_ONE_OF ['John','Mark','Tim']
Purchase properties
The following property relates to the purchase property, which can be defined as follows:
"props": {"myCustomProp": "customPropValue"}
See more about purchase properties here.
To query the properties of purchase, you can use for example
transaction.props.frequency EQUALS 'yearly'
You can also use the last purchase query:
last_transaction.props.frequency EQUALS 'yearly'