Lists

A collection of subscriber lists associated with this account. Lists contain subscribers who have opted-in to receive correspondence from you or your organization.

Table Specific Information

SELECT, INSERT, UPDATE, and DELETE are supported for Lists.

Select

The driver will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

Id supports the '=' operator.
DateCreated supports the '=,<,>,<=,>=' operator.
Stats_CampaignLastSent supports the '=,<,>,<=,>=' operator.

SELECT * FROM Lists WHERE Id = 'abc'
SELECT * FROM Lists WHERE DateCreated = '2024-02-07 00:00:37.0'
SELECT * FROM Lists WHERE DateCreated >= '2024-02-07 00:00:37.0'
SELECT * FROM Lists WHERE DateCreated <= '2024-02-07 00:00:37.0'
SELECT * FROM Lists WHERE DateCreated > '2024-02-07 00:00:37.0'
SELECT * FROM Lists WHERE DateCreated < '2024-02-07 00:00:37.0'

Insert

The Name, PermissionReminder, EmailTypeOption, Contact_Company, Contact_Address1, Contact_City, Contact_State, Contact_Zip, Contact_Country, CampaignDefaults_FromName, CampaignDefaults_FromEmail, CampaignDefaults_Subject, and CampaignDefaults_Language are required for INSERTs.

INSERT INTO Lists (Name, PermissionReminder, EmailTypeOption, Contact_Company, Contact_Address1, Contact_City, Contact_State, Contact_Zip, Contact_Country, CampaignDefaults_FromName, CampaignDefaults_FromEmail, CampaignDefaults_Subject, CampaignDefaults_Language) VALUES ('myName', 'myPermissionReminder', 'true', 'myCompany', 'myAddress', 'myCity', 'myState', 'myZip', 'myCountry', 'myFromName', 'myFromEmail', 'myDefaultSubject', 'myDefaultLanguage')

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	A string that uniquely identifies this list
Name	String	False	The name of the list.
Contact_Company	String	False	The company name associated with the list.
Contact_Address1	String	False	The street address for the list contact.
Contact_Address2	String	False	The street address for the list contact.
Contact_City	String	False	The city for the list contact.
Contact_State	String	False	The state for the list contact.
Contact_Zip	String	False	The postal or zip code for the list contact.
Contact_Country	String	False	A two-character ISO3166 country code. Defaults to US if invalid.
Contact_Phone	String	False	The phone number for the list contact.
PermissionReminder	String	False	The permission reminder for the list: a line of text that appears in the footer of each campaign that explains why subscribers are receiving the email campaign.
UseArchiveBar	Boolean	False	Whether or not campaigns for this list use the Archive Bar in archives by default.
CampaignDefaults_FromName	String	False	The default from name for campaigns sent to this list.
CampaignDefaults_FromEmail	String	False	The default from email (must be a valid email address) for campaigns sent to this list.
CampaignDefaults_Subject	String	False	The default subject line for campaigns sent to this list.
CampaignDefaults_Language	String	False	The default language for this lists's forms.
NotifyOnSubscribe	String	False	The email address to send subscribe notifications to, when enabled.
NotifyOnUnsubscribe	String	False	The email address to send unsubscribe notifications to, when enabled.
DateCreated	Datetime	True	The date and time that this list was created.
ListRating	Integer	True	An auto-generated activity score for the list (0-5).
EmailTypeOption	Boolean	False	Whether or not the list supports multiple formats for emails.
SubscribeUrlShort	String	True	Our eepurl shortened version of this list's subscribe form.
SubscribeUrlLong	String	True	The full version of this list's subscribe form (host will vary).
BeamerAddress	String	True	The email address to use for this list's Email Beamer.
Visibility	String	False	Whether this list is public (pub) or private (prv). Used internally for projects like Wavelength.
Modules	String	True	Any list-specific modules installed for this list.
Stats_MemberCount	Integer	True	The number of active members in the given list.
Stats_UnsubscribeCount	Integer	True	The number of members who have unsubscribed from the given list.
Stats_CleanedCount	Integer	True	The number of members cleaned from the given list.
Stats_MemberCountSinceSend	Integer	True	The number of active members in the given list since the last campaign was sent.
Stats_UnsubscribeCountSinceSend	Integer	True	The number of members who have unsubscribed since the last campaign was sent.
Stats_CleanedCountSinceSend	Integer	True	The number of members cleaned from the given list since the last campaign was sent.
Stats_CampaignCount	Integer	True	The number of campaigns in any status that use this list.
Stats_CampaignLastSent	Datetime	True	The date and time the last campaign was sent to this list.
Stats_MergeFieldCount	Integer	True	The number of merge vars for this list (not including the required EMAIL one).
Stats_AvgSubRate	Double	True	The average number of subscriptions per month for the list (not returned if we haven't calculated it yet).
Stats_AvgUnsubRate	Double	True	The average number of unsubscriptions per month for the list (not returned if we haven't calculated it yet).
Stats_TargetSubRate	Double	True	The target numberof subscriptions per month for the list to keep it growing (not returned if we haven't calculated it yet).
Stats_OpenRate	Double	True	The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet).
Stats_ClickRate	Double	True	The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet).
Stats_LastSubDate	Datetime	True	The date and time of the last time someone subscribed to this list.
Stats_LastUnsubDate	Datetime	True	The date and time of the last time someone unsubscribed from this list.
WebId	Integer	True	The ID used in the Mailchimp web application. View this campaign in your Mailchimp account at https://{dc}.admin.mailchimp.com/campaigns/show/?id={web_id}.
DoubleOptin	Boolean	False	Whether or not to require the subscriber to confirm subscription via email.
HasWelcome	Boolean	True	Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup.
MarketingPermissions	Boolean	False	Whether or not the list has marketing permissions (eg. GDPR) enabled.
Stats_TotalContacts	Integer	True	The number of contacts in the list, including subscribed, unsubscribed, pending, cleaned, deleted, transactional, and those that need to be reconfirmed. Requires include_total_contacts query parameter to be included.

JDBC Driver for Mailchimp

Lists

Table Specific Information

Select

Insert

Columns