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