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:
My Code:
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?