# Mailchimp: Lists ## Description * Each record represents a list in Mailchimp, enriched with campaign metrics, (optionally) automation metrics and information about members. ## Supported Data Sources * Mailchimp ## Columns | Type | Name | Description | | -------- | ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | STRING | list\_id | The unique ID of a list. | | DATETIME | date\_created | The date and time that a list was created. | | STRING | name | The name of a list. | | DECIMAL | list\_rating | An auto-generated activity score for the list (0-5). | | STRING | beamer\_address | The list's email beamer address. | | STRING | contact\_address\_1 | The street address for the list contact. | | INTEGER | contact\_address\_2 | The street address for the list contact. | | STRING | contact\_city | The city for the list contact. | | STRING | contact\_company | The company name for the list. | | STRING | contact\_country | A two-character ISO3166 country code. Defaults to US if invalid. | | STRING | contact\_state | The state for the list contact. | | STRING | contact\_zip | The postal or zip code for the list contact. | | STRING | default\_from\_email | The default from email for campaigns sent to a list. | | STRING | default\_from\_name | The default from name for campaigns sent to a list. | | STRING | default\_language | The default language for a lists's forms. | | INTEGER | default\_subject | The default subject line for campaigns sent to a list. | | BOOLEAN | email\_type\_option | Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup. | | INTEGER | notify\_on\_subscribe | The email address to send subscribe notifications to. | | INTEGER | notify\_on\_unsubscribe | The email address to send unsubscribe notifications to. | | STRING | permission\_reminder | The permission reminder for a list. | | STRING | subscribe\_url\_long | The full version of a list's subscribe form (host will vary). | | STRING | subscribe\_url\_short | Mailchimp's EepURL shortened version of a list's subscribe form. | | BOOLEAN | use\_archive\_bar | Whether campaigns for this list use the Archive Bar in archives by default. | | STRING | visibility | Whether this list is public or private. | | INTEGER | count\_members | The number of members in a list. | | DATETIME | most\_recent\_signup\_timestamp | The date of the most recent signup to a list. | | INTEGER | campaign\_sends | The number of sent emails from campaigns. | | INTEGER | campaign\_opens | The number of open events from campaign emails. The same email being opened multiple times is included in this metric. | | INTEGER | campaign\_clicks | The number of click events from campaign emails. The same email being clicked multiple times is included in this metric. | | INTEGER | campaign\_unique\_opens | The unique number of emails opened from campaign emails. If a given email to a user was opened multiple times, it will only count once in this metric.This is the metric for opens that is reported by Mailchimp. | | INTEGER | campaign\_unique\_clicks | The unique number of emails clicked from campaign emails. If a given email to a user was clicked multiple times, it will only count once in this metric.This is the metric for clicks that is reported by Mailchimp. | | INTEGER | campaign\_unsubscribes | The number of users who have unsubscribed from campaign emails. | | INTEGER | automation\_sends | The number of sent emails from automations. | | INTEGER | automation\_opens | The number of open events from automation emails. The same email being opened multiple times is included in this metric. | | INTEGER | automation\_clicks | The number of click events from automation emails. The same email being clicked multiple times is included in this metric. | | INTEGER | automation\_unique\_opens | The unique number of emails opened from automation emails. If a given email to a user was opened multiple times, it will only count once in this metric.This is the metric for opens that is reported by Mailchimp. | | INTEGER | automation\_unique\_clicks | The unique number of emails clicked from automation emails. If a given email to a user was clicked multiple times, it will only count once in this metric.This is the metric for clicks that is reported by Mailchimp. | | INTEGER | automation\_unsubscribes | The number of users who have unsubscribed from automation emails. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/mailchimp-lists.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.