How to Change Incorrect Event Names in Mixpanel
My team accidentally sent a event with incorrect event name. Is is possible to change the event name for those data already captured on Mixpanel UI?
My team accidentally sent a event with incorrect event name. Is is possible to change the event name for those data already captured on Mixpanel UI?
Hi Sharon L., 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
You cannot retroactively change the event name for data that has already been captured in Mixpanel. The event name stored in the database remains as originally ingested. However, you do have a few options to address this in the Mixpanel UI:
- Rename for Reporting: Within an Insights report, you can temporarily rename an event for that specific report by clicking the three dots beside the event and selecting "Rename." This change only affects the current report and does not update the event name elsewhere or in the underlying data Docs: Insights - Rename an Event.
- Lexicon Display Name: You can update the "Display Name" of the event in Lexicon. This changes how the event appears throughout the Mixpanel UI, making it more user-friendly, but the underlying database name remains unchanged Docs: Lexicon Overview.
- Merging Events: If you have multiple events that represent the same action (e.g., due to a naming error), project owners can merge them in Lexicon. This makes Mixpanel treat them as a single event for analysis, but does not change the raw event names in the data Docs: Merging Data.
If you need to completely remove or correct the data, you would need to use data deletion and then re-upload the corrected events, but this is a more severe and permanent action Docs: Data Clean-Up.
In summary, while you cannot change the event name in the underlying data, you can adjust how it appears and is used in the UI for analysis and reporting.
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.
Let me check the knowledge base for you again. One moment! 📚
To re-upload corrected events after deleting the wrong ones in Mixpanel, you should follow an Extract, Transform, Load (ETL) approach:
1. Export the Incorrect Events: First, export the events you want to correct from Mixpanel using the Raw Export API or a tool like the mixpanel-utils Python module. This allows you to obtain the raw event data for transformation Docs: Data Clean-Up.
2. Delete the Incorrect Events: Use Mixpanel’s Data Deletion tool to remove the problematic events. This is a permanent action, so ensure you have exported the data you need before deletion Docs: Data Clean-Up.
3. Transform the Data: Update the exported data to correct the event names or any other properties as needed. This can be done using a script to modify the JSON or CSV files.
4. Re-import the Corrected Events: Use the Import API or a helper library like mixpanel-utils to upload the corrected events back into Mixpanel. For example, with mixpanel-utils:
import mputils
Assuming 'corrected_events.json' contains your fixed events
mputils.import_events('corrected_events.json', timezone_offset=0)
LBKS Make sure your events are formatted according to Mixpanel’s requirements before importing [Docs: Data Clean-Up](https://docs.mixpanel.com/docs/data-governance/data-clean-up#frequently-asked-questions) and [Project Migration Guide](https://docs.mixpanel.com/guides/playbooks/project-migration#step-5-import-data).
**Note:**
- If you are dealing with a large volume of data or need to automate the process, refer to the sample scripts provided in the [Mixpanel project migration guide](https://docs.mixpanel.com/guides/playbooks/project-migration#step-5-import-data).
- Always test the import with a small data sample first to ensure correctness.
This ETL approach is the recommended way to correct and re-upload events in Mixpanel after deletion.
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.