We have a productivity/meeting software that helps organize meetings. We want to know if users are performing a specific event during their scheduled meeting time. We have implemented meeting_id and scheduled_meeting_time properties. The goal is to match or compare the event timestamp in Amplitude with the scheduled_meeting_time property. Unfortunately, I haven’t been able to wrap my head around the logistics in Amplitude. Has anyone successfully done anything similar? Or do you have any ideas/suggestions for things I can try? Thank you so much for your help!
Best answer by Saish Redkar
That’s an interesting use case!
As you might already know, you can change the timezone of your project to whatever you prefer for UI and charting purposes, but the inherent raw data ingested in Amplitude is always in UTC.
From what I understand of your end goal, a couple of things I can point out -
- Afaik, there isn’t a direct way of comparing equality of a property value to another property using the dropdown. The only timestamp property you can select currently in the property dropdown is the “Server Upload Time” , which is the UTC time the event was ingested by Amplitude.
This is mostly accurate and on par with the client_event_time raw datapoint up to a few microseconds I believe, but can vary. You can try different combinations of manually comparing a timestamp value to your scheduled_meeting_time and the server upload time if that helps to some extent. You always have to option to change and select the time interval in the metrics module to your choice.
Coming back to your goal of “we want to know if users are performing a specific event during their scheduled meeting time”, the first thought which comes in my mind is doing a funnel analysis to answer this in a slightly different way.
You can try building the funnel using the “Join/Start a meeting” event as the first event, followed by “Any Active Event” or whichever event you want them to perform. Since you want to know specifically for their scheduled meeting time, you will have to hold constant the meeting_id property. Let me know if this approach helps you answer your question to some extent.