query_segmentation_report
Analyze event data by segmenting and filtering based on user properties. Use this tool to compare performance across user groups, identify trends, and extract actionable insights from Mixpanel analytics.
Instructions
Get data for an event, segmented and filtered by properties. Useful for breaking down event data by user attributes, comparing performance across segments, and identifying which user groups perform specific actions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| event | Yes | The event that you wish to get data for. Note: this is a single event name, not an array | |
| format | No | Can be set to 'csv' | |
| from_date | Yes | The date in yyyy-mm-dd format to begin querying from (inclusive) | |
| interval | No | Optional parameter in lieu of 'unit' when 'type' is not 'general'. Determines the number of days your results are bucketed into | |
| limit | No | Return the top property values. Defaults to 60. Maximum value 10,000. This parameter does nothing if 'on' is not specified | |
| on | No | The property expression to segment the event on | |
| project_id | No | The Mixpanel project ID. Optional since it has a default. | |
| to_date | Yes | The date in yyyy-mm-dd format to query to (inclusive) | |
| type | No | The type of analysis to perform, either general, unique, or average, defaults to general | |
| unit | No | The buckets into which the property values that you segment on are placed. Default is 'day' | |
| where | Yes | An expression to filter events by based on the grammar: <expression> ::= 'properties["' <property> '"]' | <expression> <binary op> <expression> | <unary op> <expression> | <math op> '(' <expression> ')' | <string literal> <binary op> ::= '+' | '-' | '*' | '/' | '%' | '==' | '!=' | '>' | '>=' | '<' | '<=' | 'in' | 'and' | 'or' | <unary op> ::= '-' | 'not' | |
| workspace_id | No | The ID of the workspace if applicable |