0

I have written the following query in my child BU to get data from subscribers.

Select
EmailAddress,Status,Subscriberkey,DateUnsubscribed
from ent._Subscribers

I am storing this records in Data Extension. "Status" field for 4-records is "Unsubscribed" in Subscribers. but, after checking records in data extension, the Status for the Same record is Showing "active". all other fields data is correct
any specific reason?

4

The first answer is entirely correct, BUT the solution has become much easier lately, with the introduction of the new data view businessUnitUnsubscribes, which eliminates the need for the (correct) workaround linked by Brad.

https://help.salesforce.com/apex/HTViewHelpDoc?id=mc_as_data_view_businessunitunsubscribes.htm&language=en_us

Hope this helps!

Edit: to clarify -

BusinessUnitUnsubscribes has the current BU-wide subscription status, IF that status is unsubscribed. It does not hold the subscriber status if it is active, held or bounced. Since it does also not hold events (unlike _Unsubscribe data view), it will always only show current status (...if it's "unsubscribed", that is.).

8
  • What about when a subscriber does an Unsub and then re opt back in? From what I can tell, BusinessUnitUnsubscribes will only capture the unsub event and not the subscribers current opt-in status. Therefore it is only telling half the story. – charliefay Apr 19 '20 at 12:31
  • Hi, to my knowledge, BusinessUnitUnsubscribes has exactly the opposite: current BU-wide subscription status, not events. It was specifically added to address this problem, which was very complicated to solve (see other answer) with ENT._Subscribers and the status there. Contrary to that, the _Unsubscribe data view indeed stores events. – Jonas Lamberty Apr 20 '20 at 6:58
  • This DV does not show subscriber status. It will show Spam Complaint, and RMM unsubscribes. SELECT SubscriberID, SubscriberKey, BusinessUnitID, UnsubDateUTC, UnsubReason FROM _BusinessUnitUnsubscribes [help.salesforce.com/… – charliefay Apr 23 '20 at 2:15
  • BUUnsubscribes does show the BU level status. I ran your query and I found one record with an UnsubReason of "test" - that user was "red" in BU level All subs due to a custom unsub link clicked in an email. (For RMM: UnsubReason holds a very specific value: "Unsubscribed by Salesforce Marketing Cloud RMM service based on subscriber Leave/Reply email." Indeed the DV is useful for finding those). I then manually resubscribed the user on the BU level All Subscribers, and the same query returned 0 results. It does return the current status of BU-level All Subscribers. – Jonas Lamberty Apr 23 '20 at 7:06
  • Hi and thank you. I was able to replicate your test and confirm that if a SubKey is in this DV then that subscriber is CURRENTLY opt-out. A reactivated subscriber's 'old' unsubscribe entry is not returned once set back to active. TESTING METHOD: 1) Add new subscriber (active) 2) Run _BusinessUnitUnsubscribes query in queryStudio (where subkey = 'xxx') 3) Result return 0 records 4) Manually unsubscribe new Contact via UI 5) Re run _BusinessUnitUnsubscribes query 6) Result return 1 record 7) Re-activate new subscriber via UI in AllSubs 8) Re run query 9) Result return 0 record – charliefay Apr 23 '20 at 12:10
2

Above behaviour usually happens when you have the setting to unsubscribe subscribers from this business unit only. please refer to this post on this.

Moreover, when a subscriber is unsubscribed from a child BU, their Status isn't reflected into the ENT._Subscribers hence you'd see a discrepancy between your child BU and parent BU.

However, if the subscriber is unsubscribed from the parent level, the subscribers will reflect the status from parent level.

If you require to pull the right status of the subscribers in BU level, I have posted a setup in this post.

More info on unsubscribe settings here.

2
  • this is correct , i was querying ENT._Subscribersand , i think thats why i was getting wrong status for the subscribers. if you want to query unsubscribers data in particular BU use "_BusinessUnitUnsubscribes" this DataView as mentioned by the in the another answer.. thanks. – Shrijeet Khonde Feb 14 '20 at 6:50
  • the explanation for not able to access correct data is Perfect. – Shrijeet Khonde Feb 14 '20 at 6:52

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.