How to query all event?

There are several ways to query all events in Mixpanel depending on your use case:

Use the Export API to download all raw event data. The event parameter is optional, so omitting it returns all events:

curl --request GET \
     --url 'https://data.mixpanel.com/api/2.0/export?project_id=<YOUR_PROJECT_ID>&from_date=<FROM_DATE>&to_date=<TO_DATE>' \
     --header 'accept: text/plain' \
     --header 'authorization: Basic ' # set up service account auth

[Raw Export API]

Note: The API allows a maximum of 100 concurrent queries, 60 queries per hour, and 3 queries per second.

Use the /events endpoint to get aggregate event counts for specific events over a time range. [Query API]

⚠️ JQL is currently in maintenance mode and Mixpanel recommends discontinuing its use.

If you still need to use JQL, here's how to query all events:

function main() {
  return Events({
    from_date: "2016-01-04",
    to_date: "2016-01-04"
  }).reduce(mixpanel.reducer.count());
}

[JQL Docs]

If you have a Data Pipeline set up (e.g., Snowflake, BigQuery, Databricks), you can query all events directly with SQL:

-- Snowflake example
SELECT count(*)
FROM <DB_NAME>.<DB_NAME>.MP_MASTER_EVENT;

-- Databricks example
SELECT count(*)
FROM mixpanel_export.json_pipelines.mp_master_event;

[Snowflake Queries; Databricks Queries]

Recommended approach: Use the Export API for raw event export, or Data Pipelines if you need ongoing access via a data warehouse.

kapa.ai how to select metrics from any event in report

The knowledge sources do not contain enough information to provide a fully detailed answer on selecting metrics from any event in Mixpanel reports. However, based on what is available, here is what I can share:

In the Insights report, you can select measurements/metrics for your events by:

The available measurement categories include:

[Insights Measurements] For more detailed guidance on selecting events and metrics across other report types (Funnels, Retention, etc.), I'd recommend checking the Mixpanel Reports documentation directly, as the knowledge sources don't cover those in detail here.

kapa.ai why cant’ i select “all event” in insight report?

The knowledge sources do not explicitly mention why "All Events" cannot be selected in the Insights report. However, based on what is available, here is a relevant limitation to be aware of:

If you can select "All Events" in Insights, note that it comes with a strict date range guardrail:

Reports using All Events can include a maximum date range of 93 days (approximately 3 months).

This means if your selected date range exceeds 93 days, the "All Events" option may be restricted or unavailable. [Date Range Guardrails]

For a more definitive answer on why "All Events" is unavailable in your specific case, I'd recommend reaching out to Mixpanel Support directly, as the knowledge sources don't cover all possible reasons for this restriction.