New Audience Builder Filter Reference

Custom Fields (vars)

Date

Find or exclude users based on the date of a specific user profile field (a.k.a. var). For example, users whose birth_date field value is today’s date or whose join_date is one year ago today.

  • In the box under Field (var) enter part of any field name to search all that exist across your user profiles, then select a matching name below.
  • If you need to enter a field name that does not yet exist, but may exist in the future as a result of future user profile additions or updates, enter the new name and click “Create field”. Your user profiles are not modified.

Field Exists, Contains, Is

Find or exclude users based on whether a custom profile field exists or contains specified text.

  • In the box under Field (var) enter part of any field name to search all field names that exist across your user profiles, then select a matching name. No results will be found in the drop-down until you enter at least one letter.
  • If you need to enter a field name that does not yet exist, but may exist in the future as a result of future user profile additions or updates, enter the new name and click Create field. Your user profiles are not modified.
  • contains will match your text when it matches all or part of the stored value. For example, entering book will match field values books and Facebook. This query is case-sensitive, so Book would not be a match.
  • is will match the exact text, as entered. For example, entering book will not match field values books and Facebook. This query is case-sensitive, so Book would not be a match.
  • exists will identify users who have the selected field on their profile, regardless of whether the field has a value

Number

Find or exclude users based on the value of a given user profile field.

  1. Click the box under Field (var) to search and select from the custom profile fields available on user profiles in your account. No results will be found in the drop-down until you enter at least one letter.
  2. Select an operator: equals (=), greater than (>), greater than or equal to (>=), less than (<), or less than or equal to (<=).
  3. Enter a number in the Value field. You can enter any number, including an optional decimal.

Ecommerce

Date: Purchased, Abandoned

Find or exclude users who made a purchase or left an abandoned cart across certain date ranges. For purchases, match users who made any purchase in the time range, or only their first-ever or latest purchase in the range.

Net Revenue

Find or exclude users whose purchase history accounts for total revenue above or below a certain dollar amount.

  • Select greater than (>) or less than (<), then enter a dollar amount with optional decimal.

Note: This feature requires that your purchase data is being sent to Sailthru using the Purchase API. Customers’ net revenue will only be updated to reflect returns if this data is also being sent to Sailthru using the Returns API.

Purchased Product Names, SKUs, Tags

Find or exclude users who purchased items that match a specific name, sku, other item ID, or item tag.

  • Select Name or SKUs to search across the following fields: the name of the item as it exists in the “title” field of the submitted purchase data or the SKU of the item as specified in an “sku” item var submitted with the purchase.
    • To search multiple names or SKUs (and find items matching at least one), separate your search terms with a pipe symbol. For example:
      Dress Shoes|SKU-1234|Dress Pants
  • Select Tag to search for items that match tags in your Content Library.
    • To search multiple tags, separate them with a pipe symbol. For example:
      Travel-deals|dining-deals

Purchased Price, Qty

Find or exclude users whose most expensive purchased item is greater or less than a specific price, or find or exclude users who have made more or less than a certain number of purchases (orders).

Custom Fields (vars): Order, Item

Find or exclude users who have made purchases that were recorded with a specific order or item field value. For example, orders where the promo field value is spring2017, or items where the size field value is large.

Engagement

Email Clicks, Opens, Sends

Find or exclude users based on when and how many times they clicked a link within an email, opened an email, or were sent email.

    • clicked will count any email click in the specified date range
    • last clicked will identify the user’s most recent click
      • “ever” will match all users who ever clicked, i.e. clicked one or more times
      • Setting date constraints will match users whose most recent click occurred within the specified date constraints
    • opened will count any email open in the specified date range
    • last opened will identify the user’s most recent email open
      • “no date constraints” will match all users who ever opened an email, i.e. opened one or more times
      • Setting date constraints will match users whose most recent email open occurred within the specified date constraints
    • messaged will count any email sent within the specified date range, whether a campaign or transactional message. Note that transactional sends from the past 24 hours may not be included in the total.

Engagement Level

Find or exclude users based on their engagement level(s), a measure of email and onsite activity. Select multiple levels to identify users who match any of those levels.

Site Visit

Find or exclude users based on whether, when, or how many times they have visited your site. 

  • visited identifies any site visits
  • last visited only identifies a user’s most recent site visit

Lists

Natural, Smart

Find or exclude users based on whether they are a member of a given natural or smart list, or not a member of any list.

