Query Builder Overview I

The Query Builder is where Indicative analyses are built. It is located at the top of the Segmentation, Funnel, Cohort, and User Insights tools, and is distinguishable by its bright teal color. 

In this article we'll explore the functions of query rows, the core components of an Indicative analysis. 

Rows in the Query Builder


Query Rows represent user actions. A row may contain any combination of events, event properties and user properties. Rows in the query builder are numbered for easy identification in analysis results.

Create a Query Row


Every row begins with an initial event. To add an event to a query builder, you can:

  • Drag and Drop into the Chart
  • Drag and Drop into the Query Builder
  • Double Click on an Event

Once an event is added, additional clauses and filters may be added to it:


Label a Query Row


Each query row may have a custom label added to it. This allows you to organize your analysis, improve readability, and ensure that data points in analysis results are appropriately labeled. These labels remain a part of the query when saved as a Bookmark, Dashboard, or shared via URL.

Collapse a Query Row


To collapse a query row, click on the minus sign icon. It is located on the lefthand side of the query row. Collapsing a query row does not affect the analysis, it only reduces the size of the row in the query builder. To expand a collapsed row, click the plus icon.

Save a Query Row as a Custom Event


Some query rows may be saved as custom events. Query rows may be saved as custom events if they consist of a single event and/or contain one or more "Where" clauses. Use custom events to save query rows that you create frequently.

To be saved as a custom event, a row:

Once saved, the new event will appear in the Data Panel. 

Duplicate a Query Row


When creating variations of an existing row, "Duplicate Row" in the Query Row Menu enables you to easily clone rows for modification.

Hide a Query Row


Hiding a query row excludes it from analysis results, but does not delete it. This can be useful for viewing analysis components individually, or tentatively excluding rows as you progress through an analysis.

There are two ways to hide a query row:

  • Click the icon with the query row number at the far left end of the row.
  • Open the Query Row Menu and click "Hide Row"

Delete a Query Row


Deleting a query row will permanently remove it from the query. There are two ways to delete a query row:

  • Click the "x" in the initial event in the query row.  
  • Open the Query Row Menu and click "Delete Row"


1 users found this helpful