Pulling in a smart list that provides unique email addresses

Jamie_Barclay
Level 5

Pulling in a smart list that provides unique email addresses

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

9 REPLIES 9
Grégoire_Miche2
Level 10

Re: Pulling in a smart list that provides unique email addresses

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

Jamie_Barclay
Level 5

Re: Pulling in a smart list that provides unique email addresses

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

SanfordWhiteman
Level 10 - Community Moderator

Re: Pulling in a smart list that provides unique email addresses

pastedImage_1.png

pastedImage_2.png

pastedImage_5.png

pastedImage_3.png

pastedImage_4.png

SanfordWhiteman
Level 10 - Community Moderator

Re: Pulling in a smart list that provides unique email addresses

Jamie Barclay

And Grégoire Michel​ while I'm at it.

Grégoire_Miche2
Level 10

Re: Pulling in a smart list that provides unique email addresses

But it counts the total of emails, not the number of unique addresses.

And then, you can export the report and count the lines in Excel.

-Greg

SanfordWhiteman
Level 10 - Community Moderator

Re: Pulling in a smart list that provides unique email addresses

But I wouldn't call this "a lot of work"! You don't have to do anything but open it in Excel to see the line count.

Grégoire_Miche2
Level 10

Re: Pulling in a smart list that provides unique email addresses

Agreed!

SanfordWhiteman
Level 10 - Community Moderator

Re: Pulling in a smart list that provides unique email addresses

Actually, you don't even need to export to get the count...

pastedImage_0.png

... although like with any report you may need to export just to see all the results.

Lynn_Ray_Pardo
Level 5

Re: Pulling in a smart list that provides unique email addresses

Wow! That is brilliant, Sanford! Thank you so much!

If I'm understanding this correctly, this could provide a sweet visual into how many leads are subscribed to multiple newsletters.

And hopefully, better understand just how many of those people get lost during a global unsubscribe.

So grateful!
Lynn