This seems like it should work, but it doesn't...
select s.TriggeredSendCustomerKey, COUNT(s.TriggeredSendCustomerKey) as Unsubscribes from [01_Sent Data View] s where s.SubscriberKey IN ( select SubscriberKey from _Unsubscribe ) group by s.TriggeredSendCustomerKey
It's pulling numbers, but the numbers do not match the filters in the Sent tracking of Marketing Cloud. I tried distinct, but that didn't change anything. I've tried rearranging this query in so many ways and nothing works. It seems pretty straightforward so I can't figure out what I am doing wrong.
[01_Sent Data View] table is basically all individual sends from August. I pulled those first and now I need to pull people who unsubscribed from that list so I need to see if they are in the _Unsubscribe table. I think my issue is that
SubscriberKey may show up multiple times in
[01_Sent Data View] because a person may have gotten more than one email, but I don't know how to count them only one time.