JDBC Driver for Mailchimp

Build 22.0.8462

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.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462