segmentation_average
Calculate average values of numeric event properties over time in Mixpanel analytics. Use to track metrics like order value averages across specified date ranges and filters.
Instructions
Get the average of a numeric event property over time. Useful for tracking averages like order value.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| event | Yes | Event name | |
| from_date | Yes | Start date (YYYY-MM-DD) | |
| to_date | Yes | End date (YYYY-MM-DD) | |
| on | Yes | Numeric property to average (e.g. "properties[\"duration\"]") | |
| unit | No | Time unit for bucketing | |
| where | No | Filter expression |