Query Builder Features

Mixpanel offers some advanced functionality that is available across multiple report types. 

Custom Event Creation

Click Create Custom Event from the bottom of the events drop-down to create a custom event. Learn more about building custom events here.

Session Metric Analysis

Analyze session metrics by selecting "Session Start" or "Session End" from the events list. Learn more about using Sessions in Insights, Funnels and Flows here.

Inline Filtering

Filter this event by clicking the inline action menu and selecting Add filter from the drop-down. Choose an event property, user profile property, group profile property, or cohort to filter the event by.

You can select whether you would like your query to match any or all of the filters by clicking on and/or beside the filters.

Duplicating Events

To duplicate any events or properties in your query, select the inline action menu and choose Duplicate. Delete any events or properties by clicking the trash icon.

Advanced Date and Time Selectors

You can also choose how Mixpanel buckets the time range in Insights, Funnel Trends and Retention Trend reports (granularity may vary). To view a range in hours, you can select Hour as the view: 

To zoom in, click on the graph and drag to highlight a specific window of time in your report. Click Reset zoom to return to the previous view.

Advanced Filter & Breakdown Usage

To filter the results of your Insights query click the Filter button and select an event property, user profile property, group profile property, or cohort to filter the event or profile by.

To breakdown your results click the Breakdown button and select an event property, user profile property, group profile property, or cohort to filter the event by.

You can breakdown your results by the "Date" event property and breakdown by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week. 

If you are analyzing any custom events, you can breakdown by the property "Event Name".

The drop-down menus only shows events/event properties that were ingested within the last 30 days. To select events/event properties that have not been ingested in the last 30 days, type the name of the event/event property in the Filter or Breakdown search bar. You must know the exact name of the event/event property you want to select because event names are case sensitive. 

To create a temporary cohort for the current report, click Create Custom... in the dropdown menu and select "Cohort. A window will pop up where you can specify the restrictions of your cohort. Learn more about building a cohort here.