how to remove duplicate event values?

Hi Novindra P., 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> 👋

To remove duplicate event values in Mixpanel, there are a few approaches you can consider: 1. Event Deduplication: Mixpanel offers an event deduplication feature that prevents duplicate events from being recorded. This is done by using a unique $insert_id for each event. If an event with the same $insert_id is sent multiple times, only one instance will be recorded. Here's how it works: - Include a unique $insert_id in the properties of each event you send. - Mixpanel will check for duplicates based on a simplified version of the event object. - Duplicate events are marked and deleted within 24 hours. Source: Mixpanel Docs2. Data Deletion: If you've already ingested duplicate events due to an implementation issue, you can use Mixpanel's Data Deletion feature to remove them. This should be used cautiously as it permanently deletes data: - Use targeted event property filters to identify and delete duplicate event data. - This is recommended for scenarios where duplicate events were ingested due to implementation issues. Source: Mixpanel Docs3. Merging Events: If you have similar events from different sources (e.g., "Purchase" from iOS and "purchase item" from Android), you can merge them in Lexicon: - Select the events to merge in Lexicon. - Click the "Merge" icon and specify which event should be considered the new unique event. - This doesn't affect raw data but streamlines analysis by treating merged events as a single event. Source: Mixpanel DocsRemember, prevention is better than cure. Implementing proper event tracking with unique $insert_id values is the best way to avoid duplicate events in the first place.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.