Exporting the list of opens by date/time is cutting of at 20K

[Jamie_Barclay]

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?

Thank you

[Josh_Hill13]

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.

[Jamie_Barclay]

But that doesn't show the time that people opened.  That's what I need.

Thank you

[Jamie_Barclay]

does any one have any insight here?

[Nicholas_Manojl]

try emailing support@marketo.com

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.

[Jamie_Barclay]

Thanks Nicholas - just curious, does it have to do with setting up an API call?