ListLocations
List the locations (countries) that the list's subscribers have been tagged to based on geocoding their IP address in Mailchimp.
Table Specific Information
Select
The add-in will use 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 add-in.
- ListId supports the '=' operator.
SELECT * FROM ListLocations; SELECT * FROM ListLocations WHERE ListId = '12345';
Columns
| Name | Type | Description |
| ListId | String | The unique id for the list. |
| Country | String | The name of the country. |
| CC | String | The ISO 3166 2 digit country code. |
| Percent | Decimal | The percent of subscribers in the country. |
| Total | Integer | The total number of subscribers in the country. |