AnsweredAssumed Answered

Generate Report Based on Marketo Custom Object Data

Question asked by Osman Erzinclioglu on Jun 13, 2016
Latest reply on May 15, 2017 by 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.

Outcomes