The Segment Builder lets you compare and constrain values using selected operators. There are three categories of operators: Standard, Data Warehouse, and Distinct Count.
The only supported wildcard character is the asterisk: *. If you need to search for *, you can escape it with a backslash.
Operator
The selected dimension, segment, or metric event鈥
equals
Returns items that match exactly for a numeric or string value. Note: If using wildcard characters, use the 鈥渕atches鈥 operator.
does not equal
Returns all items that do not contain the exact match of the value entered. Note: If using wildcard characters, use the 鈥渄oes not match鈥 operator.
equals any of
Returns items that match exactly for any value in the input field (up to 500 items). For example, entering 鈥淪earch Results, Homepage鈥 with this operator would match 鈥淪earch Results鈥 and 鈥淗omepage鈥, and count as 2 items. The input field for this operator is comma-delimited.
does not equal any of
Identifies items that match exactly for any value in the input field (up to 500 items), and then only returns items without these values. For example, entering 鈥淪earch Results, Homepage鈥 with this operator would identify 鈥淪earch Results鈥 and 鈥淗omepage鈥 and then exclude them from the returned items. This example would count as 2 items. The input field for this operator is comma-delimited.
contains
Returns items that compare to the substrings of the values entered. For example, if the rule for 鈥淧age鈥 contains 鈥淪earch鈥, then it will match any page that has the substring 鈥淪earch鈥 in it, including 鈥淪earch Results鈥, 鈥淪earch鈥, and 鈥淪earching鈥. The 鈥渃ontains鈥 clause is not case sensitive in 51黑料不打烊 Analytics, but it is case sensitive in Customer Journey Analytics.
does not contain
Returns the inverse of the 鈥渃ontains鈥 rule. Specifically, all items that match the entered value will be excluded from the entered values. For example, if the rule for 鈥淧age鈥 does not contain 鈥淪earch鈥, then it will not match any page that has the substring 鈥淪earch鈥 in it, including 鈥淪earch Results鈥, 鈥淪earch鈥, and 鈥淪earching鈥. These values will be excluded from the results.
contains all of
Returns items compared to the substrings, including multiple values joined together. For example, entering 鈥淪earch Results鈥 with this operator would match 鈥淪earch Results鈥 and 鈥淩esults of Search鈥, but not 鈥淪earch鈥 or 鈥淩esults鈥 independently. It would match Search AND Results found together. The input field for this operator is space-delimited (100 words).
does not contain all of
Identifies items compared to substrings鈥攊ncluding multiple values joined together鈥攁nd then only return items without these values. For example, entering 鈥淪earch Results鈥 with this operator would identify 鈥淪earch Results鈥 and 鈥淩esults of Search鈥 (but not 鈥淪earch鈥 or 鈥淩esults鈥 independently) and then exclude these items. The input field for this operator is space-delimited (100 words).
contains any of
Returns items compared to the substrings, including multiple values joined or independently identified. For example, entering 鈥淪earch Results鈥 with this operator would match 鈥淪earch Results鈥, 鈥淩esults of Search鈥, 鈥淪earch鈥, and 鈥淩esults鈥. It would match either 鈥淪earch鈥 OR 鈥淩esults鈥 found together or independently. The input field for this operator is space-delimited (100 words).
does not contain any of
Identifies items based on substrings and then returns values that do not contain these substrings. It can have multiple joined values or values independently identified. For example, entering 鈥淪earch Results鈥 would match 鈥淪earch Results鈥, 鈥淩esults of Search鈥, 鈥淪earch鈥, and 鈥淩esults鈥 where either 鈥淪earch鈥 or 鈥淩esults鈥 are found together or independently. It would then exclude items that contain these substrings. The input field for this operator is space-delimited (100 words).
starts with
Returns items that start with the character or strings of the value entered.
does not start with
Returns all items that do not start with the characters or strings of the values entered. This is the inverse of the 鈥渟tarts with鈥 operator.
ends with
Returns items that end with the character or strings of the value entered.
does not end with
Returns all items that do not end with the characters or strings of the value entered. This is the inverse of the 鈥渆nds with鈥 operator.
matches
Returns items that match exactly based on a given numeric or string value. The 鈥渕atches鈥 clause is case sensitive in 51黑料不打烊 Analytics and in Customer Journey Analytics. Note: Use this operator when using wildcard (globbing) features. Examples of 鈥済lobbing鈥:
a*e
would match ae
, abcde
, adobe
, and a whole sentence
adob*
would match adobe
, adobe analytics
, and adobo recipe
*dobe
would match dobe
, adobe
, and cute little dobe
does not match
Returns all items that do not contain the exact match of the value entered. Note: Use this operator when using wildcard (globbing) features.
exists
Returns the number of items that exist. For example, if you evaluate the Pages Not Found dimension using the 鈥渆xist鈥 operator, the number of error pages that exist is returned.
does not exist
Returns all items that do not exist. For example, if you evaluate the Pages Not Found dimension using the " does not exist" operator, the number of pages where this error page did not exist is returned.