AnsweredAssumed Answered

exporting all marketo activities

Question asked by Brett Wulfekuhle on Jan 3, 2017
Latest reply on Jan 4, 2017 by Sanford Whiteman

Like • Show 1 Like1
Comment • 3

My company currently uses the BI software Qlik to measure company performance and other KPIs. Now we would like to use Qlik to measure campaign performance and ROI for our Marketo campaign, programs, and website activity. My initial thought was to export all of our recorded marketo activities (webpages viewed, forms filled out, landing pages visited, emails opened, etc...) and then upload them to Qlik for analysis. Is this possible? If so, how do I go about doing it? If not, is there a better way to accomplish my goal?

Any input is greatly appreciated. Thanks,

Brett W.

No one else has this question

Outcomes

Sanford Whiteman Jan 3, 2017 12:53 PM

Please move the question to Products. "Community" here referes to the Marketo Nation website itself -- and yes, this is very confusing.

You can use the REST API Activities endpoint to export the consolidated activity log yes... see the docs.

Actions

47c00a833be1d05d3cb56f450c06da5ebd9b3fac Jan 4, 2017 10:22 AM

We have faced these issues with many of our clients. The challenge is that Marketo Activity data is very bulky that there is no out of the box way to do this. The solution is, we can export all the Marketo activity data using the Marketo API, however, if you are trying to pull out all of it at once the Marketo API will time out. For such cases, we have developed a tool which will fetch the historical data in small packets and store it in a database. After we have fetched all the historical data, we can just add to it incrementally every few hours to keep it updated.

Hope this will help.

Actions

Sanford Whiteman @ 47c00a833be1d05d3cb56f450c06da5ebd9b3fac on Jan 4, 2017 11:56 AM

There's no such thing as "all at once" with the Activity API. Data always needs to be fetched in batches, starting from checkpoints.

1 person found this helpful

Actions

3 Replies

Sanford Whiteman Jan 3, 2017 12:53 PM
Mark Correct
Correct Answer
Please move the question to Products. "Community" here referes to the Marketo Nation website itself -- and yes, this is very confusing.

You can use the REST API Activities endpoint to export the consolidated activity log yes... see the docs.
Like • Show 0 Likes0
Actions
47c00a833be1d05d3cb56f450c06da5ebd9b3fac Jan 4, 2017 10:22 AM
Mark Correct
Correct Answer
We have faced these issues with many of our clients. The challenge is that Marketo Activity data is very bulky that there is no out of the box way to do this. The solution is, we can export all the Marketo activity data using the Marketo API, however, if you are trying to pull out all of it at once the Marketo API will time out. For such cases, we have developed a tool which will fetch the historical data in small packets and store it in a database. After we have fetched all the historical data, we can just add to it incrementally every few hours to keep it updated.

Hope this will help.
Like • Show 0 Likes0
Actions
- Sanford Whiteman @ 47c00a833be1d05d3cb56f450c06da5ebd9b3fac on Jan 4, 2017 11:56 AM
  Mark Correct
  Correct Answer
  There's no such thing as "all at once" with the Activity API. Data always needs to be fetched in batches, starting from checkpoints.
  1 person found this helpful
  Like • Show 1 Like1
  Actions

exporting all marketo activities

Outcomes

Related Content

Recommended Content