Skip to main content
Sid_Patil
Sid_Patil
Level 2
April 18, 2018
Solved

Exporting Marketo database periodically

  • April 18, 2018
  • 2 replies
  • 4901 views

Hello guys,

I have to periodically report on our database health which includes how many new columns/rows of people we added each week, how many of them had blank/no-blank/unique values and so on. Currently, it takes me more than a day to export all my Marketo contacts and I have to do this every week. What's the best way to automate this step? Even third-party solutions are appreciated!

Thank you so much!

@Sanford Whiteman​

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 Grégoire_Miche2

Hi Sid,

http://developers.marketo.com/rest-api/bulk-extract/

With regards to the DLM product I do not know whether this issue was fixed. You will need to contact the vendor for this.

-Greg

2 replies

Grégoire_Miche2
Grégoire_Miche2
Level 10
April 18, 2018

HI Sid,

Marketo APi is not well tuned to do a massive export unless you use the brand new bulk API;

There are some solutions our there that can export incremental data every day into an SQL database, in which you could create such a query with a BI front end. Look for instance into DLM, in the launchpoint.

-Greg

    Sid_Patil
    Sid_PatilAuthor
    Level 2
    April 20, 2018

    Hello @Grégoire Michel​

    Thanks for replying. What's the brand new bulk API - do you mind sharing the link?

    I have heard about DLM however in one of the forum post someone pointed out a few security concerns with its API (Replicate Marketo Database ). Let me know what you think about it

    Grégoire_Miche2
    Grégoire_Miche2Accepted solution
    Level 10
    April 20, 2018

    Hi Sid,

    http://developers.marketo.com/rest-api/bulk-extract/

    With regards to the DLM product I do not know whether this issue was fixed. You will need to contact the vendor for this.

    -Greg

    Sid_Patil
    Sid_PatilAuthor
    Level 2
    April 26, 2018

    Quick question
    The API tells me that Leads and Activities can be extracted. Would Leads here refer to only those contacts that are part of active programs being run in Marketo and not any dormant contact that may be part of my database?

    @Sanford Whiteman​

    @Grégoire Michel​

    Thank you for all the guidance, guys. You have been of amazing help in my Marketo learning curve

    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    April 26, 2018

    Hi Sid,

    Lead refers to any person in your database.

    -Greg

      Grégoire_Miche2
      Grégoire_Miche2
      Level 10
      April 26, 2018

      And pls mark the question as answered for future reference

        Terms & ConditionsAccessibility statement

        Loading footer...