group by email | Community
Skip to main content
R
rbiri
Level 3
October 17, 2023
Solved

group by email

  • October 17, 2023
  • 1 reply
  • 826 views

Hi

 

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

 

ex:

emailconsent 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

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

Hi @rbiri,

Query:

Fetch all recipients, Filter as, Primary key is not empty. 

Complementary information:

Add data > Data linked to the filtering dimension > Data of the filtring dimension >

Add:

@email

@consentTypeAttribute

count(@consentTypeAttribute)

Select 'Group' checkbox for email and consentTypeAttribute alone

In Advanced parameter, check 'Disable automatic adding of PK'

Now you will be getting the count

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
October 18, 2023

Hi @rbiri,

Query:

Fetch all recipients, Filter as, Primary key is not empty. 

Complementary information:

Add data > Data linked to the filtering dimension > Data of the filtring dimension >

Add:

@email

@consentTypeAttribute

count(@consentTypeAttribute)

Select 'Group' checkbox for email and consentTypeAttribute alone

In Advanced parameter, check 'Disable automatic adding of PK'

Now you will be getting the count

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...