how can I export the data which exceed the UI limit?

Hi Kübra B., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

You have a few options depending on what you’re exporting and why it exceeds the UI limits:

UI segmentation limits don’t apply to raw exports. Use the Raw Event Export API to pull all underlying events as JSONL, filtered by date and (optionally) event name or a where expression.[Export methods]Example: LBKScurl --request GET \ --url '[https://data.mixpanel.com/api/2.0/export?project_id=<PROJECT_ID](https://data.mixpanel.com/api/2.0/export?project_id=<PROJECT_ID) &amp;from_date=2024-07-23&amp;to_date=2024-07-24>' \ --header 'accept: text/plain' \ --header 'authorization: Basic <BASE64_SERVICE_ACCOUNT_CREDENTIALS> 'LBKSNotes: - Returns all matching events; UI segment cardinality limits don’t apply.[Raw export spec] - Rate limit: 60 queries/hour, 3/sec, 100 concurrent.[Raw export spec]For large time ranges, use varied-length scripts like the sample that queries big, low‑volume periods in larger chunks and high‑volume periods in smaller daily ranges.[Varied date ranges]

If you want the aggregated report output (not raw events), Growth/Enterprise projects can use the Query API (Insights/Funnels/Retention APIs) to pull the same numbers that you see in the UI, without the visual selection limits.[Exporting reports]This does not “remove all limits,” but avoids some UI interaction constraints like segment selection; exact row caps for Query API aren’t detailed in the provided docs.

For Insights and other reports, CSV export has a higher row cap than what you see on screen: - Most reports: 10,000 rows - Insights non‑line charts (Bar, Stacked Bar, Pie, Table, Metric): up to 50,000 rows.[Segment limits]If your UI view is truncated due to segment cardinality, CSV often returns more segments than the on‑screen visualization.

If you need all events and profiles on an ongoing basis and your data volumes are large, use Data Pipelines (paid add‑on for Growth/Enterprise): - Continuously exports events, profiles, and identity mappings to S3/GCS/Azure or to warehouses (BigQuery, Snowflake, Redshift, etc.). - Events go to paths like: <BUCKET_NAME> /<MIXPANEL_PROJECT_ID> /mp_master_event/<YEAR> /<MONTH> /<DAY> /.[Data Pipelines overview]This fully bypasses report and UI export limits and is best for large‑scale analysis in SQL.

For user or group profiles, skip the UI limits by using the Engage API, which returns paged JSON results of profiles.[Exporting profiles]---In practice: - If you’re hitting segment/cardinality limits in a report, try CSV export first, then Query API, or drop to Raw Event Export if you need everything. - If you need ongoing, complete dumps at scale, use Data Pipelines.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.