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

i5.gif

Query Rows represent user actions. A row may contain 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

i6.gif

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

i7.gif

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

i8.gif

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

i10.gif

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

i11.gif

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

i12.gif

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

i13.gif

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"

 

0 users found this helpful