Subscribers Data View:
Quote "This data view only returns results at the Enterprise level, and not for business units." Unquote
This is what the article states:
https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_subscribers.htm&type=5
But, I find the difference between ent._Subscribers and _Subscribers, the difference is SubscriberType. Bottom line - Always use "ent" prefix when querying this dataview.
Here is the query :
1. select count(subscriberkey),SubscriberType from ent._Subscribers group by SubscriberType ==> ExactTarget2. select count(subscriberkey),SubscriberType from _Subscribers group by SubscriberType ==> Unknown External System,, SF object or CRM.
Question :
Why they are allowing us to query _Subscribers and giving us different results in different child BUs, whereas when we query ent._Subscribers, it always gives us consistent result.
Answer :
The difference in result is because of the subscriber type. When you add subscribers to All subscribers by default, it will be "Exact Target".
Whereas for any Trigger Sends that do not use a List will use the Trigger Send Managed List. Subscribers Data View also states , the subscriber type 3. Unknow External System (Triggered Send Hidden Manage List). Here is the article : https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_subscribers.htm&type=5
This article states : https://help.salesforce.com/s/articleView?id=000352724&type=1
Salesforce V2/V3, which preceded Marketing Cloud Connect , used hidden lists to store Salesforce Subscribers.
Marketing Cloud Connector for Microsoft Dynamics CRM also uses a Hidden Managed List.
What does this article means ?
If you imported Salesforce data into marketing cloud, it used hidden list and those records were not added to contacts till you performed the send. But, with MC Connect, Synchronized data sources from Contact, Lead, and User Records are shown in Contact Builder All Contacts.
So Why are they adding Contact, Lead and User to All contacts?
These records are added to contacts for billing purposes.
Comments
Post a Comment