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 add-in 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 add-in.
- 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. |