ReportLocations
Displays the top geographic locations where campaign emails were opened.
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 |
| CampaignId | = |
SELECT * FROM ReportLocations WHERE CampaignId = '45a'
Columns
| Name | Type | References | Description |
| CampaignId [KEY] | String |
Campaigns.Id | 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. |