Exporting Marketo database periodically | Community
Skip to main content
Sid_Patil
Sid_Patil
New Participant
April 18, 2018
Solved

Exporting Marketo database periodically

  • April 18, 2018
  • 2 replies
  • 4860 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

Sid_Patil
Sid_PatilAuthor
New Participant
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
New Participant
April 26, 2018

Hi Sid,

Lead refers to any person in your database.

-Greg

    Grégoire_Miche2
    Grégoire_Miche2
    New Participant
    April 26, 2018

    And pls mark the question as answered for future reference

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

        Terms & ConditionsAccessibility statement

        Loading footer...