Mailchimp Field Reference
Sample
http://connectors.windsor.ai/mailchimp?fields=abuse_reports,campaign_id,campaign_title,campaign_type,click_rate,clicks_total,date,emails_sent,forwards_count,forwards_opens,last_click,last_open,list_id,list_is_active,list_name,open_rate,opens_total,preview_text,rss_last_send,send_time,subject_line,unique_clicks,unique_opens,unique_subscriber_clicks&api_key=[your API key]&date_preset=last_7d
The Mailchimp connector lets you pull Mailchimp campaign and URL performance data. An example for querying campaign reports can be found above. If you specify the fields date_from and date_to it will query the data for absolute date ranges.
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| abuse_reports | NUMERIC | Abuse Reports | The number of abuse reports generated for this campaign. |
| campaign_id | TEXT | Campaign ID | A string that uniquely identifies this campaign. |
| campaign_title | TEXT | Campaign Title | The title of the campaign. |
| campaign_type | TEXT | Campaign Type | The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto). |
| click_rate | NUMERIC | Click Rate | The number of unique clicks divided by the total number of successful deliveries. |
| clicks_total | NUMERIC | Clicks Total | The total number of clicks for the campaign. |
| date | DATE | Date | The Date (copy of send_time, but this represents date only with no time) |
| emails_sent | NUMERIC | Emails Sent | The total number of emails sent for this campaign. |
| forwards_count | NUMERIC | Forward Count | How many times the campaign has been forwarded. |
| forwards_opens | NUMERIC | Forwards Opens | How many times the forwarded campaign has been opened. |
| last_click | DATE | Last Click | The date and time of the last recorded click for the campaign in ISO 8601 format. |
| last_open | DATE | Last Open | The date and time of the last recorded open in ISO 8601 format. |
| list_id | TEXT | List ID | The unique list id. |
| list_is_active | TEXT | List Is Active | The status of the list used, namely if it's deleted or disabled. |
| list_name | TEXT | List Name | The name of the list. |
| open_rate | NUMERIC | Open Rate | The number of unique opens divided by the total number of successful deliveries. |
| opens_total | NUMERIC | Opens Total | The total number of opens for a campaign. |
| preview_text | TEXT | Preview Text | The preview text for the campaign. |
| rss_last_send | DATE | RSS Last Send | For RSS campaigns, the date and time of the last send in ISO 8601 format. |
| send_time | DATE | Send Time | The date and time a campaign was sent in ISO 8601 format. |
| subject_line | TEXT | Subject Line | The subject line for the campaign. |
| unique_clicks | NUMERIC | Unique Clicks | The total number of unique clicks for links across a campaign. |
| unique_opens | NUMERIC | Unique Opens | The total number of unique opens. |
| unique_subscriber_clicks | NUMERIC | Unique Subscriber Clicks | The total number of subscribers who clicked on a campaign. |
| unsubscribed | NUMERIC | Unsubscribed | The total number of unsubscribed members for this campaign. |
| url | TEXT | Url | The URL for the link in the campaign. |
| url_campaign_id | TEXT | Url Campaign Id | The campaign id. |
| url_click_percentage | NUMERIC | Url Click Percentage | The percentage of total clicks a link generated for a campaign. |
| url_id | TEXT | Url Id | The unique id for the link. |
| url_last_click | DATE | Url Last Click | The date and time for the last recorded click for a link in ISO 8601 format. |
| url_total_clicks | NUMERIC | Url Total Clicks | The number of total clicks for a link. |
| url_unique_click_percentage | NUMERIC | Url Unique Click Percentage | The percentage of unique clicks a link generated for a campaign. |
| url_unique_clicks | NUMERIC | Url Unique Clicks | Number of unique clicks for a link. |