Export All Columns...recommendations? | Community
Skip to main content
Valerie_Armstro
Valerie_Armstro
Level 9
April 21, 2015
Solved

Export All Columns...recommendations?

  • April 21, 2015
  • 2 replies
  • 1476 views

Hi Community!

I have a rather larger list of leads I'd like to export from Marketo to be stored in an external database (we're cleaning out our inactive records to reduce our database size).  

Ideally, I would like the export file to have all fields and data associated with the leads in this list, but with the size of the list and the number of fields we have in Marketo, I'm concerned that the export will fail due to the size or could create a conflict with other processes that are running (e.g. email sends, triggers).  Has anyone else done something like this? Any tips or suggestions would be greatly appreciated.

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
I am actually doing this right now as well. I just exported all columns for 240k leads (a lot of columns). It took about 24 hours to complete, and the file is over 370MB. It worked without any impact on the campaign queue. Good luck!

2 replies

A
Anonymous
Accepted solution
April 21, 2015
I am actually doing this right now as well. I just exported all columns for 240k leads (a lot of columns). It took about 24 hours to complete, and the file is over 370MB. It worked without any impact on the campaign queue. Good luck!
A
Anonymous
April 21, 2015
I would stagger the export. You can do this by using lead first name field and have the constraint "starts with "A, B, C, D, E" in the first set, then create another list and export the next set of letters, until you get through the entire alphabet. That way you can have a lot of columns but won't bog down the system exporting thousands of leads.
    Terms & ConditionsAccessibility statement

    Loading footer...