Marketo DB Export | Community
Skip to main content
A
Anonymous
October 13, 2017
Question

Marketo DB Export

  • October 13, 2017
  • 2 replies
  • 7436 views

@Jep Castelein​,

Here (Marketo Replication to Data Warehouse ) you mention the option to export the db snapshot for customers.

How can we get hold of that snapshot for our account?

To give you some background: we are building a data pipeline and building models for varied business questions. Marketo is one of the many source systems. Going forward we have setup a service to work with the bulk api and extract ongoing events across leads and activities in a periodic manner. For backfilling historical data we need that one large export.

All help in this regard will be appreciated!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Trevor_Parsell
    Trevor_Parsell
    Level 5
    October 13, 2017

    Hey Osama,

    You can export your Marketo database by going to Lead Database>System Smart Lists>All Leads>Click the "Leads" tab then select the export button at the bottom.

    Thanks!

    A
    Anonymous
    October 13, 2017

    Thanks for such a prompt response! The activities data export is the one I am more concerned about (due to its size). Anyway to self-serve that entire table/db?

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    October 13, 2017

    Why do you need the one large export?  How many years are you talking about?

    A
    Anonymous
    October 13, 2017

    More or less 4 years

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    October 13, 2017

    So with bulk Activity Extract, that's 76 CSVs (19 per year), half of which will be very tiny (the leftover days in a 31-day month). I don't know about your volume per month but this could take less than a workday to run.

    Terms & ConditionsAccessibility statement

    Loading footer...