Understanding Timezone in Mixpanel API Exports
kapa.ai What is the timezone for the 'time' property in Mixpanel API exports?
kapa.ai What is the timezone for the 'time' property in Mixpanel API exports?
Please stand by Shubham M. 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
The timezone for the time property in Mixpanel API exports is generally UTC. However, there are important distinctions based on when your project was created: - For projects created before 1 January 2023: The time property in exports reflects your project’s timezone at the time of ingestion. When exporting, you should convert these timestamps to UTC to ensure consistency, as the export API expects and returns times in UTC. - For projects created after 1 January 2023: The time property is stored and exported in UTC by default.In all cases, the export API interprets the from_date and to_date parameters as UTC, and the time property in the exported data is a Unix timestamp (seconds since 1970-01-01 00:00:00 UTC) Manage Timezones for Projects Export Methods.If you are migrating or merging projects, always ensure that timestamps are converted to UTC before importing into a new project to maintain data accuracy Merge Mixpanel Projects.
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.
kapa.ai And what timezone do I need to ingest the data in Mixpanel for projects created before 1 January 2023?
Let me check the knowledge base for you again. One moment! 📚
For projects created before 1 January 2023, you should ingest (import) your data into Mixpanel using UTC timestamps. Mixpanel will then convert these UTC timestamps to your project’s timezone before storing the event data. This ensures that your data displays correctly according to your project’s timezone settings Manage Timezones for Projects.> Always send imported data to Mixpanel in UTC to ensure it displays correctly in your project. Mixpanel stores your data in UTC, then uses your project timezone setting to output data in your selected timezone. For projects created before 1 January 2023, your UTC timestamps are converted to the project timezone before ingestion meaning that your event data are stored in the project timezone.If you overwrite the default timestamp or import old data, be sure to send the timestamp in UTC.
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.