Re: How long will it take for deleted leads to be reflected in database?

Keegan_Connolly
Level 1

How long will it take for deleted leads to be reflected in database?

Hello,

I am a member of a team that inherited a very messy instance of Marketo. We recently went over our compliance limit are are trying to remove a large amount of leads that have no marketable value from Marketo.

We built a list of people that were in Marketo but not Salesforce. This list amounted to about 31,000 people due to poor database management from the people we inherited the system from. I then followed the steps from this support document: Delete People in a Smart List or List - Marketo Docs - Product Documentation. I built the list in Marketing Activities, selected all, and then finally clicked delete person. I waited almost an hour for the process to run since it was so many people, processed in batches of 200. When it was done, the smart list I had built was empty (besides a few unsubscribes) but when I went to the database tab, the "All People" system smart list still showed the same count as when we started. The people that were deleted were pulled directly from this list (and then compared to a list of everyone in Salesforce both leads and contacts) so this makes no sense to me.

I spot checked about 10 leads from the deleted list and searching by email I couldn't find any of them in the database.

I am confused by this all but I am sure there is a simple explanation. Anyone with experience deleting such a large number of people from a database, how long does it typically take for the deletion to be reflected in the database tab of Marketo? Is there anything I missed? I appreciate any response.

4 REPLIES 4
Amit_Jain
Level 8 - Community Advisor

Re: How long will it take for deleted leads to be reflected in database?

Just try refreshing the "All People" smart list. It should fix the count.

TrishVosko_Spea
Level 1

Re: How long will it take for deleted leads to be reflected in database?

that didn't work

Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How long will it take for deleted leads to be reflected in database?

Upon the successful execution of the Delete Person flow step, respective people should get deleted from the Marketo , maybe wait for some time and check the count again? Marketo is at times slow to update the count - especially when your db size is large and you have processed i.e., deleted too many leads.

Are you able to see any of the leads that you deleted in the db (maybe try spot-checking)?

Katja_Keesom
Level 10 - Community Advisor + Adobe Champion

Re: How long will it take for deleted leads to be reflected in database?

You say the people you deleted can no longer be found in the database and indeed, normally deletion is virtually instantaneous. If your overall count consistently stays around the old level, I would check how many people were added to the database on that same day. Might be someone happened to upload a list somewhere that offset your work.