Group by email
Hi
I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type.
ex:
| 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

