aggregate_event_counts

Analyze event trends over time by fetching unique, general, or average data for specific events. Supports granularity in minutes, hours, days, weeks, or months for trend analysis and performance comparisons.

Instructions

Get unique, general, or average data for a set of events over N days, weeks, or months. Useful for trend analysis, comparing event performance over time, and creating time-series visualizations.

Input Schema

Name	Required	Description
`event`	Yes	The event or events that you wish to get data for, a string encoded as a JSON array. Example format: "["play song", "log in", "add playlist"]"
`from_date`	No	The date in yyyy-mm-dd format to begin querying from (inclusive)
`interval`	No	The number of units to return data for. Specify either interval or from_date and to_date
`project_id`	No	The Mixpanel project ID. Optional since it has a default.
`to_date`	No	The date in yyyy-mm-dd format to query to (inclusive)
`type`	No	The type of data to fetch, either general, unique, or average, defaults to general
`unit`	Yes	The level of granularity of the data you get back

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "event": {
      "description": "The event or events that you wish to get data for, a string encoded as a JSON array. Example format: \"[\"play song\", \"log in\", \"add playlist\"]\"",
      "type": "string"
    },
    "from_date": {
      "description": "The date in yyyy-mm-dd format to begin querying from (inclusive)",
      "type": "string"
    },
    "interval": {
      "description": "The number of units to return data for. Specify either interval or from_date and to_date",
      "type": "number"
    },
    "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"
    },
    "type": {
      "description": "The type of data to fetch, either general, unique, or average, defaults to general",
      "enum": [
        "general",
        "unique",
        "average"
      ],
      "type": "string"
    },
    "unit": {
      "description": "The level of granularity of the data you get back",
      "enum": [
        "minute",
        "hour",
        "day",
        "week",
        "month"
      ],
      "type": "string"
    }
  },
  "required": [
    "event",
    "unit"
  ],
  "type": "object"
}

mixpanel

aggregate_event_counts

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from mixpanel

Related Tools

MCP directory API