"Already in database" | Community
Skip to main content
Casey_Muller2
Casey_Muller2
Level 3
January 23, 2019
Question

"Already in database"

  • January 23, 2019
  • 1 reply
  • 2044 views

Hello,

I need to send out an email with these requirements:

ALL

-Member of uploaded list

-Already in the database

What filter would I use?

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

1 reply

Devraj_Grewal
Devraj_Grewal
Level 10
January 23, 2019

Casey,

If you create a smart list with the filter:

Member of List: List A (whatever the list name is)

The resulting People will be those members of the list and in your People Database. So you do not need an additional filter for being in the database since being a member of a list will mean they are already in your database.

SanfordWhiteman
SanfordWhiteman
Level 10
January 23, 2019

I think Casey means they were in the uploaded CSV but were merged into existing leads, not created by the list upload.

Denise_Greenb12
Denise_Greenb12
Level 6
January 23, 2019

Casey - If Sanford is right about what you meant then depending upon your let up you can add a filter that excludes people who were created by that list import. For example, ideally that list was part of a program and when the list was imported the Acquisition Program Name was populated by the name of that program. If so, the filter would be Acquisition Program is Not "Name of List Import Program." Again, depending on your setup, perhaps there's a Lead Source Detail field with the name of the list. If so, add a filter that excludes it (Lead Source Detail is "Not Name of List"). If neither of those things is in place (and they should be), then you can always use timing:

Not Person Was Created in past 1 hour, 3 hours, 4 days... whatever time period makes sense to nail down when you imported the list.

Denise

Terms & ConditionsAccessibility statement

Loading footer...