I've got 1000 'leads' in Marketo without email addresses. How can I create a list of them, and then mass delete them all? | Community
Skip to main content
A
Anonymous
January 24, 2014
Solved

I've got 1000 'leads' in Marketo without email addresses. How can I create a list of them, and then mass delete them all?

  • January 24, 2014
  • 2 replies
  • 1294 views
I imported some data, however, I know need to remove some old records. 

How can I run a report to create a list of leads with no email address?

And how to I bulk delete these? 

Thanks, 
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

The best tool for the job is a Smart List in my opinion. Create a new Smart List in Lead Database (and call it something like No Email Address) then in the filter section, drag in Email Address and select in the dropdown "is empty".

You'll then have a Smart List made up of leads which you can choose to delete (using Delete Lead at the top) or any other action you wish to take on this list.

Does that answer your question, Lucy?

EDIT: Breno's solution is even quicker, skipping the list creation step. You can easily automate the process from there too, by scheduling it to run every day, for example!

2 replies

A
Anonymous
January 24, 2014
A simple batch campaign can solve quickly.

Smart list : Email is empty
Flow : Delete Lead

A
Anonymous
Accepted solution
January 24, 2014

The best tool for the job is a Smart List in my opinion. Create a new Smart List in Lead Database (and call it something like No Email Address) then in the filter section, drag in Email Address and select in the dropdown "is empty".

You'll then have a Smart List made up of leads which you can choose to delete (using Delete Lead at the top) or any other action you wish to take on this list.

Does that answer your question, Lucy?

EDIT: Breno's solution is even quicker, skipping the list creation step. You can easily automate the process from there too, by scheduling it to run every day, for example!

Terms & ConditionsAccessibility statement

Loading footer...