Skip to main content
Glama

mixpanel

query_segmentation_sum

Sum numeric expressions for events over time in Mixpanel to calculate revenue metrics, track cumulative totals, and aggregate quantitative values across specified time periods.

Instructions

Sum a numeric expression for events over time. Useful for calculating revenue metrics, aggregating quantitative values, and tracking cumulative totals across different time periods.

Input Schema

NameRequiredDescriptionDefault
eventYesThe event that you wish to get data for (single event name, not an array)
from_dateYesThe date in yyyy-mm-dd format to begin querying from (inclusive)
onYesThe expression to sum per unit time (should result in a numeric value)
project_idNoThe Mixpanel project ID. Optional since it has a default.
to_dateYesThe date in yyyy-mm-dd format to query to (inclusive)
unitNoTime bucket size: 'hour' or 'day'. Default is 'day'
whereNoAn 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_idNoThe ID of the workspace if applicable

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 (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" }, "on": { "description": "The expression to sum per unit time (should result in a numeric value)", "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": "Time bucket size: 'hour' or 'day'. Default is 'day'", "enum": [ "hour", "day" ], "type": "string" }, "where": { "description": "An expression to filter events by based on the grammar: <expression> ::= 'properties[\"' <property> '\"]'\n | <expression> <binary op> <expression>\n | <unary op> <expression>\n | <math op> '(' <expression> ')'\n | <string literal>\n <binary op> ::= '+' | '-' | '*' | '/' | '%' | '==' | '!=' |\n '>' | '>=' | '<' | '<=' | 'in' | 'and' | 'or'\n | <unary op> ::= '-' | 'not'", "type": "string" }, "workspace_id": { "description": "The ID of the workspace if applicable", "type": "string" } }, "required": [ "event", "from_date", "to_date", "on" ], "type": "object" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/dragonkhoi/mixpanel-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server