CampaignOpenEmailDetails
Displays information about subscribers who opened a campaign email, including timestamps and interaction details.
Table Specific Information
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.
- Since supports the '=' operator.
For example:
SELECT * FROM CampaignOpenEmailDetails SELECT * FROM CampaignOpenEmailDetails WHERE CampaignId = '9f218dcf18' SELECT * FROM CampaignOpenEmailDetails WHERE Since = '2024-02-07 00:00:37.0'
Columns
| Name | Type | Description |
| CampaignId [KEY] | String | The unique identifier of the campaign for which open activity is being retrieved. |
| ListId [KEY] | String | 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 a more granular control over the tuples that are 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. |