0

I would like to output to the Data Extension below by using SQL Activity to _Subscribers Data Extension in Data View.

I tried using Count and Group By Email Address but the result only allow an email to appear once,

meanwhile I would like it to appear together with all different subscriber keys and with the same number of "Total Subscriber Key with the same Email address" they may have.

Email Address Subscriber Key Total Subscriber Key with the same Email address
[email protected] qwerty 2
[email protected] asdfgh 1
[email protected] zxcvbn 2

Thank you for your time and I appreciate your help

1 Answer 1

0

I tried using Count and Group By Email Address but the result only allow an email to appear once

Then you're halfway there. What you need to do next is join the query you currently have as a subquery with the _Subscribers data view again like this:

Select top 987654321
    b.EmailAddress,
    a.SubscriberKey,
    b.SubscriberCount
From    
    _Subscribers a
Join
    (
        /* Your query here */
    ) b
On
    b.EmailAddress = a.EmailAddress
Order by 
    SubscriberCount desc

Just place your query in designated place and replace SubscriberCount with your name which should store the Total Subscriber Key with the same Email address.

1
  • Thank you Rafal, it worked like a champ! Jul 8, 2022 at 6:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .