Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Power BI Connector for Salesforce Marketing Cloud Views
| Name | Description |
| Automation | Defines automations created within Automation Studio in Salesforce Marketing Cloud. Each automation specifies a sequence of scheduled or triggered activities such as imports, sends, or data updates. This view provides visibility into configured automation workflows. |
| 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. |
| ClickEvent | Contains tracking data for link click events in Salesforce Marketing Cloud. Each record includes the timestamp, URL identifier (Id), and destination URL for a link that a subscriber clicked in a sent message. This view is essential for analyzing engagement metrics and user interaction behavior. |
| DataExtensionField | Represents individual fields within a data extension in Salesforce Marketing Cloud. Each field defines the data type, length, and attributes of a column in a data extension. This view provides metadata that supports schema validation and data integrity checks. |
| DataExtensionTemplate | Represents data extension templates in Salesforce Marketing Cloud. A template defines the structural blueprint that can be reused to create multiple data extensions with consistent schema design. This view allows administrators to standardize data collection and storage across campaigns. |
| DataFolder | Represents folders within a Salesforce Marketing Cloud account. Each folder organizes related content, data extensions, or automations into a hierarchical structure for easier management and access control. This view supports navigation and organizational reporting across stored assets. |
| DoubleOptInMOKeyword | Defines mobile-originated (MO) keywords used for double opt-in workflows in Salesforce Marketing Cloud. Each record specifies the keyword that allows mobile users to confirm subscriptions through a two-step consent process. This view ensures compliance with opt-in regulations and supports secure subscriber management. |
| FileTriggerTypeLastPull | Provides information about the most recent retrieval of file-trigger activity for each trigger type. This view helps track when a file-based trigger was last evaluated |
| ForwardedEmailEvent | Records events in which a subscriber used the Forward to a Friend feature to share an email with another recipient in Salesforce Marketing Cloud. Each record includes details such as the sender, recipient, and timestamp of the forwarding action. This view supports tracking viral sharing and referral engagement. |
| ForwardedEmailOptInEvent | Specifies opt-in events that occur when a recipient subscribes as a result of receiving a Forward to a Friend email in Salesforce Marketing Cloud. This view helps identify new subscribers who joined through referral-based interactions. |
| HelpMOKeyword | Defines the actions associated with the HELP Short Message Service (SMS) keyword for a Salesforce Marketing Cloud account. The HELP keyword allows subscribers to request information about the sender or message program. This view supports compliance with mobile communication standards. |
| ImportResultsSummary | Provides summary results for import jobs that were initiated from an import definition in Salesforce Marketing Cloud. Each record includes the total rows processed, successful imports, and errors encountered. This retrieve-only view supports reporting and monitoring of data import performance. |
| LinkSend | Provides link-level details for email sends in Salesforce Marketing Cloud. Each record identifies a specific link, its tracking identifier (Id), and its relationship to a send event. This view supports engagement analysis by correlating links to subscriber click behavior. |
| ListSend | Provides retrieve-only properties that describe the lists associated with completed send operations in Salesforce Marketing Cloud. Each record links a send event to one or more lists to support campaign tracking and performance analysis. |
| ListSubscriber | Retrieves subscriber relationships for lists in Salesforce Marketing Cloud. Each record shows which lists a subscriber belongs to or which subscribers are assigned to a list. This view supports subscription management and audience segmentation reporting. |
| MessagingVendorKind | [DEPRECATED] Contains vendor details for Short Message Service (SMS) or voice messaging providers that are integrated with Salesforce Marketing Cloud. Each record identifies a messaging vendor and its communication channel type. |
| NotSentEvent | Contains information about email messages that failed to send in Salesforce Marketing Cloud. Each record includes diagnostic codes and timestamps to support root-cause analysis of delivery failures. |
| OpenEvent | Records open events for email sends in Salesforce Marketing Cloud. Each record includes the timestamp, subscriber key, and send context for an opened message. This view provides key engagement metrics for campaign performance analysis. |
| PrivateIP | Contains details about private IP addresses that are assigned for message sends in Salesforce Marketing Cloud. Each record identifies the dedicated IP address used for outbound email delivery, supporting IP reputation management and sender authentication practices. |
| Publication | Represents publication-level configuration details that support managing how subscriber-facing content is organized and distributed in Salesforce Marketing Cloud. This view provides structural information that describes publication settings, visibility rules, and relationships used in content distribution workflows. |
| PublicationSubscriber | Describes subscribers who are associated with a publication list in Salesforce Marketing Cloud. Each record defines a subscriber's status, preferences, and linkage to a specific publication for audience management and compliance tracking. |
| PublicKeyManagement | Provides information about public encryption keys that are stored in Salesforce Marketing Cloud for use in secure data exchange and authentication workflows. This view helps identify which keys are available for validating signatures, encrypting payloads, or establishing trusted integrations with external systems. |
| ResultItem | Contains the individual result records returned from an asynchronous API call in Salesforce Marketing Cloud. Each record represents the outcome of a processed item, such as a contact import or message send. |
| ResultMessage | Contains summary messages generated from asynchronous API calls in Salesforce Marketing Cloud. Each message provides status information, execution results, or error diagnostics to assist in monitoring API-based processes. |
| Role | Defines user roles and permissions that are assigned within a Salesforce Marketing Cloud account. Each record specifies access levels, feature entitlements, and user group associations. This view supports auditing of security and access configurations. |
| SendEmailMOKeyword | Defines the action that sends a triggered email message in response to a mobile-originated (MO) message in Salesforce Marketing Cloud. This view maps keywords in Short Message Service (SMS) messages to corresponding triggered email sends for integrated cross-channel automation. |
| SendSMSMOKeyword | Defines the actions taken when Salesforce Marketing Cloud receives a specific mobile-originated (MO) keyword. Each record links a keyword to an automation or message send workflow to support two-way Short Message Serviec (SMS) communication. |
| SendSummary | Provides summary information for a completed send event in Salesforce Marketing Cloud. Each record includes key metrics such as total sent, delivered, opened, and bounced messages. This retrieve-only view supports campaign reporting and performance analysis. |
| SentEvent | Contains tracking data for email send events in Salesforce Marketing Cloud. Each record captures subscriber-level delivery results, including send time, recipient address, and message identifier (Id). This view supports detailed tracking and reporting of message performance. |
| SMSMTEvent | Contains information about outbound (mobile-terminated) Short Message Service (SMS) messages that were are to subscribers in Salesforce Marketing Cloud. Each record includes message identifiers (Ids), timestamps, and delivery results for mobile messaging analysis. |
| SMSSharedKeyword | Contains information used to request or manage shared Short Message Service (SMS) keywords in Salesforce Marketing Cloud. Shared keywords allow multiple accounts or business units to use the same keyword within defined boundaries. This view supports keyword governance and provisioning. |
| SMSTriggeredSendDefinition | Defines Short Message Service (SMS) triggered send definitions in Salesforce Marketing Cloud. Each definition includes message templates, target audiences, and sending parameters. This view supports auditing and configuration validation for automated SMS workflows. |
| SubscriberList | Retrieves the lists that are associated with a specific subscriber in Salesforce Marketing Cloud. Each record links a subscriber to one or more lists to support segmentation, subscription tracking, and campaign targeting. |
| SubscriberSendResult | Provides information about message send outcomes at the individual subscriber level. This view helps identify whether a message was delivered, bounced, deferred, or otherwise processed for each subscriber, enabling detailed send-level analysis and troubleshooting. |
| SubscriberStatusEvent | Retrieves information about subscribers, the current subscribers' status and the reasons why the subscribers unsubscribed, if any. |
| SuppressionListContext | Defines the context within which a suppression list can be associated in Salesforce Marketing Cloud. Each context determines the scope of a suppression list, such as a specific business unit, publication, or message type. |
| SurveyEvent | Contains information about survey responses recorded in Salesforce Marketing Cloud. Each record captures the timestamp and context of the response, supporting analysis of audience feedback and engagement. |
| Template | Represents email templates in Salesforce Marketing Cloud. Each record defines the layout, content placeholders, and associated sender settings that are used to build emails. This view helps ensure standardized formatting and brand alignment across campaigns. |
| TimeZone | Lists supported time zones in Salesforce Marketing Cloud. Each record includes the time zone identifier (Id), offset, and regional description. This view supports configuration of time-based automations and send scheduling. |
| TriggeredSendSummary | Provides summary metrics for specific triggered send operations in Salesforce Marketing Cloud. Each record includes counts for messages sent, delivered, and failed, supporting operational and performance analysis. |
| UnsubEvent | Contains data about unsubscription events in Salesforce Marketing Cloud. Each record captures the subscriber, timestamp, and context of the unsubscribe action. This view supports compliance reporting and audience retention analysis. |
| UnsubscribeFromSMSPublicationMOKeyword | Defines the keyword that subscribers can use to unsubscribe from a Short Message Service (SMS) publication list in Salesforce Marketing Cloud. This configuration supports opt-out workflows and compliance with mobile communication regulations. |