8 Replies Latest reply on May 15, 2017 7:20 AM by Osman Erzinclioglu

    Generate Report Based on Marketo Custom Object Data

    Osman Erzinclioglu

      Hello,

      We're considering creating a custom object to store some data from registration forms each time that data is submitted.

      Event

      Entry

      First

      Last

      Institution

      ABC123

      A

      Osman

      Erzinclioglu

      Institution A

      ABC123

      B

      Ozzie

      Smith

      Institution B

      ABC124

      C

      Osmond

      Smythe

      Institution A

      The "event" column would represent a specific event but there may be more than one "entry" for a given event. The "entry" code would be entirely unique - likely a date stamp. What we'd like to be able to do is to generate a report of all the "entries" for event ABC123, as well as the corresponding data points for each "entry" for an event. Depending on the lead, it could be zero "entries" or many entries.

      The data is being used to generate certificates, so their first, or even last name, might differ each time, depending on how they would prefer their name to appear on that certificate.

      This object would be tied to the lead by e-mail address.

      Is there a way to export all records or to run a query for all records where the event value is "ABC123"? Would we need to leverage the API to generate such a report? I didn't see an option to export all records in Marketo.