Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Mailchimp account. The add-in uses the Mailchimp API to process supported filters. The add-in processes other filters client-side within the add-in.

Commonly used tables include:

Table	Description
Automations	A summary of the automations within an account.
AutomationEmails	A summary of the emails in an automation workflow.
CampaignContents	Retrieves the HTML and plain-text content associated with a specific campaign.
CampaignFeedback	Contains feedback comments submitted by recipients regarding a campaign's content or performance.
Campaigns	Provides detailed information on campaigns created within the account, including type, status, and send statistics.
EcommerceCustomers	Stores records of e-commerce customers linked to Mailchimp, used for purchase tracking and segmentation.
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.
EcommerceStores	A list of an account's ecommerce stores.
ListActivity	Displays up to 180 days of daily aggregated activity statistics for a given audience list, excluding automation events.
ListMembers	Individuals who are currently or have been previously subscribed to this list, including members who have bounced or unsubscribed.
ListMemberTags	Tags assigned to a certain member/members.
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.
ReportClickDetails	A list of URLs and unique IDs included in HTML and plain-text versions of a campaign.
ReportEmailActivity	A list of member's subscriber activity in a specific campaign.
Reports	A list of reports containing campaigns marked as Sent.
Templates	A list an account's available templates.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including managing campaigns and transactions, and managing OAuth tokens.