FeedbackSummary
Create, delete, and query Feedback Summaries in Twilio.
Select
Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can be used with only the equals or = comparison. Only Sid is supported in the WHERE clause and it is required.
SELECT * FROM FeedbackSummary WHERE Sid = 'FS123456789'
Insert
To add a FeedbackSummary, specify at least these parameters: StartDate, EndDate, and IncludeSubaccounts.
INSERT INTO FeedbackSummary (StartDate, EndDate, IncludeSubaccounts) VALUES ('2014-06-01', '2014-06-30', true)
Update
Twilio does not allow FeedbackSummary to be updated.
Delete
DELETE FROM FeedbackSummary WHERE Sid = 'FS123456789'
Columns
| Name | Type | ReadOnly | References | Description |
| Sid [KEY] | String | False |
The Id of the feedback summary. | |
| StartDate | Date | False |
The start date of the feedback summary. | |
| EndDate | Date | False |
The end date of the feedback summary. | |
| AccountSid | String | True |
The account Id of the feedback summary. | |
| IncludeSubaccounts | Boolean | False |
Whether to include subaccounts in feedback summary. | |
| Status | String | True |
The status of the feedback summary. One of the following values: queued, in-progress, completed, or failed. | |
| CallCount | Integer | True |
The total call count. | |
| CallFeedbackCount | Integer | True |
The count of calls associated with the feedback summary. | |
| QSAverage | Double | True |
The quality score average of the feedback summary. | |
| QSMedian | Double | True |
The quality score median of the feedback avarage. | |
| QSStandardDeviation | Double | True |
The quality score standard deviation of the feedback summary. | |
| IssuesDescription | String | True |
The issues description of the feedback summary. | |
| IssuesCount | Integer | True |
The issues count of the feedback summary. | |
| IssuesPercentageOfTotalCalls | Double | True |
The percentage of calls that experienced this issue. | |
| DateCreated | Datetime | True |
The creation date of the feedback summary. | |
| DateUpdated | Datetime | True |
The modification date of the feedback summary. |