Database inconsistency | Community
Skip to main content
Shawn_Granniss
Shawn_Granniss
Level 2
October 19, 2018
Question

Database inconsistency

  • October 19, 2018
  • 1 reply
  • 1800 views

Hello,

My database says I have 46000 leads but when I look at my "marketable leads" list it says I have 27000. How do I find the 19000 "un-marketable leads"?

Thanks

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

1 reply

Anne_Angele1
Anne_Angele1
Level 3
October 19, 2018

You can pull a smart list (use ANY logic):

  • No Email address
  • Email Invalid is true
  • Unsubscribe is true
  • Marketing Suspended is true
  • Email has hard bounced

That will give you all of your unmarketable leads.

Grégoire_Miche2
Grégoire_Miche2
Level 10
October 20, 2018

Add "blacklisted is true" and "suspended is true" to the filters. "Suspended" and "Marketing suspended" are 2 different things.

"Email has hard bounced" is not necessary. They will show as "email invalid". This filter can even give wrong results, since the email address might since have been fixed and be now working.

-Greg

Terms & ConditionsAccessibility statement

Loading footer...