CampaignOpenEmailDetails
A list of members who opened the campaign email.
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 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Since | Datetime | Restrict results to campaign open events that occur after a specific time. |