Finding leads that were sent only 2 specific emails | Community
Skip to main content
Jennifer_Bisho1
New Participant
August 10, 2016
Solved

Finding leads that were sent only 2 specific emails

  • August 10, 2016
  • 1 reply
  • 2450 views

So we had 2 emails that accidentally were sent to our entire database, which caused us to get blacklisted.  I'm trying to see if I can identify the leads in our database that received ONLY those 2 emails and nothing else ever from Marketo.  Is there a way to do this in a Smart List perhaps?  We have a bunch of inactive leads that I cannot identify so I thought this may be a way of finding those to be deleted since they are not being included on any other sends. 

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

Jennifer,

What you can do is pull a smart list with the filter of was sent email for each email ("email 1" & "email 2") and make sure you have "all" logic selected. Then pull in the inactivity filter "not was sent email": email is not "email 1" or "email 2".

1 reply

Devraj_Grewal
Devraj_GrewalAccepted solution
New Participant
August 10, 2016

Jennifer,

What you can do is pull a smart list with the filter of was sent email for each email ("email 1" & "email 2") and make sure you have "all" logic selected. Then pull in the inactivity filter "not was sent email": email is not "email 1" or "email 2".

Jennifer_Bisho1
New Participant
August 10, 2016

Great, thanks!  I thought it would be something along those lines.

It's saying it can't find the second email but I KNOW the exact name of it and it's approved.  Any idea why it's saying it's not found?  It was in a Default program.  Not sure if that makes a difference.

Devraj_Grewal
New Participant
August 10, 2016

Not sure actually. Are you using the constraint "email is" or "email contains"? "Email is" will choose the exact email name.