I tried to export the campaign activity data for 2018. On dashboard, it shows the last activity date and time stamps but once I export, the data and time stamps are all the same dated back to 01 Jan 1970! Can anyone help?
@Angela_Kok_Yee_ did you ever find a solution for this? I just had the same issue in my excel export. Lots of dates coming up as 01/01/1970 10:00 AM even though there is a "Correct" date in the actual report. TIA
By “Excel export“ I assume you actually mean CSV export.
In a Marketo CSV, the Date field is formatted as yyyy-MM-dd HH:mm:ss (local time, ISO 8601 format with a space):
Event ID, Date/Time (EDT), Activity Type 339645536,2021-10-10 00:14:46,Call Webhook 339642511,2021-10-09 23:34:34,Call Webhook 339642383,2021-10-09 23:28:30,Call Webhook
Open your CSV in a Text editor (Notepad++, etc.). Does it not look like the above?