I can find new records that are inserted in the _subscribers table but do not find the same subscribers in the All subscribers when I search for them using email address. How is that scenario possible. Isn't the _subscribers data extension a subset of All subscribers list?

closed as off-topic by DavidSchach, Samuel Dare, Martin Lezer, battery.cord, Mohith Shrivastava Feb 17 '18 at 4:06

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Programming questions not specific to Salesforce are off-topic here, but can be asked on Stack Overflow." – DavidSchach, Samuel Dare, Martin Lezer, battery.cord, Mohith Shrivastava
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Any more details on your account - do you have multiple business units? Is it an ET 1.0 account? – AnonWonderer Feb 15 '18 at 23:32

data views is a system table that stores subscriber information for 180 days. .

The All subscribers list acts as the master publication list for your account, keeping track of all subscribers attributes, with an emphasis on status. The main reason for this is to honour unsusbcribes.

To get a like for like query of all subscribers, you would query _ListSubscribers WHERE ListID='63' (check the all subscribers list properties in your account for the listID)

  • 1
    What leads you to believe that _Subscribers only contains 6 months worth of data, but _ListSubscribers contains more than that? I don't believe there is any monthly limitation on these types of data views, it is only for subscriber events (send, open, click, etc.) that ET stops tracking on a 6 month rolling period. – AnonWonderer Feb 15 '18 at 23:29
  • @AnonWonderer missed this you are right miss type will correct now – Samuel Dare Feb 20 '18 at 19:26

Not the answer you're looking for? Browse other questions tagged or ask your own question.