Extracting activity data from Marketo

[Anonymous]

A few jobs back, our team was able to extract activity data from Eloqua, in the form of emails sent, opened, clicked and website visits. We used it to create an account profile dashboard for key accounts in a BI tool (see screenshot). We were then able to look at roll-up, account level data, but also at the individual record. 

I want to be able to do something similar, but I'm not sure where to start in terms of the actual data extraction from Marketo.

Has anyone done something similar? I'm guessing we will have to schedule automated blasts via the API, but I just don't have much experience with getting started. Thanks for any insights!

[Anonymous]

This is something we're looking to do as well. @Trask - What BI tool are you using to ingest all of your data?

Steve Pessah

[Anonymous]

Tableau...I still have an old license, but it should do the trick. It's pretty reasonable for a single license.

[Anonymous]

Hi Trask,

We can extract the data only from a Static list through API. To extract all the activity log push all the leads to a static list and extract the data from that list through API. Creating a static list is the first step to extract a data through API.

-------
Vijay

[Anonymous]

Vijay
You can extract all activities using getLeadChanges() api.  Documentation and code sample are at http://developers.marketo.com/documentation/soap/getleadchanges/

You can do this without creating any static lists.

[Anonymous]

Vijay or Raj,

Do you have a tool recommended to extract the data? Or is this more a situation of developing code to achieve the same result? Thanks.

[Anonymous]

You'd have to develop a tool to extract the info you need using our APIs.

[Anonymous]

Raj-

We're having problems with the getLeadChanges API's activityCreatedAt parameter.  It appears that the activityDate for the Leads' activities changes based on what time zone the caller of the API is in.  Even if we pull from just one machine, using the maximum time received from the last call to the API to get new records gives us odd results.  How do we standardize the time?  Could we pull using the activityID instead?

[Anonymous]

Hi,

We have leveraged Marketo and Tableau recently, you can see my reply at the bottom in this post: Integrating with Tableau

Best Regards,

Vivian

[Anonymous]

There are several ways to do it (there are some caveats and a lot of gotchas) -

- Custom build code to call the REST API

- Tableau connector (I wouldn't recommend this)

- Alteryx - which sort of a halfway house of programmatic benefits as well as ease of use

The gotchas are - if you want historical data from your instance you will really struggle to get the data down easily or in a timely manner - the API does not support (that I can see) a filter to get info Between dates - only data FROM a date - i.e. Jan 1 2015 onward will burn through your API calls in no time.   We have several instances which have 2m records plus - so that is 2m x Activity limits - it can easily reach 25m+ rows in now time.