2 Replies Latest reply on Dec 19, 2016 12:00 PM by 83190a577e6a4d0c2976f96394a1831f73b5f7aa

    Reporting / results through the API

      Noob to marketo and the whole premise of sales and marketing so forgive me as I figure out new terms and such. I'm an API developer who is working on feeding result data to our other systems. But I am having a hard time figuring out how to access that data. I've read through the documentation and I must be missing something but I can't tell if I could find it through assets, or leads or?? I've tried a few APIs so I can see IDs and records, but can't seem to find result oriented data. Ideally looking for the same thing we get from the campaign results xls / csv export only via API. I've attached an example of the report.

       

      I don't mind doing the research if someone can point me in the right direction.

       

      ~TIA!

        • Re: Reporting / results through the API
          Sanford Whiteman

          Please move the thread to Products. "Community" in this case refers to the Marketo Nation website itself.  Support questions go in the Products space (and yes, this is confusing!).

           

          Anyway, this is more complex than you're hoping. The Marketo API does not easily (or, really, at all) allow for replication of in-built reporting via a single endpoint. The API gives access to raw data via numerous virtual tables (basically re-relationalizing an object model that's already on top of relational data). But it's going to be on you to pull all of the tables together.

           

          In brief, what you probably want is to pair the Lead >> Activities endpoint with results from Lead >> Leads.

          2 of 2 people found this helpful