is mixpanel events in UTC or what default properties is in UTC?
Hi bxor c., 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
Based on the provided knowledge sources, I can answer your question about Mixpanel events and UTC timestamps:Mixpanel records all events in Coordinated Universal Time (UTC) at intake. However, there are some nuances to be aware of:1. For projects created after January 1, 2023, raw event data is stored in UTC Managing Timezones.2. For projects created before January 1, 2023, Mixpanel converts event timestamps to the project timezone before writing the event to Mixpanel data stores Managing Timezones.Regarding default properties in UTC:1. The mp_processing_time_ms
property, which represents the "Time Processed", is in UTC Default Properties.2. The $mp_api_timestamp_ms
property, which represents the "API Timestamp", is also in UTC Default Properties.It's important to note that while Mixpanel records events in UTC, the display timezone can be adjusted in Project Settings. By default, Mixpanel displays event times in US Pacific Time, but this is adjustable Debugging Timezones.When working with date properties or importing data, it's recommended to always use UTC timestamps to ensure consistency Changing Timezone.
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.