CampaignOpenEmailDetails
A list of members who opened the campaign email.
Table Specific Information
Select
The 本製品 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 本製品.
- 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. |