[SalesForce] unsubscribed contacts from All Subscribers – Child Business Unit

I need to extract unsubscribed contacts from All Subscribers in a child Business Unit in Marketing Cloud using SQL Query.

I tried to use this code, but it didn't give me any results.

SELECT DateUnsubscribed, EmailAddress 
FROM _Subscribers 
WHERE Status = 'unsubscribed'

Do you have any suggestions?

Best Answer

@cmbob I've ran into this issue as well. How it was explained to me by support is that the business unit level data view, _Subscribers, only contains records that have a different status from the parent. So, if a records is 'active' in both the parent and child, then that record will not exist in this data view.

The best way I have found for determining the Business Unit level subscriber status is by running a Tracking Extract from the Business Unit and include 'All Subscribers' in your extract. The resulting subscribers.txt file will contain that status relative to that business unit.

Related Topic