The Query Builder is where Indicative analyses are built. It is located at the top of the Segmentation, Funnel, Cohort, and User Insights tools.
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 click on + Select an Event
Once an event is added, additional clauses and filters may be added:
- Understand Breakouts with By Clauses
- Understand Filters With Where Clauses
- Modify Filters With And/Or Clauses
Label a Query Row
Each query row may have a custom annotation 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, added to a dashboard, or shared via URL.
Collapse the Query Builder
To collapse the query builder, choose the collapse icon. It is located on the right hand side of the query builder at the bottom of the query rows. Collapsing the query row does not affect the analysis, it only reduces the size of the query builder. To expand the query builder again, select the expand 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 Filter Where clauses. Use custom events to save query rows that you create frequently.
To be saved as a custom event, a row:
- Must contain 1 event, and no For clauses
- May contain an unlimited number of Where clauses
- Must not contain By clauses
Once saved, the new event will appear in the Data Panel.
Duplicate a Query Row
When creating variations of an existing row, Duplicate in the query row menu enables you to easily clone rows for modification.
Deactivate 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.
To deactivate a row, go to the right of the event and select the deactivate button. You can reactivate the row by selecting the Activate button
Delete a Query Row
Deleting a query row will permanently remove it from the query. To delete a row, navigate to the right side of an event and choose the delete button.