CampaignOpenEmailDetails
Displays information about subscribers who opened a campaign email, including timestamps and interaction details.
Table Specific Information
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.
- 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. |