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:
curl --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'
2. 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.
