So I want to export the list of opens by time of day.
There are a total of 164,557, but Marketo is exporting into Excel vs. CSV and only 20,000 are pulling in. 😞
Is there any way to get the export to export into a CSV file or to be able to pull this information in a different way?
You are trying to pull the activity log from a campaign. It would be better to run a smart list on Opened Email IS X from timeframe. That will export the list of people who opened much faster.
try emailing firstname.lastname@example.org
There is a function that Marketo can use to extract it from the backend, but it does take some time.. it may well be a paid engagement with Marketo professional services.