Does anyone know how can I access / export the data that is in the Tracking section in Email Studio?
I'm not interested in sending myself an Email Report. I'd like to get that data into a Data Extension, then would to query that data with given criteria (in a Cloud Page, with AMPscript or SSJS).
So far, I've checked all of the Data View tables, _Sent, _Job etc. I thought that the field SalesForceTotalSubscriberCount in _Job was the one I'm looking for, however, the query returned 0 for the email campaigns we've sent out.
I thought about writing a SQL query, something like
Count(SubscriberKey) as num, JobID From _Sent
But I'm not very proficient in SOQL. And I'm assuming that this data is stored somewhere since it's visible in the Tracking section.
edit: In the end, I'd like to have the Date/Time Sent, Emails Sent, Clickthrough Rate, Open Rate and Deliverability Rate of all the email campaign that have been sent out in the past 6 months stored in a Data Extension.
second edit: I've also tried creating a Data Extension as it was described here https://help.salesforce.com/articleView?id=mc_es_create_email_sendlogging_de.htm&type=5, however I'm not sure if that is what I need, and the Data Extension creation keeps failing with this error:
Error: Error updating filter
Any help is appreciated.