Question

How can I see when users did events in their own time zone?

  • 13 November 2020
  • 2 replies
  • 64 views

  • New Participant
  • 0 replies

Is there a way to see when users did events relative to their local time?

Ex. I’m interested in seeing what time of day users are using our mobile app, but it’s unclear to me whether there’s actually a way to see that in Mixpanel, or if I can only ever see the time events happened relative to the project time zone. Based on the timezone documentation I’ve read here, all timestamps are recorded in the project’s time zone, but if that was also the only way to see them in reports the “time of day” breakdown wouldn’t really be accurate to the user’s experience, would it? If I see lots of events showing up at 5AM (PST) but most of the users are on EST, then a 5AM spike wouldn’t actually represent early-morning use.

We do store $timezone as a user property. Perhaps there’s a way to create a custom time property that incorporates the user’s timezone?


2 replies

Follow…

I have the same question. As getting the idea of time when users perform a particular activity can definitely help the app owners or marketers for marketing purposes.
 

Userlevel 2
Badge +1

Hi Amyp and Jesus107,

 

This is a gap right now to have multiple time zones. Currently, the workaround now would be to keep the project times in your HQ time zone, but add properties for the user’s local time when the event was fired, and the time zone the user was in. Example, add these properties to your events: 

user_timestamp: 2020-03-25T21:53:01.0581931Z
and
user_timezone: "UTC+12:00"

Reply