Amplitude

Humm runs event segmentation queries against your Amplitude project. Ask about user engagement trends, compare cohorts, or break down events by any property.

Source Types

SaaS (Live)

Humm queries the Amplitude API directly in real time. Data is never stored by Humm.

Sync

Humm syncs your Amplitude data into your warehouse via Airbyte, then queries the copy. Better performance for large datasets and lets you join Amplitude data with everything else in your warehouse.

See Choosing a Source Type for help deciding.

Tools

Tool	Description
`AMPLITUDE_RUN_AGGREGATION`	Execute event segmentation queries with metrics, filtering, grouping, and date ranges
`AMPLITUDE_LIST_COHORTS`	List all cohorts in the Amplitude project
`AMPLITUDE_GET_EVENT_TYPES`	Retrieve all event types in the project
`AMPLITUDE_GET_EVENT_CATEGORIES`	Retrieve all event categories
`AMPLITUDE_FIND_USER`	Search for users by Amplitude ID, device ID, or user ID

Aggregation Queries

The AMPLITUDE_RUN_AGGREGATION tool is the primary way to query Amplitude data. It supports event segmentation with flexible metrics and grouping.

Metrics

Metric	Description
`uniques`	Unique users (default)
`totals`	Total event count
`pct_dau`	Percentage of daily active users
`average`	Average events per user
`sums`	Sum of event property values
`value_avg`	Average of event property values
`formula`	Custom formula across two events

Parameters

Parameter	Required	Description
`e`	Yes	Primary event definition (event type, filters, group-by)
`start`	Yes	Start date in `YYYYMMDD` format
`end`	Yes	End date in `YYYYMMDD` format
`m`	No	Metric type (default: `uniques`)
`i`	No	Time interval: `1` (daily), `7` (weekly), `30` (monthly), `-3600000` (hourly)
`g`	No	Primary group-by property
`s`	No	Segment filters on user population
`e2`	No	Second event (for formula queries)
`formula`	No	Custom formula (requires `m=formula` and both `e`/`e2`)

Event Definition

{
  "event_type": "Purchase",
  "filters": [
    {
      "subprop_type": "event",
      "subprop_key": "category",
      "subprop_op": "is",
      "subprop_value": ["Electronics"]
    }
  ]
}

Special Event Types

Event Type	Description
`_active`	Any active event
`_all`	All events
`ce:name`	Custom events (prefix with `ce:`)

Group-By Properties

Built-in properties: country, city, region, platform, os, device_type, version, paying. For custom properties, use the gp: prefix (e.g., gp:plan_name).

Filter Operators

Operator	Description
`is` / `is not`	Exact match
`contains` / `does not contain`	Substring match
`less` / `greater`	Numeric comparison
`less or equal` / `greater or equal`	Numeric comparison
`set is` / `set is not`	Set membership

Query Constraints

Interval	Max Date Range
Real-time (`-300000`)	2 days
Hourly (`-3600000`)	7 days
Daily (`1`)	365 days

Rate limit: 5 concurrent queries.

Authentication

API Toke

Connect securely via OAuth. Authorize Humm to access your Amplitude project.

Start Here

Key Features

Integrations

Guides

Source Types

SaaS (Live)

Sync

Tools

Aggregation Queries

Metrics

Parameters

Event Definition

Special Event Types

Group-By Properties

Filter Operators

Query Constraints

Authentication

API Toke

​Source Types

SaaS (Live)

Sync

​Tools

​Aggregation Queries

​Metrics

​Parameters

​Event Definition

​Special Event Types

​Group-By Properties

​Filter Operators

​Query Constraints

​Authentication

API Toke

Source Types

Tools

Aggregation Queries

Metrics

Parameters

Event Definition

Special Event Types

Group-By Properties

Filter Operators

Query Constraints

Authentication