Conditional operators for various data types

While creating the logical building blocks of a segment, the type of search you can run for an attribute is determined by the attribute type. 

Note: Your first payload determines the data type of your attribute

Strings

Consider the following points when you use operators on strings:

  • Use operators marked with * with caution as they can slow down the performance of the segmentation query.
  • The “is empty” operator matches both nil/null and empty values.

The following operations are supported for strings:

  • is equal to
  • is not equal to
  • *contains
  • *does not contain
  • is empty
  • is not empty
  • *begins with
  • *ends with

Numbers

The following operations are supported for numbers:

  • is equal
  • is not equal to
  • is greater than
  • is less than
  • is less than or equal to 
  • is greater than or equal to 
  • is missing
  • is empty
  • is not empty

Dates

The following operations are supported for dates:

  • between fixed windows
    • You can choose specific start and end dates
  • between moving windows
    • You can choose relative dates (past and future) in minutes/ hours/ days/ weeks/ months/ forever
    • Relative dates start from beginning of the first time period to the end of the next time period
  • within past
    • can be used to look back Minutes/Hours/Days/Weeks/Months from now

Consider the following points about date operators:

  • For calculation purposes, the units of time are considered as follows:
    • month = 30 days
    • week = 7 days
    • day = 24 hours
  • Time windows are evaluated from the beginning of the ‘from’ time to the end of the ‘to’ time.
  • Beginning and end of the the time is based on the unit of time selected:
    • Unit = Months, weeks, days -> Beginning/ end of day
    • Unit = Hours -> Beginning/ end of hour
    • Unit = Minutes -> Beginning/ end of minute
    • Unit = Seconds -> Beginning/ end of second

For example:

  • If Today is April 15, then Within past 1 month means from 12 AM March 16 (which is 30 days before April 15) to the current time.
  • If Today is April 15, then From past 1 week to next 1 week means 12AM April 8 (which is 7 days before April 15) to 23:59 PM April 22 (which is 7 days after April 15).
  • If the time right now is 9:58 AM, then From past 2 hours to next 2 hours means from 7 AM (which is the beginning of the hour for 7:58 AM) to 12 PM (which is the end of the hour for 11:58 AM).
  • If the time right now is 10:02 AM, then From past 2 hours to next 2 hours means from 8 AM (which is the beginning of the hour for 8:02 AM) to 1 PM (which is the. end of the hour for 12:02 PM).

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.