ReportLocations
Top open locations for a specific campaign.
Table Specific Information
SELECT is supported for ReportLocations.
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.
- CampaignId supports the '=' operator.
SELECT * FROM ReportLocations where CampaignId = '45a'
Columns
| Name | Type | Description |
| CampaignId [KEY] | String | The CampaignId for the table. |
| Region [KEY] | String | A more specific location area such as city or state. |
| Opens | Integer | The number of unique campaign opens for a given region. |
| CountryCode | String | The ISO 3166 2 digit country code. |
| RegionName | String | The name of the region, if we have one. For blank 'region' values, this will be 'Rest of Country'. |
| ProxyExcludedOpens | Integer | The number of unique campaign opens for a region excluding opens from email clients that use proxies. |