Exporting Full Data from Mixpanel: Query Saved Report API Limitations

·Dec 20, 2024 06:09 AM·

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. How do i do this can someone help ?

3 comments

· Sorted by Oldest

Thayananth K.
·
·
Eric N. Eric N. Christopher C. Amy M. Christopher C. HELP ME PLEASEEE
Eric N.
·
·
Hi Thayananth K.! Sorry about the delay, but please refrain from tagging any person in this community unless it is an admin. Have you already contacted support on this?
Eric N.
·
·
By default, the Query API for saved reports (also known as the Insights API) has a limit of 3,000 rows or segments. This matches the visible limits in the Mixpanel UI. If you need to export more than 50,000 rows, you may need to consider breaking your query into smaller segments or using alternative methods like the raw data export API.

Thayananth K.
·
·
Eric N. Eric N. Christopher C. Amy M. Christopher C. HELP ME PLEASEEE
Eric N.
·
·
Hi Thayananth K.! Sorry about the delay, but please refrain from tagging any person in this community unless it is an admin. Have you already contacted support on this?
Eric N.
·
·
By default, the Query API for saved reports (also known as the Insights API) has a limit of 3,000 rows or segments. This matches the visible limits in the Mixpanel UI. If you need to export more than 50,000 rows, you may need to consider breaking your query into smaller segments or using alternative methods like the raw data export API.