CampaignOpenEmailDetails
Displays information about subscribers who opened a campaign email, including timestamps and interaction details.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| CampaignId | = |
| Since | = |
SELECT * FROM CampaignOpenEmailDetails
SELECT * FROM CampaignOpenEmailDetails WHERE CampaignId = '9f218dcf18'
SELECT * FROM CampaignOpenEmailDetails WHERE Since = '2024-02-07 00:00:37.0'
Columns
| Name | Type | References | Description |
| CampaignId [KEY] | String | The unique identifier of the campaign for which open activity is being retrieved. | |
| ListId [KEY] | String |
Lists.Id | The unique identifier of the audience list associated with the campaign. |
| ListIsActive | Boolean | If the value is 'true', the associated audience list is active. If the value is 'false', the list has been deleted or disabled. | |
| ContactStatus | String | The subscription status of the contact, such as subscribed, unsubscribed, or cleaned. | |
| EmailId [KEY] | String | The internal identifier assigned to the contact's email address within the Mailchimp system. | |
| EmailAddress | String | The email address of the subscriber who opened the campaign. | |
| MergeFields | String | A collection of merge field data for the contact, such as first name or company name, used for personalization. | |
| Vip | Boolean | If the value is 'true', the contact is marked as a VIP subscriber. If the value is 'false', they are a standard contact. | |
| OpensCount | Integer | The total number of times the subscriber opened the campaign email. | |
| Opens | String | Details of individual open events, including timestamps and locations where applicable. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| Since | Datetime | Restricts the results to campaign open events that occurred after the specified date and time. |