In SFMC Email Studio I have Master Data Extension used to construct many other data extensions. When I open details for my Master DE and select Tracking tab I see the pie chart with four categories: Active, Bounced, Undeliverable, and Unsubscribed. For each category, there is percent share and number of records. Unfortunately, I don't see a way to view/export list of members of each of these categories? I need to find out which records as bounced and undeliverable according to SFMC. It would be great if I could request this information via API.
You can execute a query like below to retrieve the records and write them to a target DE:
SELECT SubscriberKey FROM ENT._Subscribers WHERE Status = 'Bounced'
Please change the value of "Bounced" with the values here based on your request: