Pulling in a smart list that provides unique email addresses

[Jamie_Barclay]

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

[Grégoire_Miche2]

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]

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

[SanfordWhiteman]

⇣

⇣

⇣

⇣

[SanfordWhiteman]

Jamie Barclay​

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

[Lynn_Ray_Pardo]

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

[Grégoire_Miche2]

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]

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]

Agreed!

[SanfordWhiteman]

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

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