Skip to main content
Loading...
Skip to article
  • Qualtrics Platform
    Qualtrics Platform
  • Customer Journey Optimizer
    Customer Journey Optimizer
  • XM Discover
    XM Discover
  • Qualtrics Social Connect
    Qualtrics Social Connect

Fields You Can Filter By


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


Qtip: This page refers to filtering in XM Directory only.

Fields You Can Filter By

Finding contacts and lists within the directory is made easier by filtering. You can use a simple filter to find a specific person, list, or segment, or you can build incredibly complex filters to be saved and re-used for later. When filtering your directory, there are many fields you can choose from to narrow down your search.

Qtip: This page includes the fields that you can filter by. To view fields that can be used to search contacts, see Searching Contacts.

When filtering by Contact Activity, Number of Lists, Survey Response, and Survey Status, the search will occur in the background instead of immediately. For these fields we recommend saving and naming the filter so you can easily access it when the search is complete.

viewing results of an advanced search

The search will be present in the tasks bar of your directory. Click Show results to see the contacts that match your filter criteria.

Attention: The first time you perform this kind of search it may take a while for the results to load. If it takes more than a couple hours, reach out to Qualtrics Support.
Qtip: These search results will be available for 1 week.

Contact Activity

Attention: This feature is not included in every license. Please contact your Account Executive if you are interested in getting access.
Qtip: This criteria cannot be used to filter automation recipients.

The contact activity field filters by activity for each contact within a specified date range. You can filter by total emails, total invites, or total responses.

setting up an advanced filter based on contact activity

Qtip: This filter field only looks at contact activity within the last year.

Contact Info

The contact info field filters by basic contact info. The available contact info fields are:

  • Email
  • First name
  • Last name
  • External data reference
  • Language
  • Phone
  • Email domain

setting up an advanced filter based on contact info

Embedded Data

The embedded data field filters by embedded data within the directory. Use the dropdown to select existing embedded data fields or demographics.

setting up an advanced filter based on embedded data

Attention: Filtering embedded data with “does not contain” or “not equal to” conditions will display contacts that meet the criteria and also have a value for that field. Any contacts that do not have a value for the specified embedded data field will not be displayed. To search for blank embedded data fields, you must use the “empty” filter condition. empty filter condition

Date and Time Data

If you have embedded data saved in a date format, you can use a filter to search for future dates or dates that happened recently. To search by date, the date field must be in ISO-8601 format, with times in UTC. (I.e., YYYY-MM-DDT-HH:mm:ss+ZZZZ . More information about these symbols can be found on the Date Format Syntax support page).

Example: Let’s say our date is March 31, 2021 at 9:00:00AM EDT (UTC-4). This date in ISO-8601 format is 2021-03-21T13:00:00.000Z. Note how the time has been converted from EDT to UTC.

When filtering by date comparisons, you will be able to filter In the past “n” number of Days/Weeks/Months/Years or In the next “n” number of Days/Weeks/Months/Years.

Example: To look for contacts with a recent renewal date, you can create a filter to search for contacts with “Renewal Date In the past 5 Days”.searching for contacts with “Renewal Date In the past 5 Days”

Enrichment Data

Enrichment data provides a deeper understanding of transactional data for your contact. To use enrichment data, add a transaction field filter. 

Highlights the enrichment data that is available from the transactions filter

The enrichment data fields below are currently available for filtering and segmenting:

Example: To create filter for contacts who have displayed negative sentiment in their feedback in the past week, you should use enrichment data in addition to transaction date data. This could be helpful to pinpoint disappointed users who could use extra care in the future.
Example of a filter with enrichment data
Qtip: A filter cannot be made based on the “number of transactions” unless transaction condition is already created. Number of transactions is greyed out

Mailing List

The mailing list field filters for contacts within or not within specific mailing lists. You can also select certain samples to search within the list.

setting up an advanced filter based on mailing list criteria

Number of Lists

Qtip: This criteria cannot be used to filter automation recipients.

The number of lists field filters by the number of lists a contact belongs to.

setting up an advanced filter based on number of lists

Attention: This feature is not included in every license. Please contact your Account Executive if you are interested in getting access.

Opt-Out Status

The opt-out status field filters by whether or not a contact is opted in or out of the entire directory (not a specific mailing list).

setting up an advanced filter based on opt-out status

Private List Data

Qtip: This field can only be used to search data in lists, not the whole directory.

The private list data field filters by whether or not a contact has a specific attribute for a private data field. Private data is only visible to users with access to the mailing list it exists in.

advanced search with private list data used as search criteria

Attention: Private list data must be enabled in Directory Settings before it can be added to lists.

Statistics

The statistics field allows you to filter by various statistics, including:

  • Created: When the contact was created.
  • Last modified: When the contact was last modified.
  • Last email: When the contact received their last email from your brand.
  • Last invite received: When the contact received their last invite from your brand.
  • Last response: When the contact provided their last survey response.
  • Total emails: Total number of emails the contact has received.
  • Total invites: Total number of invites the contact has received.
  • Total responses: Total number of responses the contact has provided.
  • Response rate: Response rate for the contact. This statistic is in percentages (0-100), but doesn’t require a percept ( % ) symbol.
  • Average response time: Average response time for the contact (in hours or days).

setting up an advanced filter based on statistics

Attention: Date based statistics can only be filtered for dates within the last year.
Qtip: Only numbers and decimals can be used as values in greater then/less than filters.

Survey Response

Qtip: This criteria cannot be used to filter automation recipients or to create samples.

