ReportLocations
Displays the top geographic locations where campaign emails were opened.
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 unique identifier of the campaign associated with this location report. Each record represents campaign performance metrics for a specific region or country. |
| Region [KEY] | String | A specific geographical area, such as a city, state, or province, where campaign engagement activity occurred. |
| Opens | Integer | The total number of unique email opens recorded for this campaign within the specified region. Each recipient is counted once per region. |
| CountryCode | String | The two-letter ISO 3166 country code representing the country where the campaign engagement occurred. |
| RegionName | String | The display name of the region associated with the record. If the region value is blank, 'Rest of Country' is used to represent all remaining areas within the country. |
| ProxyExcludedOpens | Integer | The number of unique opens for the campaign in this region after excluding opens triggered by email clients that mask user activity through proxy services. |