Based on the knowledge sources, there's a clear distinction between 'Time' and 'Time Processed (UTC)' in Mixpanel's Events page:
- Time: This is the timestamp of when the event actually occurred. It's stored as the $time property in Unix timestamp format (number of seconds elapsed since January 1, 1970). For projects created before January 1, 2023, this timestamp is stored in your project's timezone at the time of ingestion. For projects created after that date, it's stored in UTC.
- Time Processed (UTC): This is represented by the mp_processing_time_ms property and indicates the UTC timestamp in milliseconds when the event was processed by Mixpanel's servers. This is not when the event occurred, but when Mixpanel actually received and processed the data.
The difference is important because there can be delays between when an event occurs and when it's processed by Mixpanel. This could be due to offline tracking, batch sending of events, or late data imports.
This distinction is particularly relevant when debugging data discrepancies or when analyzing data that might have been ingested with a delay.
Default Properties provides more details about these and other automatically collected properties in Mixpanel.
