1

We are integrating marketing cloud data into our BI system and would need to know the table where all the individual email results are stored on the salesforce marketing cloud platform. This is the list data tables marketing cloud has: https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/account.htm

Has anybody been able to find the table that contains all the indivual email results? This table should contain indivual email sends for each recipient (email address).

1

What you need is not the above Account object, but look at Data Views. Especially:

  • Send
  • Open
  • Click

These Data Views can be extracted and provided to the BI systems, using Automation Studio and Data Extract Activity.

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.