I need to create a daily automation to query contacts who's status in All subscribers changed to Unsubscribed last 24 hours. I am totally new to query, but I tried this..
SELECT EmailAddress, SubscriberKey, Status, EventDate as 'UnsubscribeDate', FROM _ListSubscribers WHERE ListID = 305 AND Status = 'Unsubscribed' AND EventDate > dateadd(hh,-24,getdate())
I received 'Errors: Incorrect syntax near the keyword 'FROM'.' message. Could someone please guide me through what is wrong? Thank you!