Export of Campaign Activity History not showing on Excel | Community
Skip to main content
Angela_Kok_Yee_
Angela_Kok_Yee_
New Participant
June 10, 2019
Question

Export of Campaign Activity History not showing on Excel

  • June 10, 2019
  • 1 reply
  • 1847 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

H
heymara
New Participant
November 1, 2021

@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
SanfordWhiteman
New Participant
November 1, 2021

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?

Terms & ConditionsAccessibility statement

Loading footer...