Gladior Consultancy team

Support Page Mailchimp Connector

Support

Report an issue
Terms and conditions

Mailchimp for Google Data Studio

With the Mailchimp Connector you can report on the most important statistics of your Mailchimp account. To use this connector you need an API Key.

How to connect the data?

We will explain how you can connect the data to Data Studio.

1). Go to https://www.gladior.com/data-studio/mailchimp-connector/ and get your account token.

2). When you’ve generated the account token, copy this code and go to the link below the code

3). Authorize the use of the Data Studio Connector

4). The next step is to authorize our Mailchimp connector.

5). Paste the account token in this field and click on next.

6). Login to your account and make the connection.

7). Click “Connect”.

8). When you’ve made the connection with Data Studio you will see all the possible fields of data with a description of what they mean.

9). When you click on ‘make report’ you will connect the data to the template.

Metrics and Dimensions

You can send the following metrics and dimensions to Google Data Studio:

NameTypeDescription
Create timeDIMENSIONYEAR_MONTH_DAY_SECONDThe date and time the campaign was created
Archive urlDIMENSIONURLThe link to the campaign's archive version
StatusDIMENSIONTEXTThe current status of the campaign
TitleDIMENSIONTEXTThe current title of the campaign
OpensMETRICNUMBERThe opens of the campaign
Unique opensMETRICNUMBERThe unique opens of the campaign
UnopenedMETRICNUMBERThe unopened of the campaign
Open rateMETRICPERCENTThe open rate of the campaign
ClicksMETRICNUMBERThe amount of clicks of the campaign
Subscriber clicksMETRICNUMBERThe amount of subscriber clicks of the campaign
Click rateMETRICPERCENTThe click rate of the campaign
Ecommerce total ordersMETRICNUMBER
Ecommerce total spentMETRICCURRENCY_EUR
Ecommerce total revenueMETRICCURRENCY_EUR
Emails sentMETRICNUMBERThe amount of emails sent of the campaign
List nameDIMENSIONTEXT
CompanyDIMENSIONTEXT
Address 1DIMENSIONTEXT
Address 2DIMENSIONTEXT
CityDIMENSIONTEXT
StateDIMENSIONTEXT
ZipDIMENSIONTEXT
CountryDIMENSIONTEXT
PhoneDIMENSIONTEXT
Date createdDIMENSIONYEAR_MONTH_DAY_SECOND
Member countMETRICNUMBER
Unsubscribe countMETRICNUMBER
Campaign countMETRICNUMBER
Open rate listMETRICPERCENT
Click rate listMETRICPERCENT