I am trying to populate a DataExtension which will contain a list of all email sends along with their send count, list name, email name and subject.
This is what I currently have and it does successfully validate:
SELECT TOP 50 _Job.JobID, _Job.DeliveredTime, _Job.EmailName, _Job.EmailSubject, _Sent.ListID, _ListSubscribers.ListName, _Job.SalesForceTotalSubscriberCount AS SendCount FROM _Job INNER JOIN _Sent ON (_Sent.JobID = _Job.JobID) INNER JOIN _ListSubscribers ON (_Sent.ListID = _ListSubscribers.ListID)
I run this query activity but it fails to populate the DataExtension. Has anyone tried to get this kind of Data out of ExactTarget?