I would like to extract the reason (unsubscribed Reason) attribute as part of my SQL query to one of the data views (_Subscribers), but it shows as invalid column which is right but i need this badly ;),
Does anyone have an idea if we can extract reason value from any of the data views? my aim is to extract delta customers /subscribers who have opted out using list-subscribe feature (Reason=Unsubscribed by Salesforce Marketing Cloud RMM)
SELECT Subscriberkey as Subskey, EmailAddress, DateUnsubscribed, SubscriberID, **Reason** from ent._Subscribers where SubscriberKey ='0031X…’'
Would be huge help!!