[SalesForce] Query All Subscribers Unsub Status within Child BU

An account I'm working in is set-up to do sending to data extensions and is also configured to capture unsubscribes at a business unit level. Have a request to provide a more accurate picture of the "sendable" audience (i.e., excluding unsubscribed or held records). Running a query activity against the _subscribers data view to retrieve Status only seems to produce results when done at the enterprise level, which does not reflect those unsubscribes being held at the child bu level. Am I doing something wrong or is this the expected behavior? Other than doing a manual search by status and then exporting out results from the bu level all subscribers and reimporting into a DE to query against does anyone have a workaround?

Thanks,
Mark

Best Answer

The _subscribers view is viewing the All Subscribers list, and there is only one AllSubs list across all BU's, so this is expected behavior. A potential workaround might be to use a shared DE's somehow, which you could use to aggregate data.

Hope this helps.

Related Solutions

[SalesForce] Subscriber object Status ‘Active’ and Unsubscribed from All Subscribers

So it turns out there was a stupid error in my code. I was not retrieving the Status field in the request. I guess if you don't specify the specific field it must return a default value???

%%[
SET @rr = CreateObject("RetrieveRequest")  
SetObjectProperty(@rr, "ObjectType", "Subscriber")  
AddObjectArrayItem(@rr,"Properties","EmailAddress")  
AddObjectArrayItem(@rr,"Properties","SubscriberKey")  

/* Added this line below */
AddObjectArrayItem(@rr,"Properties","Status")
/* Added this line above */

SET @sfp = CreateObject("SimpleFilterPart")  
SetObjectProperty(@sfp, "Property", "SubscriberKey")  
SetObjectProperty(@sfp, "SimpleOperator", "equals")  
AddObjectArrayItem(@sfp, "Value", @email)    
SetObjectProperty(@rr, "Filter", @sfp)  
SET @sub = InvokeRetrieve(@rr)

SET @row = Row(@sub,1)   
SET @name = Field(@row ,"EmailAddress") 
SET @status = Field(@row, "Status")
]%%

%%=V(@name)=%%<br/>
%%=V(@status)=%%<br/>

[SalesForce] Trying to query All Subscribers list

If you're querying from a child account, you'll need to prefix the view name with ent.

SELECT top 100 
EmailAddress
, SubscriberID 
FROM ent._ListSubscribers 
WHERE ListID = 258

Reference: Query Activity

Best Answer

Related Solutions

[SalesForce] Subscriber object Status ‘Active’ and Unsubscribed from All Subscribers

[SalesForce] Trying to query All Subscribers list

Related Topic