Help: Mass deleting leads

Forum|Forum|8 years ago
May 18, 2017
1 reply
5785 views

Hello,

I'm currently working on deleting a large amount of leads out of the Marketo database (we're removing b2c contacts and keeping b2b contacts). The goal is to stagger the deletes out to about 50k or so a night, but I'm having trouble figuring out how to get that exact number into a smart list/campaign without using too many specific filters to cut the numbers down. Does anyone know if there's a way to limit a query to a specific number of leads?

Marketo

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 Devraj_Grewal

Kayleen,

Run the leads through a smart campaign with the "Delete Lead" flow step. Add a choice condition of "Random sample is 10%" and the default choice is to "Do Nothing". This means that when leads run through, only 10% will be deleted. Repeat as necessary while gradually increasing the random sample percentage.

Devraj_GrewalAccepted solution

New Participant

Kayleen,

Run the leads through a smart campaign with the "Delete Lead" flow step. Add a choice condition of "Random sample is 10%" and the default choice is to "Do Nothing". This means that when leads run through, only 10% will be deleted. Repeat as necessary while gradually increasing the random sample percentage.