0

We're using an enterprise 2.0 account, and are querying from the parent BU.

What we're confused about is which data view should we query to receive an accurate report on ALL the 'Subscribers' in our account?

We're finding differences when we query _Subscribers and _ListSubscribers (where the ListID = 1670 [ID of AllSubscribers])

what further confuses us is that we've found a bunch of subscribers who don't show up when we do a search for them on AllSubscribers - which contradicts the logic that AllSubscribers is the master table of the account.

Any help would be appreciated, thank you!

  • one small note - "AllSubscribers is the master table of the account" - that is not the case. You can be a Contact without being a Subscriber (on All Subscribers). Someone went through the details here: deselect.io/… – Jonas Lamberty Jul 24 at 7:29
  • Thank you @JonasLamberty! – Kenneth Lobo Jul 29 at 5:09
2

_ListSubscribers and _Subscribers are very similar when querying the Admin Business Unit/"ENT" Schema. You'll potentially find subscribers of type other than 0 ("ExactTarget") in your _Subscribers view, however, that don't appear in All Subscribers/List Subscribers. This will be particularly true if you're using one of the connectors for Salesforce CRM or Microsoft Dynamics or you're making use of triggered sends where you choose not to update All Subscribers in the Triggered Send Definition. In these instances, SFMC maintains "hidden" lists of Subscribers that you can't view in All Subscribers and aren't included in the _ListSubscribers records for the All Subscribers list.

| improve this answer | |
  • Thank you Macca! Super useful. We use marketing cloud connect, so what you're saying about the 'other' subscribers makes sense. We've got 2 further questions here @Macca : 1) If you were undertaking a contact deletion process to clean up, where would you delete from:? ) And we've got a strange case where we found a bunch of subscribers on the _Subscribers table, but didn't show up when we searched using the 'All subscriber' search UI. Would that be because of what you've mentioned? Or could there be other reasons? Thanks for your help! – Kenneth Lobo Jul 29 at 5:07

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.