ListLocations
Returns the locations (countries) that the list's subscribers have been tagged to based on geocoding their IP address in Mailchimp.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| ListId | = |
SELECT * FROM ListLocations
SELECT * FROM ListLocations WHERE ListId = '12345'
Columns
| Name | Type | References | Description |
| ListId | String |
Lists.Id | The unique Id for the list. |
| Country | String | The name of the country. | |
| CC | String | The ISO 3166 two-digit country code. | |
| Percent | Decimal | The percent of subscribers in the country. | |
| Total | Integer | The total number of subscribers in the country. |