aggregate_event_counts
Analyze event volume trends by aggregating counts over specified time periods to identify patterns in user activity.
Instructions
Get event counts over time periods. Useful for analyzing event volume trends and identifying patterns in user activity over time.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| event | Yes | The event name to get counts for | |
| from_date | Yes | The date in yyyy-mm-dd format to begin querying from (inclusive) | |
| 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) | |
| unit | No | The time unit for aggregation, defaults to day |
Input Schema (JSON Schema)
{
"properties": {
"event": {
"description": "The event name to get counts for",
"type": "string"
},
"from_date": {
"description": "The date in yyyy-mm-dd format to begin querying from (inclusive)",
"type": "string"
},
"project_id": {
"description": "The Mixpanel project ID. Optional since it has a default.",
"type": "string"
},
"to_date": {
"description": "The date in yyyy-mm-dd format to query to (inclusive)",
"type": "string"
},
"unit": {
"description": "The time unit for aggregation, defaults to day",
"enum": [
"hour",
"day",
"week",
"month"
],
"type": "string"
}
},
"required": [
"event",
"from_date",
"to_date"
],
"type": "object"
}