To find or exclude users who are a member of one or more specific lists

  1. From the first drop-down, select Is on these lists.
  2. Click the second drop-down. The names of all your lists are displayed. Scroll to the desired list, or type part of a list name to filter the display. Click a list to select it. Repeat the process if you wish to select any additional list(s).
    Note: If you select multiple lists, the user must be on at least one of the selected lists to meet this criteria.

To find or exclude users who are not a member of one or more specific lists

  1. From the first drop-down, select Is NOT on these lists.
  2. Click the second drop-down. The names of all your lists are displayed. Scroll to the desired list, or type part of a list name to filter the display. Click a list to select it. Repeat the process if you wish to select any additional list(s).
    Note: If you select multiple lists, the user must be on at least one of the selected lists to meet this criteria.

To Find or exclude users who are not a member of any natural list

  • Click the first drop-down and select Not on any list.

User

Bounces, Marked Spam

Find or exclude users whose email sends have bounced or who have marked an email as spam.

Browser, Device, Mail Client, OS

Find or exclude users who have ever read email or visited your site using one or more specific types of device, operating systems, browsers, or email client applications.

Email Address, Domain

Find or exclude users whose email address contains any specific text or domain.

 

  • Select Address Contains to find email addresses by entering any part of the email address. For example, if you enter .co.uk, you will find any and all email addresses that contain this string of characters.
  • Select Domain is to find all email addresses that match the domain. For example, if you enter example.com, you will find any and all email addresses that end in @example.com.
    • Enter any domain in the Domains box to the right, then press Enter.
    • Enter multiple domains to Find or exclude users who match any that you have entered.
    • Use the rightmost drop-down to select from several popular email domains including gmail.com and yahoo.com.

Interest Rating

Find or exclude users who exhibit a specified degree of interest in one or more interest tags as compared to your average user. You can identify users who are more interested, less interested, or not interested at all. 

  • In the Interest Tags field, you can enter or search for a tag. You can select multiple tags. Click each tag in the search results drop-down, or select it using your arrow keys and press Enter.

Location

Based on recorded locations during each email click and site visit, find or exclude users who spend the majority of their time-or at least a certain percentage of time-in a specific area. Select one or more cities, states/regions, countries, or postal codes.

  • From the first drop-down, select whether you want to match a user who is identified at least 50%, 25%, 10%, or 1% of the time within the selected area.
  • From the second drop-down, select whether you want to match a City, Region/State, Country, or Postal Code.
  • From the last drop-down, type any part of the location to find and select it. You can optionally find and add multiple locations. Click each in the search results drop-down, or select it using your arrow keys and press Enter.

Mobile App

Find or exclude users who have opened any Sailthru-integrated mobile app associated with your account or a specific mobile app associated with your account.

  • Select Has Carnival device to match users whose email address is associated with a Carnival-integrated mobile app that is registered to your Sailthru account.
  • Select Opened ANY Sailthru SDK app to match users who have opened any of your Sailthru SDK-integrated apps.
  • Select Opened THESE Sailthru SDK apps to match users who have opened one or more specified Sailthru SDK-integrated apps. Use the drop-down to the right to select one or more of these apps.

Prediction Segment

Find or exclude users based on their Prediction Manager scores, representing predicted future actions or value. Each prediction is explained in the Prediction Manager documentation.

For the prediction that you select you can:

  • Identify users who have a predicted value–number or k-tile–above, below, or equal to a selected value, or
  • Identify users who match one of four automatically generated segments for the prediction, or who match your own custom segment created in the Prediction Manager interface. To access these segments, select “is” from the second drop-down.

Profile Key

Find or exclude users who have a specific key type on their user profile. Select from email, extid (external ID), sms, twitter, or fb. 

See this example user profile which contains an extid key, which can be set using the User API.

Radius to Location

Find or exclude users based on the location–based on a radius from a selected city or postal code–from which they most click emails or visit your site, last opened your mobile app, or match a specific location var value in the form of a postal code and associated country code.

When entering a postal code, the country code is optional for US zip codes. For example, the following values will work for a US zip code: 10011 or 10011 US. The following value will work for France: 75008 FR.

Subscription Date

Find or exclude users based on the date or date range during which they subscribed to any list, subscribed to your list(s) for the first time, or unsubscribed from any list.

Subscription Status

Find or exclude users who are marked as valid (whose status is not optout-all or hardbounce) or who have a particular optout status (all emails, mass mail, mass mail only, or a specific template).

Top