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 ODBC Driver for Mailchimp Views
| Name | Description |
| AccountExports | Generate a new account export or download a finished account export. |
| AuthorizedApps | A list of applications authorized to access the account. |
| 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 | Get a summary of batch requests that have been made. |
| BatchWebhooks | Get information about batch webhooks. |
| CampaignContents | Get the the HTML and plain-text content for a campaign. |
| CampaignOpenEmailDetails | A list of members who opened the campaign email. |
| CampaignSendCheckList | Review the send checklist for a campaign, and resolve any issues before sending. |
| CampaignVariateContents | Get the the HTML and plain-text content for a campaign. |
| ChimpChatterActivity | Return the Chimp Chatter for this account ordered by most recent. |
| ConnectedSites | Get all connected sites in an account. |
| 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 | A Product Image represents a specific product image. |
| EcommercePromoCodes | Retrieves the list of promo codes under a promo rule |
| EcommercePromoRules | Get information about a store's promo rules |
| EcommerceStores | A list of an account's ecommerce stores. |
| FacebookAds | List of Facebook ads configured in Mailchimp. |
| FileManagerFolderFiles | List of files stored in Mailchimp file manager. |
| LandingPageContents | Get the content of a landing page. |
| LandingPages | Get a list of landing pages for the account. |
| ListAbuse | A collection of abuse complaints for a specific list. An abuse complaint occurs when your recipient clicks to 'report spam' in their email program. |
| ListActivity | Up to the previous 180 days of daily detailed aggregated activity stats for a given list. Does not include AutoResponder or Automation activity. |
| ListClients | Top email clients used, as measured by their user-agent string |
| ListGrowthHistory | A month-by-month summary of a specific list's growth activity. |
| ListMemberActivity | The last 50 member events for a list. |
| ListMemberActivityFeeds | Get a member's activity on a specific list, including opens, clicks, and unsubscribes. |
| ListMemberGoals | List goal events for a list member in Mailchimp. |
| ListMemberTags | Tags assigned to a certain member/members. |
| ListSignupForms | Collection of List Signup Forms |
| ListsTagsSearch | Search for tags on a list. |
| ListSurveys | Returns all surveys for a list. |
| ReportAbuse | A list of abuse complaints for a specific list. |
| ReportAdvice | A list of feedback based on a campaign's statistics. |
| ReportClickDetails | A list of URLs and unique IDs included in HTML and plain-text versions of a campaign. |
| ReportClickDetailsMembers | A collection of members who clicked on a specific link within a campaign. |
| ReportDomainPerformance | Statistics for the top-performing email domains in a campaign. |
| ReportEepUrls | Get EepURL activity reports. |
| ReportEmailActivity | A list of member's subscriber activity in a specific campaign. |
| ReportingFacebookAds | List of Facebook ad reports in Mailchimp. |
| ReportingLandingPages | Get reports of your landing pages. |
| ReportingSurveyQuestionAnswers | List of answers for a survey question. |
| ReportingSurveyQuestions | Get reports about your survey questions. |
| ReportLocations | Top open locations for a specific campaign. |
| ReportProductActivity | Campaign product activity report. |
| Reports | A list of reports containing campaigns marked as Sent. |
| ReportSentTo | A list of subscribers who were sent a specific campaign. |
| ReportSubReports | Child campaign reports. |
| ReportUnsubscribes | A list of members who have unsubscribed from a specific campaign. |
| SurveyResponses | List of survey responses. |
| Surveys | Get reports for surveys. |
| TransactionalScheduledEmails | Get Transactional Scheduled Emails. |
| TransactionalSenders | Get Transactional Senders. |
| TransactionalUserInfos | Get Transactional user info. |
| VerifiedDomains | List of sending domains configured in Mailchimp. |