When I query _Subscribers I can see a record with a status "unsubscribed"

There is nothing related in the _Unsubscribe data view though (I've checked all Business units in the multi org structure)

from _Subscribers as s

join _unsubscribe as u
on s.subscriberid = u.subscriberid

where s.subscriberKey = 'Foo_1' 

What am I missing?

  • 1
    Is this in a child business unit? If yes, try this data view: BusinessUnitUnsubscribes - help.salesforce.com/… Commented Mar 6, 2020 at 10:47
  • I can see the event date (few days ago) but cannot find anything related in _Unsubscribe or _BusinessUnitUnsubscribes - would those capture a manual unsubscribe (by a MC admin for instance)
    – jc_mc
    Commented Mar 6, 2020 at 11:03
  • 1
    You can also import a contact that is unsubscribed and you will never find any unsubscribe of that contact. You can still write transactional mails to that contact. So a valid use case Commented Mar 6, 2020 at 11:18
  • That's correct @JohannesSchapdick - it is a bit frustrating though that I am not able to track how did that happen for sure
    – jc_mc
    Commented Mar 6, 2020 at 11:27
  • After investigating this a little bit more I believe the problem was what @JohannesSchapdick said - it was synced from SFDC as unsubscribed already
    – jc_mc
    Commented Mar 6, 2020 at 11:42

1 Answer 1


_Unsubscribe holds unsubscribe events that are tied to a specific send job. These occur when a subscriber uses an unsubscribe/profile center link from an email or when the LogUnsubEvent API request is made.

_Unsubscribe will not log an event when a subscriber's status is changed due to import, Subscriber update API request, or when changed via UI.


You must log in to answer this question.

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