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'

Did this answer your question?