Report of all leads and the campaigns sent to each | Community
Skip to main content
July 9, 2013
Solved

Report of all leads and the campaigns sent to each

  • July 9, 2013
  • 3 replies
  • 1451 views
Hi, I'm looking to create a large tabular report that I can export into Excel.  The report would have leads for the rows (i.e., we have about 5K leads so that would be 5K rows).  For each lead I want to see which campaigns were sent to each lead, on what date (so there would be many columns).  Does anything like that exist?  If not, how can I create it?
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
Here's the link to Marketo's Deep Dive on SOAP API

http://community.marketo.com/MarketoDeepDive?id=kA5500000008QN3CAM



3 replies

July 9, 2013
I don't think there is a way to get that out through the UI in a format at all close. For most Marketo instances, that would simply be too much data. Possibly you could use the SOAP API and call getLeadActivity for each lead and output it to a file.
July 10, 2013
Erik, thanks for your reply.  Can you point me to any help articles that explain how to use the SOAP API?
Accepted solution
July 12, 2013
Here's the link to Marketo's Deep Dive on SOAP API

http://community.marketo.com/MarketoDeepDive?id=kA5500000008QN3CAM