1. Pendo Help Center
  2. Community
  3. Analytics

Making first visit metadata make sense

Avatar
Jim Babb

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.

1

Comments

3 comments
Date Votes
  • Avatar
    Permanently deleted user

    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,

    2
  • Avatar
    Jim Babb

    @... Perfect, that worked. Thanks!

    0
  • Avatar
    Ron Baumert

    Pendo should just give users option to export in a date format instead of having to deal with adding formulas.

    1

Please sign in to leave a comment.

Didn't find what you were looking for?

New post