ReportLocations
Displays the top geographic locations where campaign emails were opened.
Table Specific Information
SELECT is supported for ReportLocations.
Select
The connector 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 connector.
- 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. |