DocumentationCustomer Journey AnalyticsCustomer Journey Analytics Guide

Operators

Last update: Mon Sep 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

The Filter builder lets you compare and constrain values for components using selected operators. There are two categories of operators: Standard and Distinct Count.

Standard operators

Operator
Description
equals
Returns items that match exactly for a numeric or string value. If using wildcard characters, use the matches operator.
does not equal
Returns all items that do not contain the exact match of the value entered. If using wildcard characters, use the does not match operator.
equals any of
Returns any items that contain the match of the substring values entered, delimited by a comma.
contains
Returns items that compare to the substrings of the values entered. For example, if the value for a Page Name dimension contains Search, this operator matches any page that has the substring Search in its name, including Search Results, Search, and Searching. This operator is case-sensitive.
does not contain
All items that match the entered value are excluded from the results. For example, if the value for a Page Name dimension does not contain Search, this operator excludes any page that has the substring Search in its name, including Search Results, Search, and Searching.
contains all of
Returns items that include all substrings (separated by a space) in any order. For example, specifying Search Results as the value for this operator would match Search Results and Results of Search, but not Search or Results independently. This operator supports up to 100 words delimited by spaces.
does not contain all of
All items that match every entered value are excluded from the results. For example, specifying Search Results as the value for this operator would exclude Search Results and Results of Search, but not Search or Results. This operator supports up to 100 words delimited by spaces.
contains any of
Returns items that contain any of the specified substrings. For example, specifying Search Results as the value for this operator would match Search Results, Results of Search, Search, and Results. This operator supports up to 100 words delimited by spaces.
does not contain any of
All items that match any substring are excluded from the results. For example, specifying Search Results as the value for this operator would exclude Search Results, Results of Search, Search, and Results. This operator supports up to 100 words delimited by spaces.
starts with
Returns items that start with the character or strings of the value specified.
does not start with
Returns all items that do not start with the characters or strings of the value specified.
ends with
Returns items that end with the character or strings of the value specified.
does not end with
Returns all items that do not end with the characters or strings of the value specified.
matches

Returns items that match items exactly based on a given numeric or string value. Supports wildcards using an asterisk (*). This operator is case sensitive. For example:

  • a*e matches ae, abcde, adobe, and a whole sentence.
  • adob* matches adobe, adobe analytics, and adobo recipe
  • *dobe matches dobe, adobe, and cute little dobe.
does not match
All items that match the string are excluded. Supports wildcards using an asterisk (*).
exists
Returns items if the value is not null.
does not exist
Returns items if the value is null.

Distinct Count operators

You can filter on a distinct count of items within a dimension. For example, you can create filters for persons who viewed more than 5 distinct products or visits where more than 5 distinct pages were seen.

Operator
Description
equals
Returns dimension items whose unique count equals the value entered.
does not equal
Returns dimension items whose unique count does not equal the value entered.
is greater than
Returns dimension items whose unique count is greater than the value entered.
is less than
Returns dimension items whose unique count is less than the value entered.
is greater than or equal to
Returns dimension items whose unique count is greater than or equal to the value entered.
is less than or equal to
Returns dimension items whose unique count is less than or equal to the value entered.
recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79