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/… – Rafał Wolsztyniak Mar 6 '20 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 Mar 6 '20 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 – Johannes Schapdick Mar 6 '20 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 Mar 6 '20 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 Mar 6 '20 at 11:42

_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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.