Hey @bitfl1p ,
Afaik, there isn’t a native way of accessing the client_event_time and client_upload_time as properties while graphing in Amplitude. So it might be tough to visualize the skew between those two in any of the charts.
The only solution I can think of is having access to your raw event data in a data warehouse and extracting the difference between those 2 timestamps in SQL.
You can read the following post for ways to enable SQL with your event data -
I’m not sure if it’s normal with the SDK implementation, but I feel the difference of almost 3 days in the sample you shared is quite a bit . You might want to reach out to the platform team if this is causing issues.
Hope this helps!
Hi @bitfl1p ! Thanks for your question!
First, here’s the updated link for the definitions of each timestamp: https://help.amplitude.com/hc/en-us/articles/229313067#Raw-Data-Fields
The Client Event Time and Client Upload Time timestamps are pulled from the user’s device and Client Upload Time will depend on the user’s internet connection. If the user loses connection or is operating on airplane mode, the events will be stored until they re-establish connection. For most (if not all) Amplitude SDKs, the cadence at which Amplitude SDKs upload events is either every 30 seconds or every 30 events by default. This option can also be configured if you’d like to increase the rate at which events are sent. More information on these options can be found here: JavaScript SDK | iOS SDK | Android SDKLook out for options named eventUploadPeriodMillis, eventUploadThreshold, setEventUploadMaxBatchSize and eventUploadPeriodSeconds etc.
As @Saish Redkar mentioned, querying on client event and client upload time is not available in Amplitude, but if you have a paid plan, you can have the option to export your data to Snowflake, Amazon S3, or Google Cloud Storage, you can query on these values using SQL.
Hope this information helps! Let us know if you have any questions!
@tracy.guo Hello, I would like to ask when we’re actually making charts in Amplitude which timestamp out of the ones I listed below is being used to plot the data points?
client_event_time
client_upload_time
server_received_time
server_upload_time
event_time
Pulling this from the doc - “Daily exported files are based on server_upload_time
and all dashboards are based on event_time
. We recommend that queries on raw data use event_time
.”