Queries for the ACSEmailStatusUpdateOperational table

Email failed deliveries by recipient ID

List recipients and failed delivery status.

ACSEmailStatusUpdateOperational
| where isnotempty(RecipientId)
| where DeliveryStatus != "Delivered"
| limit 100

Email Failed Deliveries by Message Id

List message ids and failed status.

ACSEmailStatusUpdateOperational
| where isempty(RecipientId) 
| where DeliveryStatus != "OutForDelivery"
| limit 100

Email Bounced and Suppressed Recipients

List recipients that have been dropped due to a hard bounce or suppressed due to customer managed opt-outs.

ACSEmailStatusUpdateOperational
| where DeliveryStatus == "Bounced" or DeliveryStatus == "Suppressed"
| where CorrelationId == "<email-send-request-message-id>"
| limit 100