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
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)