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

Jamie_Barclay
Level 5

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

So I want to export the list of opens by time of day. 

pastedImage_1.png

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?

pastedImage_2.png

Thank you

5 REPLIES 5
Josh_Hill13
Level 10 - Champion Alumni

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

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
Level 5

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

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

Thank you

Jamie_Barclay
Level 5

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

does any one have any insight here?

Nicholas_Manojl
Level 9

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

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
Level 5

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

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