Understand Filters With "Where" Clauses

"Where" clauses allow you to filter an analysis by a specific value or values within an event property or people property. In contrast with "By" clauses, which break out an event using all possible values of the selected property, "Where" clauses search for values that you specify in the query row.  

"Where" Clause by Tool

For example, to find users who performed an event and who are in AB Testing group A, drag the event property "AB Testing" into the "Where" clause drop zone. Next, complete the "Where" clause by selecting "Group A" as the people property value. This excludes users in Group B from analysis results.

"Where" Clause in Segmentation

j6.gif

 

"Where" Clause in Funnel

j7.gif

 

"Where" Clause in Cohort

A cohort query contains two rows, the first one being the cohorting action and the second one being the target action. A "Where" clause may be applied to either of these rows.

j9.gif

 

Filtering Options

Filtering options differ depending on whether the selected property's values are numeric or string values.

  • Numeric Value: A value that contains only numbers. Numeric values may be used in calculations. For example, values under the property "Age" containing specific price information are numeric values. 
    •   
  • String Value: A value that contains letters, numbers, or other characters. String values are not used in calculations. For example, a User ID consisting only of numbers is a string value. Another example of a string value is a user's AB Testing group.

By default, properties are automatically sorted into these categories. To manually set property's value type, see Settings.

j10.gif

When filtering by a string value, select one of the following options:

  • “Is equal to” displays data for values equal to that specific property value.
  • “Contains” displays data where the string contains the selected property value.
  • “Does not contain” displays all data that does not include the selected property value.
  • “Is defined” displays all data where there are values for the selected property value.
  • “Is not defined” displays all data where there are no values for a selected property.

j11.gif

When filtering by a numeric value, select one of the following options:

  • “Is equal to” displays data for values equal to that specific property value.
  • “Is not equal to” displays data for values that are not equal that specific property value.
  • “Is greater than” displays all data for values greater than the selected property value.
  • “Is less than” displays all data for values less than the selected property value.
  • “Is greater than or equal to” displays all data for values that are greater than or equal to the selected property value.
  • “Is less than or equal to” displays all data for values that are less than or equal to the selected property value.
  • “Is defined” displays all data where there are values for the selected property value.
  • “Is not defined” displays all data where are no values for a selected property.

 

Filter for Multiple Values

When using string values, the | and & symbols may be used to include multiple values in one "Where" clause. These may be used when the "Where" clause options "Contains" or "Does Not Contain" are selected.

Using |

j12.gif

Separate multiple values using the symbol "|" (shift+\) to indicate at least one value must match to be included in results. For example, to include only users who completed "View Content" and whose marketing channel was Affiliate or Organic, select "contains" and type "Affiliate | Organic" 

Using &

j14.gif

Separate multiple values using the symbol "&" (shift+7) to indicate that all values must match to be included in results. For example, to include only users who completed "View Content" and whose platform included both Desktop and Android, select "contains" and type "Desktop & Android" 

 

Note

In the Event Properties Library, you may set an individual property's data type as a "string" or "numeric" value. This overrides Indicative’s auto-detection.

0 users found this helpful