How to remove leads with invalid emails from database | Community
Skip to main content
September 24, 2014
Question

How to remove leads with invalid emails from database

  • September 24, 2014
  • 3 replies
  • 1651 views

We have 42 hard bounces in our instance. I ran a smart list of invalid emails (Email invalid = true) and it showed 39 records. Why wouldn't the numbers match up?
 

And what's the best way to go about removing all the leads with invalid emails from our database?

Thanks 
David

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Josh_Hill13
Level 10
September 24, 2014
Marketo doesn't necessarily invalidate hard bounces, so this is not a good comparison. Once Invalid, Marketo won't send out email to those records.

See: http://www.slideshare.net/jdavidhill/marketo-email-reputation-management

The easiest way to handle invalid emails is to run a smart list, like you have, and then review and delete records as appropriate. The above slides have more detail on how Marketo handles hard bounces and invalid emails. You can add some flows to manage these too:

1. Email Invalid Restorer - remove invalid flag if email address is changed
2. Invalidate or Suspend hard bounced leads who bounced at least twice in past 30 days.
3. Check that smart list once a month to remove obviously bad records.

I strongly urge you to be careful with auto deletion.
See http://www.marketingrockstarguides.com/how-to-fix-data-disaster-in-marketo-1710/

Keep in mind that Invalid emails doesn't mean that the lead is completely bad. The record may be from a customer too, so someone needs to follow up to verify the email address.


Edward_Masson
Level 10
September 24, 2014
Do you use workspaces and leaad partations in your instance? You may be limited to what your login can see.
Michelle_Tizian
Level 10
September 24, 2014
On Josh's #2, I date and make a note of the frequent bounces in a field that can also be seen in SFDC.  I then remove them from our Marketo database.  Our list specialist will review the bad emails on the SFDC side and exclude them from any future email promos.  If it's a paid customer, our sales associates will call to get a replacement email.