We're considering creating a custom object to store some data from registration forms each time that data is submitted.
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.