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 Mailchimp Views
| Name | Description |
| AccountExports | Generates or retrieves completed account exports containing data snapshots or backups of Mailchimp account information. |
| AuthorizedApps | Lists all third-party applications authorized to access the Mailchimp account through OAuth integration. |
| AutomationEmailQueues | A summary of the queue for an email in an automation workflow. |
| AutomationEmails | A summary of the emails in an automation workflow. |
| Automations | A summary of the automations within an account. |
| AutomationsRemovedSubscribers | A summary of the subscribers removed from an automation workflow. |
| BatchOperations | Summarizes batch requests submitted to the Mailchimp API, including processing status and results. |
| BatchWebhooks | Provides information about batch webhooks, which notify external systems of completed batch operations. |
| CampaignContents | Retrieves the HTML and plain-text content associated with a specific campaign. |
| CampaignOpenEmailDetails | Displays information about subscribers who opened a campaign email, including timestamps and interaction details. |
| CampaignSendCheckList | Returns the pre-send checklist for a campaign, highlighting configuration issues that need resolution before sending. |
| CampaignVariateContents | Retrieves the HTML and plain-text variations for A/B testing campaigns, enabling comparison of different content versions. |
| ChimpChatterActivity | Returns recent Chimp Chatter activity for the account, including Mailchimp system updates and campaign notifications. |
| ConnectedSites | Lists websites connected to the Mailchimp account for tracking and automation purposes. |
| ConversationMessages | Messages from a specific conversation. Conversation tracking is a feature available to paid accounts that lets you view replies to your campaigns from inside your MailChimp account. |
| Conversations | A collection of this account's tracked conversations. Conversation tracking is a feature available to paid accounts that lets you view replies to your campaigns from inside your MailChimp account. |
| EcommerceProductImages | Provides image details for products in connected e-commerce stores, including URLs and dimensions. |
| EcommercePromoCodes | Retrieves the list of promo codes under a promo rule |
| EcommercePromoRules | Returns details about promotional rules configured for a store, including eligibility and discount types. |
| EcommerceStores | A list of an account's ecommerce stores. |
| FacebookAds | Lists Facebook ads configured and managed through Mailchimp's integrated advertising feature. |
| FileManagerFolderFiles | Lists files organized within specific folders in the Mailchimp File Manager. |
| LandingPageContents | Retrieves the content and layout details of a specific landing page. |
| LandingPages | Lists landing pages created in the account, including URLs, design information, and publishing status. |
| ListAbuse | Contains abuse complaints for a specific audience list, typically submitted when a recipient marks an email as spam. |
| ListActivity | Displays up to 180 days of daily aggregated activity statistics for a given audience list, excluding automation events. |
| ListClients | Summarizes the most common email clients used by subscribers, based on user-agent data. |
| ListGrowthHistory | Shows month-by-month subscription growth trends for a specific audience list. |
| ListMemberActivity | The last 50 member events for a list. |
| ListMemberActivityFeeds | Shows a member's engagement activity on a specific list, including email opens, link clicks, and unsubscribes. |
| ListMemberGoals | Displays goal-tracking events for list members, such as website visits or conversions recorded by Mailchimp. |
| ListMemberTags | Tags assigned to a certain member/members. |
| ListSignupForms | Collection of List Signup Forms |
| ListsTagsSearch | Enables searching for specific tags applied to members within an audience list. |
| ListSurveys | Returns all survey configurations associated with a specific audience list. |
| ReportAbuse | Displays records of abuse complaints for a specific list or campaign. |
| ReportAdvice | Provides campaign performance feedback and optimization tips based on engagement metrics. |
| ReportClickDetails | A list of URLs and unique IDs included in HTML and plain-text versions of a campaign. |
| ReportClickDetailsMembers | Displays the subscribers who clicked on specific links within a campaign. |
| ReportDomainPerformance | Statistics for the top-performing email domains in a campaign. |
| ReportEepUrls | Provides detailed activity reports for EepURLs (Mailchimp's link-tracking redirects). |
| ReportEmailActivity | A list of member's subscriber activity in a specific campaign. |
| ReportingFacebookAds | Lists performance reports for Facebook ad campaigns managed through Mailchimp. |
| ReportingLandingPages | Provides engagement and conversion metrics for landing pages published through Mailchimp. |
| ReportingSurveyQuestionAnswers | Lists responses to individual survey questions for analysis. |
| ReportingSurveyQuestions | Returns summary data and response statistics for survey questions. |
| ReportLocations | Displays the top geographic locations where campaign emails were opened. |
| ReportProductActivity | Provides campaign performance data linked to e-commerce product interactions. |
| Reports | A list of reports containing campaigns marked as Sent. |
| ReportSentTo | A list of subscribers who were sent a specific campaign. |
| ReportSubReports | Lists subreports generated for child or related campaigns. |
| ReportUnsubscribes | Lists members who unsubscribed from a specific campaign, including timestamps and reasons. |
| SurveyResponses | Displays individual responses submitted for surveys distributed through Mailchimp. |
| Surveys | Lists surveys available in the account, including titles, questions, and response counts. |
| TransactionalScheduledEmails | Displays scheduled transactional emails awaiting delivery. |
| TransactionalSenders | Lists authorized senders configured in the Mailchimp Transactional account. |
| TransactionalUserInfos | Provides account-level information about Mailchimp Transactional users, including usage and limits. |
| VerifiedDomains | Lists sending domains verified for use with Mailchimp campaigns and transactional emails. |