0

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?

3

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.

  • So, I looked in the tracking extracts and it looks like tracking exacts is basically data stored in Data View which I have already mentioned in my original post that it won't help in my case because it only hold data for last 6 months. In addition to that, I am also looking for "View in browser" URL for each mailing so it is viewable. Any other solution? – kuml Dec 11 '17 at 2:16
  • Tracking extracts go back as far as you want - you just need to keep putting in custom dates. I believe the VAWP url is in there, but many of the older sends this url may not be active anymore – Gortonington Dec 11 '17 at 3:05
  • Hi @Gortonington - I was able to extract the data including URL but to view that URL, it asks for marketing cloud login. Any way I can extract the URL that does not require login to view it? – kuml Dec 11 '17 at 13:37
  • You could look at doing an API call to get the HTML - SOAP for classic (developer.salesforce.com/docs/…) and REST for content builder (developer.salesforce.com/docs/…). If you need a sample of each individual email, you would likely want to add in the VAWP link into a send log or similar for easy reference later. – Gortonington Dec 11 '17 at 13:42
  • 1
    ok - no problem. I appreciate you help me out and answering all my questions. (marked answer + 1 ) – kuml Dec 12 '17 at 17:04
0

Check out this absolutely awesome article on how to do this Export tracking data from Salesforce Marketing Cloud

In the article you will find lots of screenshots and an in depth explanation on how to do this.

  • Please see How to Answer. Link only answers are generally not accepted here as they are too reliant on the link working. It is better to summarize the link information here as well as providing the link. – Dave Humm Oct 22 '18 at 11:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.