Power BI Connector for Salesforce Marketing Cloud

Build 25.0.9454

BounceEvent

Provides details about email bounce events in Salesforce Marketing Cloud. Each record includes Simple Mail Transfer Protocol (SMTP) codes and diagnostic information related to delivery failures. This view supports deliverability analysis and campaign performance optimization.

View-Specific Information

Select

The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.

For example, the following (but not only) queries are processed server side:

SELECT * FROM BounceEvent WHERE Id = 123

SELECT * FROM BounceEvent WHERE Id IN (123, 456)

SELECT * FROM BounceEvent WHERE CreatedDate > '2017/01/25'

Columns

Name Type Description
ID [KEY] Int Specifies the system-generated identifier (Id) that uniquely represents the bounce event record within Salesforce Marketing Cloud. This Id is read-only and is used to reference the specific tracking event in reporting and API queries.
ObjectID String Specifies the system-controlled, read-only text string that uniquely identifies the bounce event object across API operations. This value ensures consistency when events are retrieved, correlated, or audited.
PartnerKey String Specifies the unique Id that a partner system supplies for the event record. This value is accessible only through the API and supports cross-system mapping and reconciliation.
CreatedDate Datetime Indicates the date and time when the bounce event record was created. This value supports auditing and the sequencing of tracking events.
ModifiedDate Datetime Indicates the most recent date and time when the bounce event record was updated. This value reflects system adjustments that occur during tracking reconciliation.
Client_ID Int Specifies the Id of the business unit that is associated with the bounce event. This value determines the organizational context in which the send and subsequent bounce occurred.
SendID Int Specifies the Id of the email send operation that is associated with the bounce event. This Id links the bounce to the exact send job that produced the tracking result.
SubscriberKey String Specifies the unique subscriber key that identifies the recipient whose email message resulted in the bounce. This value connects the event to a specific contact in Salesforce Marketing Cloud.
EventDate Datetime Indicates the date and time when the bounce tracking event occurred. This value reflects the moment when the receiving mail server returned the bounce response.
SMTPCode String Specifies the Simple Mail Transfer Protocol (SMTP) response code that is returned by the receiving mail server during the bounce. This code provides technical insight into why delivery failed.
BounceCategory String Describes the high-level category of the bounce (for example, hard bounce or soft bounce). This value helps classify delivery failures for analytics and remediation.
SMTPReason String Provides the descriptive SMTP reason text that the receiving mail server returned with the bounce code. This value offers additional diagnostic information for troubleshooting delivery issues.
BounceType String Indicates a more specific type of bounce, which reflects the detailed nature of the delivery failure. This value assists with tracking, reporting, and automated response handling.
EventType String Specifies the tracking event type. For bounce events, this value identifies the record as part of bounce-related tracking activity.
TriggeredSendDefinitionObjectID String Specifies the object Id of the triggered send definition that is associated with the bounce event. This value links the event to a specific triggered send configuration.
BatchID Int Specifies the batch Id that groups triggered send events together. This value enables systems to correlate the bounce event with the batch of messages delivered during the same triggered send execution.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454