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!
Solved! Go to Solution.
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.
I think it might (?) have been fixed but still doesn't use Bulk Extract, which I agree is the only practical way to do this for large/active dbs (actually a combo of Bulk Extract with a touch-up via Bulk Export).
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?
Thank you for all the guidance, guys. You have been of amazing help in my Marketo learning curve