CampaignFeedback
Contains feedback comments submitted by recipients regarding a campaign's content or performance.
Table Specific Information
SELECT, INSERT, UPDATE, and DELTE are supported for CampaignFeedback.
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.
- FeedbackId supports the '=' operator.
- CampaignId supports the '=' operator.
SELECT * FROM CampaignFeedback WHERE FeedbackId = '1245' SELECT * FROM CampaignFeedback WHERE CampaignId = '1245'
Insert
The CampaignId and Message are required for INSERTs.
INSERT INTO CampaignFeedback (CampaignId, Message) VALUES ('myCampaignId', 'myMessage')
Columns
| Name | Type | ReadOnly | Description |
| FeedbackId [KEY] | Integer | True |
The unique identifier of the feedback entry associated with a campaign. |
| ParentId | Integer | True |
If the feedback is a reply, this field stores the identifier of the parent feedback item. |
| BlockId | Integer | False |
The identifier of the editable content block within the campaign that the feedback refers to. |
| Message | String | False |
The text content of the feedback message provided by the user. |
| IsComplete | Boolean | False |
If the value is 'true', the feedback item has been marked as resolved or completed. If the value is 'false', it remains open. |
| CreatedBy | String | True |
The username of the Mailchimp user who submitted the feedback. |
| CreatedAt | Datetime | True |
The date and time when the feedback entry was created. |
| UpdatedAt | Datetime | True |
The date and time when the feedback entry was last modified. |
| Source | String | True |
Indicates the platform or method through which the feedback was submitted, such as email, web, SMS, iOS, Android, or API. |
| CampaignId [KEY] | String | False |
The unique identifier of the campaign to which the feedback relates. |