[SalesForce] Query All Subscribers

Does anybody know how can I query All Subscribers ?

As we know _Subscribers data view keeps only records for 6 months, which means it is not a solution.

Currently I am trying to export All Subscribers and then import them into a Data Extension, but it would be nice if anybody knows different approach ?

Thanks in advanced.

Best Answer

Only data views that hold specific events have a 6 month retention period, ie. Send, Open, Click, Unsubscribe, etc.

The _Subscribers data view is holding a reference of any subscriber in your account. There shouldn't be a 6 month retention period on this - feel free to run that query to test it out.

Related Topic