0

How can I export the errored Email Addresses of a Triggered Send?

enter image description here

Improve this question

1 Answer 1

Reset to default
0

To my knowledge there is no direct way to access these via the UI.

You would either need to use filters or queries on your sendlog data extension (if you activated it) or query the _Sent Dataview and compare this against your API log of submitted values.

The below is assuming you created a DE that contains all the submitted API calls to the specific trigger named API_Trigger_Log

The query would likely look something like this:

SELECT EmailAddress
FROM API_Trigger_Log
WHERE EmailAddress NOT EXISTS (
  SELECT SubscriberKey as EmailAddress
  FROM _Sent
  WHERE TriggeredSendCustomerKey = {{YourTriggeredSendExternalKey}}
)
Improve this answer
2
  • 1
    Thanks. The Triggered Send is part of a Journey so I think the use of Send Log is the way to go here. I have enabled it yesterday and will keep an eye on it now. But it's confusing that I have the possibility to view the queued addresses but not the errored. That does'nt make sense to me.
    – Oliver
    Commented Dec 1, 2017 at 9:34
  • 1
    Agreed. But there are a lot of things that don't make sense in SFMC unfortunately.
    – Gortonington
    Commented Dec 1, 2017 at 13:20

You must log in to answer this question.

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