The CData ADO.NET Provider for Mailchimp models Mailchimp data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.

The provider dynamically retrieves custom fields for the ListMembers tables when you connect. Any changes you make to the custom fields, such as adding a new field or changing a custom field's data type, are reflected when you reconnect.

Dynamic Tables

Along with the default static tables, the provider also allows querying on dynamic tables. These are tables that are created based on the "audiences" (also called "lists") in your Mailchimp account.

For example, suppose you have three audiences in your account: Old Audience, New Audience, and VIP Audience. The provider creates two new tables for each audience: one is prefixed with ListMembers_ and the other with ListMergeFields_. In this example, the following six tables are created:

• ListMembers_OldAudience
• ListMembers_NewAudience
• ListMembers_VIPAudience
• ListMergeFields_OldAudience
• ListMergeFields_NewAudience
• ListMergeFields_VIPAudience

The tables are created by removing spaces from the audience name, then appending the result to ListMembers_ and ListMergeFields_.

• Tables prefixed with ListMembers_ display all members for a specific audience along with custom field values.
• Those starting with ListMergeFields_ display all custom fields names for members in that audience.

CData ADO.NET Provider 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	Returns the interest categories for a Mailchimp audience list.
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	Lists individuals who are currently or have been previously subscribed to this list, including members who have bounced or unsubscribed.
ListMergeFields	Returns merge fields for a Mailchimp list. Merge fields map to subscriber profile data, such as first name or address, and were previously referred to as merge vars.
Lists	Returns a collection of subscriber lists associated with this account. Lists contain subscribers who have opted in to receive correspondence from the account holder or their organization.
ListSegmentMembers	Returns the members of a specific list segment, including those who have bounced or unsubscribed.
ListSegments	Returns a list of available segments for a list.
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	Returns an account's available templates.