Tables
The connector models the data in Salesforce Marketing Cloud Account Engagement 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 Account Engagement Tables
Name | Description |
Campaigns | Retrieve and modify campaigns. |
CustomFields | Retrieve custom fields metadata. |
CustomRedirects | Track links on your website or third-party site with Pardot custom redirects. |
DynamicContent | Retrieve a collection of dynamic content |
Emails | Query emails to learn how prospects responded to the emails. |
EmailTemplates | Query email templates. |
Files | Upload images and other files to use in your Pardot emails, forms, and landing pages. |
FolderContents | View all objects contained within Folders. |
Folders | Retrieve folders or organize and nest your content and marketing assets in a way that makes sense for your team. |
FormHandlers | Retrieve,Create,Updata,Delete a collection of Form Handlers |
FormHandlersFields | Retrieve,Create,Update,Delete a collection of Form Handler Stages |
Forms | Retrieve forms. |
LandingPages | Retrieving a collection of landing pages |
LayoutTemplates | Retrieve and modify layout templates. |
LifecycleStages | Retrieving a collection of lifecycle stages |
ListEmail | A list email is a single email sent to a recipient list. |
ListMemberships | Retrieve,Create,Update,Delete a collection of list memberships |
Lists | Retrieve and modify lists. |
Prospects | Retrieve and modify prospects. |
TrackerDomains | Query the available tracker domains. |
Users | Query the available users. |
VisitorsPageViews | Retrieve visitors page views. |
Visits | Retrieve visits. |