Mailchimp Google Data Studio Connector by Windsor.ai
+
About the Connector
The Mailchimp Data Studio Connector pulls metrics and dimensions from Mailchimp. The metrics and dimeinos are retrieved at a campaign and URL level.
There are 50+ metrics and dimensions exposed by this connector. Once user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
The user should have access to a Mailchimp account with enough access rights to create an API token to access the Mailchimp data via this connector. The user will be prompted for a Mailchimp API key during the installation of this connector.
Our privacy policy and terms of use: https://windsor.ai/privacy-statement/
Available Metrics and Dimensions
| ID | Name | Description |
|---|---|---|
| Abuse Reports | NUMERIC | The number of abuse reports generated for this campaign. |
| Campaign ID | TEXT | A string that uniquely identifies this campaign. |
| Campaign Title | TEXT | The title of the campaign. |
| Campaign Type | TEXT | The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto). |
| Click Rate | NUMERIC | The number of unique clicks divided by the total number of successful deliveries. |
| Clicks Total | NUMERIC | The total number of clicks for the campaign. |
| Date | DATE | The Date (copy of send_time, but this represents date only with no time) |
| Emails Sent | NUMERIC | The total number of emails sent for this campaign. |
| Forward Count | NUMERIC | How many times the campaign has been forwarded. |
| Forwards Opens | NUMERIC | How many times the forwarded campaign has been opened. |
| Last Click | DATE | The date and time of the last recorded click for the campaign in ISO 8601 format. |
| Last Open | DATE | The date and time of the last recorded open in ISO 8601 format. |
| List ID | NUMERIC | The unique list id. |
| List Is Active | TEXT | The status of the list used, namely if it's deleted or disabled. |
| List Name | TEXT | The name of the list. |
| Open Rate | NUMERIC | The number of unique opens divided by the total number of successful deliveries. |
| Opens Total | NUMERIC | The total number of opens for a campaign. |
| Preview Text | TEXT | The preview text for the campaign. |
| RSS Last Send | DATE | For RSS campaigns, the date and time of the last send in ISO 8601 format. |
| Send Time | DATE | The date and time a campaign was sent in ISO 8601 format. |
| Subject Line | TEXT | The subject line for the campaign. |
| Unique Clicks | NUMERIC | The total number of unique clicks for links across a campaign. |
| Unique Opens | NUMERIC | The total number of unique opens. |
| Unique Subscriber Clicks | NUMERIC | The total number of subscribers who clicked on a campaign. |
| Unsubscribed | NUMERIC | The total number of unsubscribed members for this campaign. |
| Url | TEXT | The URL for the link in the campaign. |
| Url Campaign Id | TEXT | The campaign id. |
| Url Click Percentage | NUMERIC | The percentage of total clicks a link generated for a campaign. |
| Url Id | TEXT | The unique id for the link. |
| Url Last Click | DATE | The date and time for the last recorded click for a link in ISO 8601 format. |
| Url Total Clicks | NUMERIC | The number of total clicks for a link. |
| Url Unique Click Percentage | NUMERIC | The percentage of unique clicks a link generated for a campaign. |
| Url Unique Clicks | NUMERIC | Number of unique clicks for a link. |