aggregated_event_property_values

Retrieve unique, total, or average values for a specific event property over defined time intervals. Analyze data granularity by minute, hour, day, week, or month to gain actionable insights.

Instructions

Get unique, total, or average data for a single event and property over days, weeks, or months

Input Schema

Name	Required	Description
`event`	Yes	The event that you wish to get data for (a single event name, not an array)
`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
`limit`	No	The maximum number of values to return (default: 255)
`name`	Yes	The name of the property you would like to get data for
`project_id`	No	The Mixpanel project ID
`to_date`	No	The date in yyyy-mm-dd format to query to (inclusive)
`type`	Yes	The analysis type - general, unique, or average events
`unit`	Yes	The level of granularity of the data (minute, hour, day, week, or month)
`values`	No	The specific property values to get data for, encoded as a JSON array. Example: "["female", "unknown"]"

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "event": {
      "description": "The event that you wish to get data for (a single event name, not an array)",
      "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"
    },
    "limit": {
      "description": "The maximum number of values to return (default: 255)",
      "type": "number"
    },
    "name": {
      "description": "The name of the property you would like to get data for",
      "type": "string"
    },
    "project_id": {
      "description": "The Mixpanel project ID",
      "type": "string"
    },
    "to_date": {
      "description": "The date in yyyy-mm-dd format to query to (inclusive)",
      "type": "string"
    },
    "type": {
      "description": "The analysis type - general, unique, or average events",
      "enum": [
        "general",
        "unique",
        "average"
      ],
      "type": "string"
    },
    "unit": {
      "description": "The level of granularity of the data (minute, hour, day, week, or month)",
      "enum": [
        "minute",
        "hour",
        "day",
        "week",
        "month"
      ],
      "type": "string"
    },
    "values": {
      "description": "The specific property values to get data for, encoded as a JSON array. Example: \"[\"female\", \"unknown\"]\"",
      "type": "string"
    }
  },
  "required": [
    "event",
    "name",
    "type",
    "unit"
  ],
  "type": "object"
}

mixpanel

aggregated_event_property_values

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from mixpanel

Related Tools