I'm using marketing cloud to send emails. I'm able to fetch user level email open & click report from marketing cloud using data views (_open & _clicks). Is there any data extension or alternate way exists using which I can fetch the list of contacts or subscribers against which email was delivered?

  • You will need to join _sent and _bounce. If the record (Subkey + jobId) is not in the bounce data view, it's mean the email is well delivered to this contact (mailbox or junk) Commented Mar 17, 2021 at 10:48

1 Answer 1


The _Sent dataview

Query this data view in Automation Studio to find the subscribers sent emails from your Marketing Cloud account.

View subscribers who were sent emails from your account by querying the _Sent data view.

Dates and times are stored in Central Standard Time. Daylight Savings Time is not observed. To view time-related data in your time zone, set time zone user preferences.

  • As per my understanding, _Sent data view only provides information of emails sent and not delivered. I checked this data view but no field provides information related to the delivery of email. Let me know if it's otherwise.
    – ASHISH
    Commented May 20, 2019 at 15:38
  • 2
    _Sent dataview is record of all sends that occurred, if they don't show in _bounce it is expected that the email was delivered
    – EazyE
    Commented May 20, 2019 at 15:45
  • Keep in mind that a "delivered" mail in Marketing Cloud does not mean the email reached the inbox. An email that goes to the spam folder is considered as delivered in Marketing Cloud. To get more information about delivrability, you need to use other tools like ReturnPath,.. Commented May 23, 2019 at 11:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .