Export 20,000+ Records from Campaign Results

[Kim_Gandy1]

My company has to export deliver and bounce results from smart campaigns for auditing purposes. Excel exports from Marketo max out at 20,000 records, but our list size exceeds 20k.

I've already tried separating results by delivered and bounced, but the delivered results alone are over 20,000. Any suggestions how else to export these results?

[Kim_Gandy1 · Accepted solution]

Marketo support hasn't been able to supply an answer why there is a limit, but their team will export results larger than 20,000 upon support request.

[Grégoire_Miche2]

Second thoughts: I misunderstood your issue, which is not an Excel issue but a export one. And this is weird, as you should be able to export more than 20k. We made an 80k export just 2 weeks ago.

-Greg

[Kim_Gandy1]

This campaign yielded 21,000+ results for delivered emails. When I export the list, only 20,000 appear in the file.

[Grégoire_Miche2]

Hi Kim,

You may want to create a smart list with "was delivered email" filter and export it.

-Greg

[Kim_Gandy1]

The export must also include a timestamp of delivery/bounce (auditor's requirement). That's why I was working from the campaign results tab. Would a smart list be able to include a timestamp?

[Priyank_Joshi3]

Hi Kim,

You can either create a campaign to bucket all the 21K leads into a List and do the export. To be doubly sure you can create a smart list to track lead counts.

Thanks

Priyank

[Grégoire_Miche2]

Hi Kim,

Create a smart list that provides the list of leads you want to export.

Then, use a smart campaign with the "random" function to split this smart list content into multiple static lists.

You will see an example of the random function here: Nurture Streams - Have leads randomly placed in a stream

Then export each static list separately.

Upgrade to the most recent version of Excel on a 64 bit system, it supports 1 million lines

-Greg