Tables

The connector models the data in Salesforce Marketing Cloud as a list of tables in a relational database that can be queried using standard SQL statements.

CData Power BI Connector for Salesforce Marketing Cloud Tables


Name	Description
Assets	Provides access to digital assets within Salesforce Marketing Cloud. Assets include reusable content elements such as images, templates, or code snippets that are stored and managed in Content Builder. This table allows you to create, update, delete, and query these assets to support consistent brand messaging across campaigns and channels.
Callbacks	Manages event notification callbacks that are configured in Salesforce Marketing Cloud. A callback defines an endpoint that receives real-time notifications when specified system events occur, such as message delivery or data import completion. This table allows you to create, update, delete, and query callback definitions to automate event-driven workflows.
CampaignAssets	Maintains relationships between campaigns and their associated assets in Salesforce Marketing Cloud. Each record links campaign initiatives with digital assets such as email templates, images, or social media content. This table supports create, update, delete, and query operations for managing campaign resources effectively.
Campaigns	Represents campaigns in Salesforce Marketing Cloud. Each campaign groups related marketing efforts and performance metrics under a single initiative. This table allows you to create, update, delete, and query campaigns to manage lifecycle stages, track engagement, and associate related assets or audiences.
Categories	Stores category information (also known as folders) within Content Builder in Salesforce Marketing Cloud. Categories organize assets and content for easier navigation and management. This table allows you to create, update, delete, and query folder structures that help maintain a logical and accessible content hierarchy.
EventDefinitions	Manages event definitions within Salesforce Marketing Cloud. An event definition specifies a trigger, such as a form submission or API call, that initiates an automated process like a journey entry or data update. This table allows you to create, delete, and query event definitions to orchestrate customer experiences.
FacebookMessengerProperties	Defines properties for Facebook Messenger integrations in Salesforce Marketing Cloud. These properties control how messages are formatted, delivered, and tracked within Facebook channels. This table allows you to query existing properties or create new configurations to manage social messaging campaigns.
JourneyActivities	Contains details about journey activities in Salesforce Marketing Cloud. A journey activity represents an action or decision point in a customer journey, such as sending an email or evaluating a contact attribute. This table allows you to create, update, and query journey activities to refine automation workflows.
Journeys	Represents customer journeys in Salesforce Marketing Cloud. A journey defines an automated, multi-step process that guides contacts through personalized interactions across channels. This table allows you to create, update, delete, and query journey definitions to manage audience engagement strategies.
LineMessengerProperties	The table that defines configuration properties for LINE messenger integrations in Salesforce Marketing Cloud. These properties determine how messages are delivered and tracked within LINE communication channels. This table allows you to query and create properties to support messaging automation for the LINE platform.
SendDefinitions	Stores send definitions in Salesforce Marketing Cloud. A send definition specifies the parameters for email, Short Message Service (SMS), or push sends, including target audiences, content, and delivery options. This table allows you to create, update, delete, and query send definitions to manage outbound communication workflows.
Subscriptions	Manages event notification subscriptions within Salesforce Marketing Cloud. A subscription defines which events are monitored and where notifications are sent. This table allows you to create, update, delete, and query event subscriptions to support custom automation and data integration processes.