How can I get all the data exported for a given event and report. - the charts cap out at 12 items for breakdown where I have 75 and the export data only gives me the rolled up count for the entire date range:
Hi Reamer, 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> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To get all the data exported for a given event and report, including breakdowns with more than 12 items, you have a few options:1. Use the Raw Event Export API:
The Raw Event Export API allows you to export raw event data with all properties and breakdowns. This method is recommended for high volume exports and doesn't have the 12-item limitation you're experiencing in the UI.Example API request:LBKScurl --request GET \ --url '[https://data.mixpanel.com/api/2.0/export?from_date=2024-07-23&to_date=2024-07-24&limit=100&event=sample_event](https://data.mixpanel.com/api/2.0/export?from_date=2024-07-23&to_date=2024-07-24&limit=100&event=sample_event)' \ --header 'accept: text/plain' \ --header 'authorization: Basic YOUR_TOKEN'LBKS2. Use the Query API:
The Query API allows you to export event data with more flexibility. It has a higher limit of 3000 segments for Insights reports, which should cover your 75 breakdown items.3. Adjust the UI limits:
If you're using the Insights report, you can try adjusting the selection limit. According to the Limits and Ordering documentation, Insights (bar) has a selection limit of 300 and a visible limit of 3000. You might be able to increase the number of items shown in the UI.4. Use Data Pipelines:
If you need regular exports of large volumes of data, consider setting up a Data Pipeline to export your data to a data warehouse like BigQuery or Snowflake. This would allow you to query the full dataset without UI limitations.For your specific case where you have 75 breakdown items, I'd recommend using the Raw Event Export API or the Query API to get the full dataset. These methods will allow you to bypass the UI limitations and access all your data.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
