What happens to custom object data when on person deletion ? | Community
Skip to main content
M
MoritzTr
New Participant
July 25, 2023
Solved

What happens to custom object data when on person deletion ?

  • July 25, 2023
  • 2 replies
  • 2193 views

Hi

wondering what happens to the custom objects related to a person, when the person is deleted. 

Is the custom object data removed along with the person deletion or will marketo retain orphan custom objects. 

What impacts might this have ?

 

BR,

Moritz

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 Darshil_Shah1

In my opinion, if you have no use for the custom object data, it should be safe to delete it. Even if the person data is recreated, Marketo will not reassociate those custom object records with the respective person record. Additionally, AFAICT, Marketo imposes a limit of approximately 2 million records per custom object. Hence, regularly clearing out records associated with deleted profiles (while being sure you don't need that data) would be a recommended practice.

 

2 replies

Darshil_Shah1
Darshil_Shah1
Community Manager
July 25, 2023

I agree with Michael too. When you delete a person in Marketo Engage, the following happens to the custom object records associated with them:

  • The custom object records are not deleted.
  • The link between the custom object records and the person is broken.
  • The custom object records will no longer be accessible when you filter from the smart list or search for records by the person.

This is because custom object records are not stored directly with people in Marketo. Instead, they are stored in a separate table and linked to people through a link field. When you delete a person, the link between the person and their custom object records is broken, but the custom object records themselves are not deleted.

 

M
MoritzTrAuthor
New Participant
July 28, 2023

Thanks for the replies. 

Is it recommended to clean those orphan objects from the database, or alternatively if we keep them as orphan objects what is the potential impact of that ?

Darshil_Shah1
Darshil_Shah1Accepted solution
Community Manager
July 28, 2023

In my opinion, if you have no use for the custom object data, it should be safe to delete it. Even if the person data is recreated, Marketo will not reassociate those custom object records with the respective person record. Additionally, AFAICT, Marketo imposes a limit of approximately 2 million records per custom object. Hence, regularly clearing out records associated with deleted profiles (while being sure you don't need that data) would be a recommended practice.

 

Michael_Florin-2
Michael_Florin-2
New Participant
July 25, 2023

I'm pretty sure the CO record is maintained. You can't find it anymore through the UI, as no Smart List filter would return it, but you should be able to see it via API.

 

I would also assume that the relationship will be rebuilt once the person record that is linked to that CO record returns.

 

EDIT: The latter is probably not true. The CO record does not show up under the person that I deleted and then re-created. But as expected, the API still finds it.

Terms & ConditionsAccessibility statement

Loading footer...