What clause operators are available for contact data segment building?

What clause operators are available for contact data segment building?

Delivra gives you the flexibility to personalize your email strategy by allowing up to 90 customizable contact data fields. These fields can be used to store a wide range of contact-specific information and power segmentation for targeted communication.

What Are Contact Data Fields?

Contact data fields store information tied to individual contacts in your account—such as state, birthdate, or loyalty points. These fields are foundational for segmenting your audience and building personalized automation paths. By leveraging field data, you can create precise clauses to include or exclude contacts based on specific values.

Field Types and Clause Options

Each contact data field is assigned one of the following data types, which determines the clause options you can use in segmentation:

Text Fields

Used for storing alphanumeric values like names, states, or job titles. Clause options include:

  • Equal to / Not equal to

  • Contains / Does not contain

  • Begins with / Ends with

  • In / Not in

  • Null / Not null

Date Fields

Perfect for birthdays, anniversaries, or signup dates. Clause options include:

  • Equal to / Not equal to

  • Before / After

  • At or before / At or after

  • Within the past / More than [X] days ago

  • Between / Date between / Anniversary between

  • Null / Not null

Number (Integer) Fields

Best for whole numbers like purchase counts or loyalty points. Clause options include:

  • Equal to / Not equal to

  • Less than / Greater than

  • In / Not in

  • Null / Not null

  • Comparison operators (less than, greater than, etc.)

Decimal Fields

Useful for values like purchase totals or averages. Clause options mirror those for integers:

  • Equal to / Not equal to

  • Less than / Greater than

  • In / Not in

  • Null / Not null

  • Comparison operators (less than, greater than, etc.)

Unicode Fields

Similar to text fields but capable of storing special characters from global languages. Clause options are the same as those for standard text fields.

Best Practices and Tips

  • Plan field usage ahead: With a 90-field limit, it's wise to map out which fields are critical for your segmentation and personalization strategies.

    Notes
    Have more data? Contact your Customer Success Manager at success@delivra.com to ask about custom tables!

  • Use naming conventions: Clear, consistent field names make building and managing segments easier across teams.

  • Take advantage of “Null” checks: These are great for finding incomplete data or ensuring follow-up actions for contacts missing key information.

  • Use “In” and “Not In” for lists: These operators are ideal for filtering contacts against predefined groups of values (e.g., state in Indiana, Ohio, Michigan).

Practical Use Cases

  • Birthday Emails: Use a Date field with a clause like “Anniversary between” to trigger special messages around a contact’s birthday.

  • State-Based Campaigns: Segment using a Text field where “State equals Indiana” to send location-specific promotions.

  • High-Value Customers: Filter with an Decimal field where “Purchase Total is greater than 100” to identify VIPs for exclusive offers.

  • Incomplete Profiles: Build a segment where “Phone Number is Null” to prompt contacts to update their information.

Additional Notes

  • All 90 fields are included by default in every Delivra account.

    • Related Articles

    • Creating Segment of Contacts

      What is a segment? A segment is a dynamic subset of your contacts database. Segments use clauses to determine recipients of a campaign based on evaluation of data values stored on your contact records or behavior of recipients of a sent email. You ...
    • Using the IN and NOT IN operators

      There may be instances where you need to evaluate several values in a demographic field for a segment. You can save time using the IN or NOT IN operators when building your segment clauses. IN means you're looking for the list of values entered; NOT ...
    • Segmenting your SMS Contacts

      Segments allow you to dynamically divide contacts into lists that you can send campaigns to. Using a clause builder, you can build criteria to target your campaigns to the most relevant contacts to ensure the highest possible engagement and you can ...
    • Can I store custom data to SMS contact records?

      Please note this feature is only available in Legacy for now, but it is coming to Air soon! Delivra makes it easy to manage and personalize your SMS communications by supporting a range of custom fields on SMS contact records. These fields can store ...
    • What clauses are available for segments?

      Segmenting your audience is key to delivering relevant and personalized messages. In Delivra, you can build segments using a variety of contact data and behavioral insights. These segments define the audience groups for your email or SMS campaigns, ...