Pulling in a smart list that provides unique email addresses | Community
Skip to main content
J
Jamie_Barclay
Level 5
August 27, 2018
Question

Pulling in a smart list that provides unique email addresses

  • August 27, 2018
  • 1 reply
  • 4942 views

We have duplicate email addresses in our database.  Is there any way to pull in a smart list that dedupes- providing the counts for unique email addresses?

Than youl

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

    1 reply

    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    August 27, 2018

    Hi Jamie,

    No, there is none

    You can easily have a mart lists of the people that do not have any duplicates, using a "member of smart list - NOT IN - Possible Duplicates" filter.

    But to count the unique email addresses, I extract the duplicate list and dedupe it in Excel.

    -Greg

    J
    Jamie_BarclayAuthor
    Level 5
    August 29, 2018

    Thanks Greg.  I actually pulled from Marketo into Access.  All in all it's a lot of work.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    August 30, 2018

    ⇣

    ⇣

    ⇣

    ⇣

      Terms & ConditionsAccessibility statement

      Loading footer...