The survey response status field filters by the response of each contact to a specific survey. After selecting a specific survey to search within, you can filter by a specific survey question, response date, or number of responses to the survey.

Qtip: Only surveys created by you or shared with you will be available for selection.

Survey Question

After selecting a specific survey, select Question. You can then filter your contacts by their response to a specific survey question within that survey.

adding a new survey filter

Qtip: Click New survey filter to add another survey question condition to your filter. A maximum of 10 survey filter conditions can be added.

Response Date

After selecting a specific survey, select Date of response. You can then filter your contacts by the date they responded to this survey.

adding a response date filter

Attention: You can only have 1 response date condition within a filter.

Response Count

After selecting a specific survey, select Number of responses. You can then filter your contacts by the number of times they responded to this survey.

setting up a response count filter

Attention: You can only have 1 response count condition within a filter.

Survey Status

The survey status field filters by the status of each contact within a specific survey. You can filter by survey completion or invite sent status.

setting up an advanced filter based on survey status

Qtip: Surveys are marked as completed when they have the “survey finished” status. This status is given to responses that are fully completed, partially completed, or expired.

You can also filter by date fields when creating samples or automations, allowing you to filter by the survey status of each contact within a specific survey and specific time range. Date fields are not available when searching in the directory.

Attention: This feature is not included in every license. Please contact your Account Executive if you are interested in getting access.

Transactions

Qtip: This criteria cannot be used to filter automation recipients.

The transaction field filters based on transactional data. Once you choose to filter based on transactions, you can then choose whether to filter by:

setting up an advanced filter based on transactions

Example: You may want to filter for contacts that visited your Seattle location in a certain time frame. In the above example, we filter for customers that visited the Seattle location more than 3 times before December 20, 2020.

When creating a new segment, you will also be able to filter In the past “n” number of Days/Weeks/Month/Years.

Qtip: Click the date text to enter a specific date or click on the calendar icon to the right of the date field in order to select a specific date from a calendar. The date must be saved in ISO 8601 format in the UTC time zone. More details on time zone formatting on the Transactions page.adding transaction date to the filter
Qtip: When filtering by multiple transaction fields, your filter conditions are separated by an implicit “and,” meaning all conditions must be true.

 

Filtering Date Fields

You can filter by a lot of different parameters when you’re filtering by date. This section refers to filters that can be built with embedded data, transaction date, survey response, and contact statistic conditions.

Qtip: In order for these filters to work, dates must be formatted ISO-8601 format, with times in UTC.

image of conditions as they appear in many parts of the platform. transactions and then transaction date is selected, but then the next dropdown is expanded to show the options listed below

  • On or after: Include the date selected and all dates after. You can also choose a number of past days, weeks, or years to include.
    Example: Filter for all contacts that were last modified in the last 15 days.
    Screenshot shows a condition that says show only contacts that meet the following criteria: last modified on or after the past 15 days
    Example: Filter for contacts who submitted survey responses to your CSAT survey on or after March 7, 2023.
    Screenshot shows a condition that says show only contacts that meet the following criteria: response to 2022 survey date of response is one or after a specific date - march 7 at midnight pacific time
  • Before: Include all contacts from before a selected date or timeframe.
    • The past: Include all contacts, except those whose dates match a timeframe set in the past.
      Example: You want to include all contacts created in the past except those made in the last 2 weeks.
      Screenshot shows a condition that says show only contacts that meet the following criteria: created before the past 2 weeks
    • The next: This option is only available for embedded data and transaction dates. Include all contacts, except those whose dates match an upcoming timeframe.
      Example: You want to include all contacts except those whose arrival date will be coming up in the next 15 days.
      Screenshot shows a condition that says show only contacts that meet the following criteria: embedded data arrival date is before the next 15 days
    • A specific date: Include all contacts whose dates match before a specific date.
      Example: Filter for contacts who submitted survey responses to your CSAT survey before January 1, 2023.
      Screenshot shows a condition that says show only contacts that meet the following criteria: response to CSAT 2020 survey's date of response is before a specific date march 1 2023 at midnight, pacific time
  • In the past: Choose the past number of days, weeks, or years the results should fall under.
    Example: Filter for contacts whose arrival date was in the past 1 year.
    Screenshot shows a condition that says show only contacts that meet the following criteria: embedded data arrival date is in the past 1 year
  • Between: Only include results within a certain timeframe.
    • Specific dates: Choose 2 dates that your results should fall between.
      Example: View contacts whose transactions happened between February 1, 2023 and March 1, 2023.
      Screenshot shows a condition that says show only contacts that meet the following criteria: transaction date is between specific dates february 2 and march 1 2023
    • A time period: Filter for dates that take place between time periods set in the future. Using negative values (e.g., -2) allows you to indicate a time period in the past.
      Example: Filter for contacts whose arrival date is going to be no less than 2 days but no more than 3 weeks into the future.
      Screenshot shows a condition that says show only contacts that meet the following criteria: embedded data arrival date is between a time period 2 days and 3 weeks
      Example: Filter for contacts whose arrival date is between 2 days in the past and 4 weeks in the future.
      Screenshot shows a condition that says show only contacts that meet the following criteria: embedded data arrival date is between 2 days in the past and 4 weeks in the future
  • In the next: This option is only available for embedded data and transaction dates. Choose the upcoming number of days, weeks, or years the results should fall under.
    Example: Filter for contacts whose arrival date is in the next 3 weeks.
    Screenshot shows a condition that says show only contacts that meet the following criteria: embedded data arrival date is in the next 3 weeks