Use Profile based operators to show exact or a range of data within a Query.

The table shows the Profile criteria that is now available for Create Query.

Criteria

operator

Column Name

values

Channel

Locked Query Id/Name

is blank

first name

   

someOtherQueryId

is not blank

first name

     

is between

age

10 and 20

   

is equal to

age

10

   

is not equal to

age

10

 

someOtherQueryId

is equal to one of the following

zipcode

30052, 30033

   

is not equal to one of the following

zipcode

30052, 30033

   

is within the last range of

anniversary

5 and 10 days

   

is within the next

anniversary

10 days

 

someOtherQueryId

is not within the last

anniversary

5 days

   

is in contact list

 

list id or name

   

is not in contact list

 

list id or name

 

someOtherQueryId

is not in query

 

someOtherQueryId

   

OPTED-IN

 

any qualifier

PUSH

 

OPTED-OUT

 

single qualifier

SMS

 

NEVER-JOINED

 

multiple qualifiers

PUSH

Join The Discussion

Your email address will not be published. Required fields are marked *