Re: Export of Campaign Activity History not showing on Excel

Angela_Kok_Yee_
Level 1

Export of Campaign Activity History not showing on Excel

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?

2 REPLIES 2
heymara
Level 1

Re: Export of Campaign Activity History not showing on Excel

@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

SanfordWhiteman
Level 10 - Community Moderator

Re: Export of Campaign Activity History not showing on Excel

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?