A report on failed record updates | Community
Skip to main content
New Participant
February 8, 2024
Solved

A report on failed record updates

  • February 8, 2024
  • 3 replies
  • 2000 views

Is it possible to generate a smart list or report that displays all records that failed to update? For instance, when an individual attempts to modify their job title on a web form for an existing record, but the update fails. Thank you.

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 Katja_Keesom

Hey there, that is a tricky ask, because it is difficult to report on something NOT happening, which is effectively what you want. There are two directions I am thinking of that could potentially help:

  1. You could hypothetically set up a People Performance report with custom columns, where a custom column could be all people having filled out a specific form and any field on the form not having received an update in the same time window. Does not work generically, but only for specific situations you want to monitor for.
  2. Assuming the same scenario, if someone tries to fill something out in the form and the value somehow is not accepted, my assumption would be the form doesn't submit and the person does not land on the thank you page. This is something you could monitor for via your Analytics set up.

3 replies

Jo_Pitts1
Community Manager
February 8, 2024

@nurture_ninja ,

what's the use case?  Why would the update fail in this instance?

Cheers

Jo

SanfordWhiteman
New Participant
February 9, 2024

what's the use case?  Why would the update fail in this instance?

Yep, I really don’t understand what we’re talking about there. The only situation where field updates “fail” (a very debatable term for it!) is if updates are explicitly blocked in Field Management.

 

If one wants to know when someone attempted to change a field, the answer is to expose a proxy field on the form (which isn’t blocked from updates) and watch for Data Value Changes on that field.

KevinH-2
New Participant
February 8, 2024

Another idea that comes to mind could be to trigger a webhook on form fill, that checks the fields filled by the form against whatever you define as success or failure in the webhook's code. The webhook then could return an answer to a custom Marketo field that states validation success or failure. You could then build reports on that field. 

 

This would require to set up the webhook though, so this solution would not reside within Marketo alone.  The effort would need to be justified by the importance of the usecase. 

Katja_Keesom
Katja_KeesomAccepted solution
Community Manager
February 8, 2024

Hey there, that is a tricky ask, because it is difficult to report on something NOT happening, which is effectively what you want. There are two directions I am thinking of that could potentially help:

  1. You could hypothetically set up a People Performance report with custom columns, where a custom column could be all people having filled out a specific form and any field on the form not having received an update in the same time window. Does not work generically, but only for specific situations you want to monitor for.
  2. Assuming the same scenario, if someone tries to fill something out in the form and the value somehow is not accepted, my assumption would be the form doesn't submit and the person does not land on the thank you page. This is something you could monitor for via your Analytics set up.