0

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) 

select
s.subscriberKey
,s.Status
,s.DateUnsubscribed
,s.EmailAddress
from _Subscribers as s

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

where s.subscriberKey = 'Foo_1'

What am I missing?

Improve this question
5
  • 1
    Is this in a child business unit? If yes, try this data view: BusinessUnitUnsubscribes - help.salesforce.com/…
    – Rafał Wolsztyniak
    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
    – Johannes Schapdick
    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

Reset to default
3

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

Improve this answer
1

You must log in to answer this question.

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