Tables
The connector models the data in Mailchimp as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for Mailchimp Tables
| Name | Description |
| CampaignFeedback | Contains feedback comments submitted by recipients regarding a campaign's content or performance. |
| CampaignFolders | Lists folders used to organize campaigns within the account. |
| Campaigns | Provides detailed information on campaigns created within the account, including type, status, and send statistics. |
| EcommerceCartLines | Lists individual items included in an e-commerce cart, including product details and quantities. |
| EcommerceCarts | Contains data on e-commerce carts associated with the account, including customer and total value information. |
| EcommerceCustomers | Stores records of e-commerce customers linked to Mailchimp, used for purchase tracking and segmentation. |
| EcommerceOrderLines | Lists line items included in e-commerce orders, such as product identifiers, quantities, and prices. |
| EcommerceOrders | Contains details of e-commerce orders tracked through connected stores, including order totals and customer details. |
| EcommerceProducts | Lists products available through connected e-commerce integrations, including titles, variants, and pricing. |
| EcommerceProductVariants | Contains information about product variants, such as size or color, linked to e-commerce items. |
| FileManagerFiles | Provides a catalog of all files and images stored in the account's File Manager, including metadata and size. |
| FileManagerFolders | Lists folders available in the File Manager for organizing images and files. |
| ListInterestCategories.rsd | The unique identifier for the interest category, used to reference or manage it within Mailchimp's segmentation and API operations. |
| ListInterests | Lists individual interests belonging to a specific interest category within a list. |
| ListMemberEvents | Contains event information related to individual list members, such as sign-ups or profile updates. |
| ListMemberNotes | Contains notes created for specific list members, showing the most recent entries by date. |
| ListMembers | Individuals who are currently or have been previously subscribed to this list, including members who have bounced or unsubscribed. |
| ListMergeFields.rsd | The display name of the merge field as it appears in the Mailchimp list and signup forms. |
| Lists | Contains all audience lists in the account, including configuration details, subscriber counts, and opt-in settings. |
| ListSegmentMembers | Lists subscribers that belong to a specific segment, including historical membership data. |
| ListSegments | Provides information on available audience segments, including criteria and segment type. |
| ListsWebhooks | Lists webhooks configured for an audience list, used to trigger updates based on subscriber activity. |
| TemplateFolders | Lists folders used to organize design templates within the account. |
| Templates | Contains all email templates available in the account, including type, name, and last-modified date. |
| TransactionalAllowlists | Lists all sender addresses or domains approved to send transactional messages through Mailchimp Transactional. |
| TransactionalTags | Lists available tags used to categorize transactional emails. |
| TransactionalTemplates | Contains all transactional email templates stored in the account. |