Event and Property Menu in Query Builder

Event and property menus are used across all Mixpanel reports to build queries. This article will walk you through the key features of the menus.

Sorting of Events and Properties

You can sort the menu by:

  • Relevancy: Sorting based on an algorithm that factors in relevance, recency, and frequency of use in your project

  • Name A-Z: Sorting based on name starting with A

  • Name Z-A: Sorting based on name starting with Z

Filtering Data by Events

By default, the event menu shows all events, except for hidden events

If you organize your events using tags in Lexicon, the tags will show up as filtering options in the event menu. When you select a tag, a list of events that share the same tag appears:

Untitled__1_.png

Filtering Data by Properties

By default, the menu shows "all properties". This includes event properties, profile properties, group properties, lookup properties, cohorts. 

You can select the following filtering options to show a subset of the properties in the menu:

  • Select "event properties" to show only the Event properties.

  • Select "user properties" to show only the Profile properties.

  • Select "cohorts" to show only the Cohorts.

  • If you set up Group Analytics, the Group keys will show up individually under their display names. You can select any Group key to show only the Group properties relevant to the selected Group key:

     Mixpanel__project_3____Mixpanel_2021-11-18_12-00-58.png

Understanding Prefixes in the Menu

The events and properties in the menu are prefixed to provide additional context about the properties' type. They will be removed when additional context is not needed. 

  • Event properties are not prefixed (except in User report's menu): 

    Screen_Shot_2021-11-18_at_12.26.25_PM.png

  • User properties are prefixed by "User": 

    Screen_Shot_2021-11-18_at_12.25.13_PM.png

    "User" prefix is removed in User report's menu or once you filter the menu by "user properties". 

  • Cohorts are prefixed by "In Cohort": 

    Mixpanel__project_3____Mixpanel_2021-11-18_12-36-35.png

    "In Cohort" prefix is removed once you filter the menu by "cohorts". 

  • Group profile properties are prefixed by the Group key display name: 

    Screen_Shot_2021-11-18_at_12.37.54_PM.png

    Group key prefix is removed once you filter the menu by a specific Group key. 

  • Lookup properties are prefixed by the mapped property. Let's say "Timezone" is mapped to a Lookup Table that contains "UTC Offset" and "UTC Offset (DST)", these lookup properties will be prefixed by "Timezone"

    Screen_Shot_2021-11-18_at_12.29.00_PM.png

  • Lookup properties can also be prefixed by both "User" and the mapped property to indicate that they are lookup properties of a user property

    Screen_Shot_2021-11-18_at_12.29.06_PM.png

Event and Property Menu in Users Report

Selecting Events and Properties

In User report, you can select the event or properties from the same menu, 

screencast_2021-12-03_09-55-37.gif

To select events, type the event directly in the menu or filter the menu by "users who did" option, 

Nutrafol_-_Production___Explore_Profiles_-_Mixpanel___Product_Analytics_2021-11-18_11-51-45.png

 

Prefixes in the Users Report's Menu

  • User properties are not prefixed

    Screen_Shot_2021-11-18_at_12.26.25_PM.png

  • Events are prefixed by "Event"

    Screen_Shot_2021-12-03_at_10.06.55_AM.png

You can learn more about prefixes here.  

Create Custom Event

  1. Click on +Add > Select event to open the event menu:

    Untitled__1_.png

  2. Click on the "Create Custom" button located at the bottom of the event menu:

    Untitled__2_.png

Create Custom Properties

  1. Click on the filter icon to open the property menu:

    Screen_Shot_2021-11-18_at_10.36.20_AM.png

  2. Click on "Create Custom..." button located at the bottom of the property menu:

    Mixpanel__project_3____Mixpanel_2021-11-18_10-40-46.png

  3. In the submenu, click on "Event Property" to create a custom event property and "User Property" to create a custom user property.

Create Cohorts

  1. Click on the filter icon to open the property menu:

    Screen_Shot_2021-11-18_at_10.36.20_AM.png

  2. Click on "Create Custom..." button located at the bottom of the menu.

    Mixpanel__project_3____Mixpanel_2021-11-18_10-44-36.png

  3. In the submenu, click on "Cohort" to create Cohorts.

Hidden Events and Properties

By default, hidden events and properties are not displayed in the menu. To use them in your query, you can:

  1. Do a keyword search for the events or properties.

  2. Find them in the "Show Hidden Events" or "Show Hidden Properties" menu item which is located at the bottom of the menu,

    mixpanel.com_project_2195193_view_139237_app_insights__6_.png

Context Panel

When hovering over an event, property, or cohort in the menu, you will see Context Panel with applicable Lexicon Information such as i.e. Display Name, Description.

Untitled__3_.png

Selecting Event or Property not displayed in the menu (Specifying)

Events and event properties that have not been sent to your project in 30 days will automatically be hidden from the menu.

The events and properties are still available in the project's raw data, but will not be visible in the UI.

To select these events and properties not shown in the menu, you can specify the names by:

  1. Typing in the tracked event name or property name (case sensitive) within the menu

  2. Click on the name in the menu

screencast_2021-11-17_15-48-50.gif

Did this answer your question?

Comments

0 comments

Please sign in to leave a comment.