Duplicated insert_id in Event Export API Raw Data?
When pulling raw data from the event Export API, I am getting events that have duplicated insert_id fields and but very slightly different payloads. Is this expected?
Hi Brian J., 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
This behavior is not expected and indicates a potential issue with event deduplication. According to Mixpanel's documentation, events with identical
$insert_idvalues should be deduplicated and only one instance should be surfaced in queries.The Event Export API documentation states that the raw export API allows you to download your event data as it is received and stored within Mixpanel. However, Mixpanel has a deduplication process in place to prevent duplicate events from being recorded.According to the event deduplication documentation, events containing an$insert_idare checked for duplication. If a simplified version of the event object (including event name, token, distinct_id, time, and $insert_id) is an exact match to any other simplified event, it should be marked as a duplicate and deleted within 24 hours.The fact that you're seeing events with the same$insert_idbut slightly different payloads suggests that there might be an issue with how the events are being sent or processed. This could be due to several reasons:1. The events might have been sent multiple times with slight variations in the payload. 2. There could be a problem with the deduplication process on Mixpanel's end. 3. The events might have been exported before the 24-hour deduplication process completed.To address this issue, you should:1. Check your implementation to ensure you're not accidentally sending duplicate events with slight variations. 2. Make sure you're using$insert_idcorrectly as described in the Import Events documentation. 3. Contact Mixpanel support to investigate why the deduplication process isn't working as expected in your case.It's worth noting that this situation aligns with what's described in a Mixpanel blog post about disjoint event duplicates, which mentions that duplicated events can sometimes be mixed in with legitimate events and be difficult to spot.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.