Mailchimp
## Columns
| Type | Name | Description |
| -------- | ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING | campaign\_id | The ID of the campaign in Mailchimp. |
| INTEGER | segment\_id | The ID of the Segment a campaign was sent to. |
| DATETIME | create\_timestamp | The date and time the campaign was created. |
| DATETIME | send\_timestamp | The date and time a campaign was sent. |
| STRING | list\_id | The ID of the List a campaign was sent to. |
| STRING | reply\_to\_email | The reply-to email address for the campaign. |
| STRING | campaign\_type | The type of campaign sent. Possible values: regular, plaintext, absplit, variate, rss. |
| STRING | title | The title of the campaign. |
| STRING | archive\_url | The link to the campaign's archive version in ISO 8601 format. |
| BOOLEAN | authenticate | Whether Mailchimp authenticated the campaign. Defaults to true. |
| BOOLEAN | auto\_footer | Automatically append Mailchimp's default footer to the campaign. |
| BOOLEAN | auto\_tweet | Automatically tweet a link to the campaign archive page when the campaign is sent. |
| STRING | clicktale | The custom slug for ClickTale tracking (max of 50 bytes). |
| STRING | content\_type | How the campaign's content is put together ('template', 'drag\_and\_drop', 'html', 'url'). |
| BOOLEAN | drag\_and\_drop | Whether the campaign uses the drag-and-drop editor. |
| BOOLEAN | fb\_comments | Allows Facebook comments on the campaign (also force-enables the Campaign Archive toolbar). Defaults to true. |
| INTEGER | folder\_id | If the campaign is listed in a folder, the ID for that folder. |
| STRING | from\_name | The 'from' name on the campaign (not an email address). |
| STRING | google\_analytics | The custom slug for Google Analytics tracking (max of 50 bytes). |
| BOOLEAN | inline\_css | Automatically inline the CSS included with the campaign content. |
| STRING | long\_archive\_url | The original link to the campaign's archive version. |
| STRING | status | The current status of the campaign. |
| STRING | subject\_line | The subject line for the campaign. |
| INTEGER | template\_id | The ID for the template used in this campaign. |
| INTEGER | test\_size | The percentage of recipients to send the test combinations to, must be a value between 10 and 100. |
| BOOLEAN | timewarp | Send this campaign using Timewarpe\_this |
| STRING | to\_name | The campaign's custom 'To' name. Typically the first name merge field. |
| BOOLEAN | track\_ecomm\_360 | Whether to enable eCommerce360 tracking. |
| BOOLEAN | track\_goals | Whether to enable Goal tracking. |
| BOOLEAN | track\_html\_clicks | Whether to track clicks in the HTML version of the campaign. Defaults to true. Cannot be set to false for variate campaigns. |
| BOOLEAN | track\_opens | Whether to track opens. Defaults to true. Cannot be set to false for variate campaigns. |
| BOOLEAN | track\_text\_clicks | Whether to track clicks in the plain-text version of the campaign. Defaults to true. Cannot be set to false for variate campaigns. |
| BOOLEAN | use\_conversation | Use Mailchimp Conversation feature to manage out-of-office replies. |
| INTEGER | wait\_time | The number of minutes to wait before choosing the winning campaign. The value of wait\_time must be greater than 0 and in whole hours, specified in minutes. |
| INTEGER | winner\_criteria | The combination that performs the best. This may be determined automatically by click rate, open rate, or total revenue—or you may choose manually based on the reporting data you find the most valuable. For Multivariate Campaigns testing send\_time, winner\_criteria is ignored. For Multivariate Campaigns with 'manual' as the winner\_criteria, the winner must be chosen in the Mailchimp web application. |
| INTEGER | winning\_campaign\_id | ID of the campaign that was sent to the remaining recipients based on the winning combination. |
| INTEGER | winning\_combination\_id | ID for the winning combination. |
| INTEGER | sends | The number of sent emails from campaigns. |
| INTEGER | opens | The number of open events from campaign emails. The same email being opened multiple times is included in this metric. |
| INTEGER | clicks | The number of click events from campaign emails. The same email being clicked multiple times is included in this metric. |
| INTEGER | 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 | 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 | unsubscribes | The number of users who have unsubscribed from campaign 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-campaigns.md?ask=