Skip to main content
1 of 3

Simple Queries - Sent

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when i run the query, nothing populates in the DE and nothing populates in the Action Log. I feel like I'm SO close but as I've been building out my automation I keep running into Super niche errors. Do I need a primary key? Any help would be welcome!!!

Here's my query: SELECT AccountID, OYBAccountID, JobID, ListID, BatchID, SubscriberID, SubscriberKey, EventDate, Domain, TriggererSendDefinitionObjectID, TriggeredSendCustomerKey

FROM _Sent

WHERE Eventdate > Dateadd(day, -30, Getdate())

Here are my DE values: Data Extension Screenshot