CampaignOpenEmailDetails
A list of members who opened the campaign email.
Table Specific Information
Select
The cmdlet 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 cmdlet.
- 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 Id for this application integration. |
| ListId [KEY] | String | The name of the application. |
| ListIsActive | Boolean | The description for the application. |
| ContactStatus | String | An array of usernames of the users who have linked this app. |
| EmailId [KEY] | String | The description for the application. |
| EmailAddress | String | The description for the application. |
| MergeFields | String | The description for the application. |
| Vip | Boolean | The description for the application. |
| OpensCount | Integer | The description for the application. |
| Opens | String | The description for the application. |
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 | Restrict results to campaign open events that occur after a specific time. |