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 |
| AssetTypes | Returns the available asset types configured in Salesforce Marketing Cloud. Each asset type defines the structure, behavior, and rendering rules for specific types of content elements, such as templates, blocks, or layouts. This view is useful for identifying supported asset formats when creating or managing digital content. |
| Contact | Retrieves detailed information for a specific contact in Salesforce Marketing Cloud. A contact represents an individual subscriber or customer who interacts with your marketing campaigns. This view provides insights into contact attributes, engagement status, and associated data extensions. |
| Contacts | Retrieves a comprehensive list of all contacts in Salesforce Marketing Cloud. Each contact represents a unique individual with associated communication preferences and subscription data. This view is used to review or export contact records for segmentation, personalization, or compliance reporting. |
| JourneyAuditLogs | Returns audit logs for journeys and their versions in Salesforce Marketing Cloud. Each record captures configuration changes, version updates, or execution details that provide transparency and traceability for journey management. This view supports compliance and debugging by tracking historical activity. |
| JourneyHistory | Retrieves the historical execution records of customer journeys in Salesforce Marketing Cloud. Each record reflects the runtime status, performance, and event details of a specific journey instance. Record retrieval is subject to a maximum file size of 1 GB to ensure performance and stability during data access. |
| MobileApplications | Returns the list of mobile applications (apps) configured in a Salesforce Marketing Cloud account. Each mobile app record identifies applications that are used for push notifications or in-app messages. This view helps administrators manage mobile channels and confirm that app credentials and configurations are current. |
| SmsStatusCodes | Returns Short Message Service (SMS) status codes recognized by Salesforce Marketing Cloud. Each status code represents a specific state of message delivery, such as pending, delivered, or failed. This view is useful for monitoring message outcomes and troubleshooting SMS communication issues. |
| TransactionalMessages | Retrieves a paginated list of transactional messages that are not successfully sent in Salesforce Marketing Cloud. Results are ordered from the oldest to the newest message. This view provides visibility into message delivery issues and supports troubleshooting for transactional send processes. |