Discrepancy in API Exported Events vs Mixpanel Data Explained

·Oct 14, 2025 07:09 PM·

I'm kinda confused about the exporting API... I exported all Started Job events between these two dates, and the API returned around 900k events... however, in mixpanel, I only see 250k events... what could explain such a large discrepancy?

3 comments

· Sorted by Oldest

Vlad S.
·
·
sorry, forgot the screenshot
Vlad S.
·
·
answering my own question here: a lot of these events share the same $insert_id field, meaning that they've been "overwritten" and the frontend shows (and counts) only the most recent version of each, but the API returns all of the versions... not sure if that's on purpose or not
Vlad S.
·
·
it would be helpful to have an optional flag in the API to toggle this behavior, I imagine it's rare anyone wants to export an essentially overwritten version of an event

Vlad S.
·
·
sorry, forgot the screenshot
Vlad S.
·
·
answering my own question here: a lot of these events share the same $insert_id field, meaning that they've been "overwritten" and the frontend shows (and counts) only the most recent version of each, but the API returns all of the versions... not sure if that's on purpose or not
Vlad S.
·
·
it would be helpful to have an optional flag in the API to toggle this behavior, I imagine it's rare anyone wants to export an essentially overwritten version of an event