So, I am trying to extract SENT email information from marketing cloud.
I have researched everywhere but can't find a way.
I know I can use Data Views and with the help of sql query I can get the information but data views only offers 6month worth data. I want ALL data from start date of marketing cloud till date of all emails sent from our account.
I want following information:
All emails – Date sent / Name of Email / Subject Line / View in browser url of that email so email is view-able
Can anyone guide me in a right direction?
Best Answer
You will need to use Tracking Extracts. It will need to be done in chunks of 30-90 day increments though. (30 days in Automation studio for custom range, 90 days in Email Studio - if you still have it listed inside of interactions)
As with all extracts, these will be extracted to the safehouse, and you will need to do a file transfer to get it to your FTP.
These files will be fairly large - so be prepared for some slow upload/download speeds. Tracking Extracts include pretty much all the information that SFMC collects and is accessible by the end user.
See here for a link to all the info you can get from tracking extracts
See the sub-categories on the left nav to get more details.
For the VAWP link, you might want to check out 'SendJobs' and the 'PreviewURL' field.
My recommendation is to create an automation and just keep editing the timeframe and name of the file and then rerun the automation.