kapa.ai I just used the Mixpanel import API to import historic data from another analytics tool I am switched out of. My script and the API say all the events where imported correctly (around 210k events), but in Mixpanel, I find only 178k events. What could be going on ?
There are several possible reasons for the discrepancy between the number of events you imported (210k) and the number visible in Mixpanel (178k): 1. Rate Limits and API Errors: While your script and the API may report success, some events could have been dropped due to rate limits or malformed data. It's important to log and review any 400 errors from the API, as these indicate non-retryable issues with the data. Only valid data in a batch is ingested; invalid data is dropped, but the rest of the batch is processed. Double-check your logs for any such errors during import Track Events - Code.2. Event Age and Endpoint Used: If you used the /track endpoint, Mixpanel will not ingest events older than 5 days. For older events, you must use the /import endpoint. If some events were sent to the wrong endpoint, they would not be ingested Debugging: Delayed Ingestion.3. Hidden Events in UI: Events that have not been fired in the last 30 days are hidden from dropdowns in the Mixpanel UI, but they are still present in the raw data. You can search for them by name or fire a single instance to resurface them in the UI Debugging: Hidden Events.4. Data Discrepancies and Filtering: Ensure you are comparing the same event names, time frames, and filters in both your import and Mixpanel reports. Differences in filters, time zones, or event definitions can cause apparent discrepancies Debugging: Data Discrepancies.5. Ad Blockers and Client-Side Issues: If any events were tracked client-side, ad blockers or privacy settings could have prevented some events from being sent or ingested Debugging: Data Discrepancies.6. Schema or Property Limits: If your import included thousands of unique event or property names (e.g., using UUIDs as event names), you may have hit Mixpanel’s schema limits, causing some events to be dropped Data Pipelines FAQ.7. Identity Management Issues: If there are issues with unique identifiers or user IDs, some events may not be attributed correctly or may be dropped, especially if the imported data structure differs from Mixpanel’s expectations Migrating from Adobe Analytics.Next Steps: - Review your import logs for any errors or dropped events.
- Confirm you used the correct endpoint for historic data.
- Check if any events are hidden in the UI.
- Compare the raw event data in Mixpanel with your import source, ensuring you are looking at the same event names and time frames.
- If the issue persists, consider reaching out to Mixpanel support with your import logs and details.If you need to validate imported events older than 30 days, use the Insights report and filter by properties like $import
or $source
to confirm their presence Post-migration data validation.If you need more specific troubleshooting, please provide details about the endpoint used, error logs, and how you are counting events in Mixpanel.
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.