Exporting Detailed Activity

[Anonymous]

We are in the process of doing an in-depth analysis of our lead activity and how it relates to their behavior in other channels.  To do that, we need to export all of the leads (which isn't an issue) and then a list of the emails they have been delivered, those they opened, those clicked on, and then the details of the email.  This would obviously be four different exports but I can't seem to find a way to do this within the Reporting interface.

Is this possible to do? We'd be willing to write some custom code and utilize the API if this will do the job.

Thanks,

Kevin

[Anonymous]

A matrix with all recipients vs all sent emails would be unreadable, I guess.
Especially when you want to also angle this with data from other channels.

You need some serious BI tools for what you want to analyze. And I'm not sure if you can even export all the fields you need to tie it all together (e.g. a lead export won't list any email ID and email reports don't list lead ID).

Maybe run a lead report, grouped by Email Address, and filtered on "Was sent email X". But you would need to run a report for each email. We have simply too many to do such an exercise.

ReST API provides access to lead acivity (filter by type is email). But I can't find if it will list the name of the email. If so, it would solve your issue.  http://developers.marketo.com/documentation/rest/get-lead-activities/

SOAP at least does provide it:
http://developers.marketo.com/documentation/soap/getleadactivity/