Exporting Data Limits: Query Saved Report API vs. CSV in Mixpanel

Thayananth K. · 2024-12-20 06:10:45.387523+00

Hi , may I know how many rows of data can exported using Query Saved Report API. I am only getting 20k rows using API and I can get up to 90k rows using export CSV function in mixpanel I want the full data of the Insights reports - which should be 4 million rows.

Based on the information provided in the knowledge sources, there are some limitations on the data that can be exported using the Query API for Insights reports. However, the exact number of rows that can be exported is not explicitly stated for the Insights Query API.The Query API, which includes the Insights query, has some general limitations: 1. Rate limit: 60 queries per hour 2. Concurrent queries: Maximum of 5Mixpanel API Rate Limits mentions these limits for the Query API.Regarding the discrepancy you're experiencing between the API and CSV export: 1. The API seems to be returning 20,000 rows in your case. 2. The CSV export function in Mixpanel's UI is allowing you to export up to 90,000 rows.However, neither of these methods seem to be providing the full 4 million rows you're expecting.It's worth noting that Mixpanel does have some limits on report downloads: Downloading Reports from Mixpanel mentions that for CSV exports of property values that exceed 10,000, Mixpanel only returns the top 10,000 breakdowns of that property.Unfortunately, the knowledge sources don't provide specific information about exporting 4 million rows from Insights reports. If you need to export such a large volume of data, you might want to consider using Mixpanel's Raw Data Export API or Data Pipelines feature, which are designed for high-volume exports. However, these methods export raw event data rather than formatted report data.I recommend reaching out to Mixpanel's support team for more specific guidance on exporting large volumes of Insights report data, as the available information doesn't cover your specific use case.

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.

1 comment