The Data Dictionary and the Properties Explorer are two helpful tools located to the right of the query builder. Both tools can be used to reference the data model while building queries. Both tools are enabled as pullout sidebars. To view either the Data Dictionary or Properties Explorer, click on the icons highlighted below.
The Data Dictionary is a simplified view of the Events and Properties Manager. Once you click on the Data Dictionary icon, a menu will appear to the right of the query builder.
Here, you can toggle to view your events, event properties, user properties and user segments. Use the search bar to quickly find what you're looking. Please note that the data dictionary is used as a referential tool.
You may also access Details about each item by clicking on it. This will open a new modal, containing important information, such as the Event Key, Display Name, Description, Category, and Associated Properties or Associated Events. Users with Owner or Admin access can edit this information within the Data Dictionary or they can open the Events and Properties manager by clicking Settings, then Events and Properties.
The Properties Explorer is a valuable tool for many reasons. Among many, you can use the Properties Explorer to:
- Understand the composition of users performing a certain event
- Explore your data set for interesting property breakouts
To open the Properties Explorer, click on the icon to the right of your query builder. Once you have done so, a menu will appear on the right hand side of your screen.
The Properties Explorer will then guide you to select an event from your query visualization area in which to explore. Once you have selected an event, the Properties Explorer will display all properties associated with that event, along with its most common property values. You can also open the Properties Explorer by clicking into a data point from your visualization area, and then selecting “Explore Properties”.
Please note that the Properties Explorer is not available for queries with calculated query rows, group by clauses, and histograms.