Difference Between 'Time' and 'Time Processed (UTC)' on kapa.ai
kapa.ai what's the difference between 'Time' and 'Time Processed (UTC)' when you check the Events page?
Please stand by Rinitha R. as I search the knowledge base. I normally take about 15 seconds or so. đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
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
$timeproperty 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 themp_processing_time_msproperty 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.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.