Windsor brings all your Mailchimp data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Mailchimp Field Reference
![](https://windsor.ai/wp-content/uploads/2021/11/mailchimp.png.webp)
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 | PERCENT | 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. |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
date | DATE | Date | The Date (copy of send_time, but this represents date only with no time) |
day_of_month | TEXT | Day of month | Day of the month |
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. |
month | TEXT | Month | Number of the month |
open_rate | PERCENT | 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 | TIMESTAMP | Send Time | The date and time a campaign was sent in ISO 8601 format. |
source | TEXT | Source | The name of the Windsor connector returning the row |
subject_line | TEXT | Subject Line | The subject line for the campaign. |
today | DATE | Today | Today's date |
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 | PERCENT | 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 | PERCENT | 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. |
week | TEXT | Week | Week (Sun-Sat). |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
year | TEXT | Year | Year |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |