Skip to main content
Humm queries your Mixpanel events, funnels, cohorts, and retention data. Ask about conversion rates, which features drive activation, or how a cohort’s engagement changes over time.

​
Tools

ToolDescription
MIXPANEL_JQL_QUERYExecute custom JQL (JavaScript Query Language) queries
MIXPANEL_QUERY_PROFILESQuery user or group profile data
MIXPANEL_QUERY_SEGMENTATIONGet event data segmented and filtered by properties
MIXPANEL_LIST_FUNNELSGet funnel names and IDs
MIXPANEL_QUERY_FUNNELRetrieve funnel performance data
MIXPANEL_LIST_COHORTSGet all cohorts in a project
MIXPANEL_QUERY_RETENTION_REPORTGet cohort analysis and retention data
MIXPANEL_QUERY_INSIGHTGet data from insights reports
MIXPANEL_AGGREGATE_EVENT_COUNTSRetrieve event counts aggregated over time
MIXPANEL_TODAYS_TOP_EVENTSGet top events for today with counts
MIXPANEL_GET_ALL_PROJECTSList all projects for the authenticated account

​
JQL Query Examples

Humm can execute JQL (JavaScript Query Language) queries against Mixpanel’s Query API. Here are common patterns: 
// Get events from the last 7 days
function main() {
  return Events({
    from_date: '2024-01-01',
    to_date: '2024-01-07'
  });
}

// Filter events by name
function main() {
  return Events({
    from_date: '2024-01-01',
    to_date: '2024-01-07'
  }).filter(function(event) {
    return event.name == 'Purchase';
  });
}

// Group by property
function main() {
  return Events({
    from_date: '2024-01-01',
    to_date: '2024-01-07'
  }).groupBy(['properties.plan_type'], mixpanel.reducer.count());
}

​
Query Constraints

JQL queries have the following limits:
  • 60 queries per hour rate limit
  • Maximum 5 concurrent queries
  • 2-minute execution timeout
  • 5 GB data processing limit
  • 2 GB output limit

​
Authentication

OAuth

Connect securely via OAuth. Authorize Humm to access your Mixpanel workspace.