AnsweredAssumed Answered

Invalid Lead Cleanup

Question asked by 32ce901b06cc61b244fdc1e6063662628040a27e on Jun 8, 2016
Latest reply on Jul 14, 2016 by Kim Gandy

I would like to help ensure data cleanliness and consistency in our database, and wanted to see what suggestions were out there as to how best to do that so that I only remove emails that are actually invalid (junk, mailbox no longer exists, etc.). I am hoping that this will improve our delivery and open/click rates as a result of not sending to emails that are never going to open an email!


The intention is to first remove these from any email and/or nurture programs that they belong to, and then into a quarantine so that the decision whether to completely remove them from our database (Marketo and SFDC) can be made at a later date. The intention behind the quarantine is to ensure that we are potentially giving leads a chance to "wake up" if there is the possibility of doing that, and also to have a chance to check the data before it is removed completely.


To get an idea of where are invalid emails might be sitting, I have pulled the following Smart Campaigns:


  • Invalid Emails
    • Smart List: Email Invalid = True
  • Invalid Emails + Empty Invalid Cause
    • Smart List: Email Invalid = True + Email Invalid Cause = Empty
  • Marketing Suspended + Unsubscribed
    • Smart List: Unsubscribed = True + Marketing Suspended = True
  • Marketing Suspended + No Email Invalid + No Unsubscribe
    • Smart List: Marketing Suspended = True + Email Invalid = False + Unsubscribed = False
  • Unsubscribed
    • Smart List: Unsubscribed = True

The flow for whichever one we use will be to move them into an inactive stream/list and remove them from whatever program they are in.


I am assuming that there will be crossover between many of these campaigns, so, in order to achieve the above desired outcome, is there one or more campaigns that would give me the best results? Is there one that I am missing? If there are multiple items that should be considered the I can create a single campaign with everything in the smart list.


Any insight, suggestions, etc. are welcome and much appreciated as always!