Merging Events in Mixpanel: Combining Old and New Data
I have two project in mixpanel and have two events can i marge this the old event with new even as extract data from the old event and pushing the data for the new event
I have two project in mixpanel and have two events can i marge this the old event with new even as extract data from the old event and pushing the data for the new event
Hi Anhar S., 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
Yes, you can merge data from an old event in one Mixpanel project with a new event in another project, but this is not an automatic process. Here’s how you can approach it: 1. Export Data from the Old Project:
Use the Raw Export API to export the relevant event data from your old project. You can filter for specific events if needed. The export will provide you with the raw event data in JSON format, which you can then process as required Step 3: Export Existing Data.2. Transform Data as Needed:
Before importing, you may want to map or rename the old event to match the new event’s schema (event name and properties). This step is important if you want the old data to appear as the new event in your new project.3. Import Data into the New Project:
Use the Import API to push the transformed data into your new project. Make sure to update the project token and format the data according to the requirements of your new project, especially if you are using features like Simplified ID Merge Merge Mixpanel Projects.4. Merging Events in Lexicon (Optional):
If you have two similar events (e.g., “Purchase” and “purchase item”) in the same project, you can merge them in Lexicon so they appear as a single event in your reports. However, this Lexicon merge does not combine raw data across projects—it only affects reporting within a single project Merging Data.Important Notes:
- You cannot directly merge events across two different projects within the Mixpanel UI. The process always involves exporting from one project and importing into another.
- When importing, ensure you include a unique $insert_id for each event to prevent duplication.
- If you are migrating to a new project with Simplified ID Merge, make sure your imported events include the required identity properties (like $device_id and $user_id) Backfilling Historical Data.In summary:
You can extract (export) data from an old event in one project, transform it as needed, and push (import) it as a new event into another project. There is no direct “merge” button for events across projects, but this export/import workflow achieves the result you’re looking for.
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.