Making first visit metadata make sense

Follow

Jim Babb

• April 01, 2022 20:59

When I exported a segment to .csv, my First Visit and Last Visit metadata came in as a string of numbers (e.g. 1647884116316) rather than a date like I expected. Does anyone know how to convert that number to the date?

In the example I gave, 1647884116316 represents Mar 21, 2022 12:35:16 PM CDT according to that users record in Pendo.

0

• 

  Angus Yang

  • April 04, 2022 16:15

  Hey Jim, this should work for converting it to a date.

  //Where A1 = First Date column
  =(((A1/1000/60)/60/24)+DATE(1970,1,1))

  Best,

  1

  Comment actions Permalink
• 

  Jim Babb

  • April 05, 2022 13:28

  Angus Yang Perfect, that worked. Thanks!

  0

  Comment actions Permalink

Please sign in to leave a comment.