I am trying to look at when users start a free trial cancel the subscription. I exported a customer list from RevenueCat and have been looking at the data in Excel. In Excel the columns that I am looking at are trial_opt_out_at and trial_start_at. Does anyone know how to convert the values in these columns to dates from the numbers that they are set. Currently the values in these columns look like - 1629693003000.
Best answer by tinaView original
Those columns are epoch timestamp in milliseconds. RevenueCat documentation for reference: https://docs.revenuecat.com/docs/customer-lists#exporting-data There’s an article online that would help convert these to a readable date: https://www.extendoffice.com/documents/excel/4696-excel-milliseconds-to-date.html