Convert Timestamps in Analytics Data
Translate Unix timestamps from analytics exports (Google Analytics, Mixpanel, Amplitude) into readable dates.
Epoch quick reference
Analytics tips
Analytics platforms like Mixpanel and Amplitude export event timestamps as Unix milliseconds. Switch to milliseconds mode before converting.
Analytics data is typically stored in UTC. Use the UTC output row β not "Local time" β when comparing timestamps across different team members.
Google Analytics 4 exports timestamps as microseconds (divide by 1,000 to get milliseconds, or by 1,000,000 for seconds).
To filter analytics data by a specific date range, use "Date β Timestamp" mode to get the Unix timestamps for your start and end dates.
How It Works
Why use ours?
Also check outβ¦
Convert Timestamps for Debugging
Decode Unix timestamps from server logs, error pay
Convert Timestamps in API Development
Validate, compare, and translate Unix timestamps r
Convert Timestamps for Database Queries
Convert dates to Unix timestamps for SQL WHERE cla
Convert Timestamps for Scheduling
Convert specific dates and times to Unix timestamp