Report showing unconverted leads with invalid email?

Anonymous
Not applicable

Report showing unconverted leads with invalid email?

I am trying to create a list of leads in Marketo that where invalid email is True AND they have not been converted in SFDC. Can't quite figure out how to get the unconverted portion of the equation. Any ideas?
Tags (1)
3 REPLIES 3
Anonymous
Not applicable

Re: Report showing unconverted leads with invalid email?

Try Email Invalid True and SFDC Type (lead not account level) is Lead.
Not sure if that meets your definition of "not converted" but that's what pops into my head. 

Otherwise "not converted" may be to use Has Opportunity is False.
Hope that helps.
Anonymous
Not applicable

Re: Report showing unconverted leads with invalid email?

Thank you Miss Janet! 🙂
Anonymous
Not applicable

Re: Report showing unconverted leads with invalid email?

Also add:

last name not contains "a, e, i, o, u, y"

last name contains " 1, 2, 3, 4, 5, 6, 7, 8, 9"