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 pull outs; to view either the Data Dictionary or Properties Explorer, click on the icons highlighted below.
The Data Dictionary is a toned down view of your Events and Properties Manager. Once you click on the Data Dictionary icon, a menu will appear to the right of your query builder.
Here, you can toggle between viewing your events, event properties, user attributes and user segments. Use the search function to narrow down your view. Please note that the data dictionary is used as a referential tool.
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.