CampaignFeedback
Contains feedback comments submitted by recipients regarding a campaign's content or performance.
Table-Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for CampaignFeedback.
Select
The add-in uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| FeedbackId | = |
| CampaignId | = |
SELECT * FROM CampaignFeedback WHERE FeedbackId = '1245'
SELECT * FROM CampaignFeedback WHERE CampaignId = '1245'
Insert
The CampaignId and Message columns are required for INSERT operations.
INSERT INTO CampaignFeedback (CampaignId, Message) VALUES ('myCampaignId', 'myMessage')
Columns
| Name | Type | ReadOnly | References | 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 |
Campaigns.Id |
The unique identifier of the campaign to which the feedback relates. |