Group by email

[rbiri]

Hi

I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type.

ex:

email	consent yype
recipient@domain.com	opt out
recipient@domain.com	opt out
recipient@domain.com	opt in

And what I need to get is how many emails i have in my database with same email but different consent log

[KellieGWAB · Accepted solution]

@rbiri - is this for Workfront? Are you trying to manage your user accounts?

[rbiri]

sorry this is for another community

[Madalyn_Destafney]

You are referencing emails of users in your WF instance, correct?

If so, create a User report, go to Groupings, group by email address:

If this helped you out, please mark correct to help others : )