Understand Filters With "Where" Clauses

"Where" clauses allow you to filter an analysis by a specific value or values within an event property or user 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 user 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 (known as tags) in one "Where" clause. These may be used when the "Where" clause options "Contains" or "Does Not Contain" are selected.

Using |

Contains_values_tags_1.gif

Separate multiple tags by typing the symbol "|" (shift+\), clicking the value in the autocomplete dropdown, or typing the return/enter/tab key to indicate at least one tag must match to be included in results.

For example, to include only users who completed "Blog View" and whose marketing channel was Direct, Organic, or Affiliate, select "contains", type each tag and then either type "|", hit the return/enter/tab key, or click on the value in the dropdown to create a tag.

Using &

Contains_Values_Tags_2.gif

Separate multiple tags by typing the symbol "&" (shift+7), clicking the value in the autocomplete dropdown, or typing the return/enter/tab key to indicate that all tags must match to be included in results.

For example, to include only users who completed "Subscribe" and whose kitty's dietary preferences included both "dry" and "organic", select "contains", type each tag, and then either type "&", hit the return/enter/tab key, or click the value in the dropdown to create a tag.

Alternatively, you can also select the "& AND" button to the right to automatically change all of your operators from the "|" to "&".

By default, the "|" operator is used when you select "contains". The default for "does not contain" is the "&" operator.

Updating and removing tags

Contains_Values_Tags_3.gif

You can use the backspace key (on Windows) or delete key (on Mac) to remove the last tag or click the "x" to remove any tag. To update an individual tag, click on it and make your edits.

 

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