Response Details report (export only)

The Response Details report (export only) exports response data from the Customer Feedback database to the CSV file format (comma separated values).

CSV is a delimited text file that uses a comma to separate values. This file format is very simple and supported by almost all external databases and reporting or analysis tools including Microsoft Excel.

The following types of data are exported:

Organization Information
Employee Information
Survey Level Information
Question Level Information

Report output/data

The following table describes the data that can be exported.

Data	Description
Organization Information
OrgID	Key to the ORGANIZATION table in BPMAINDB (operational database).
OrgName	Name of the employee’s organization.
ParentOrgId	Key to the ORGANIZATION table in BPMAINDB (operational database) for the organization one level above the employee’s organization.
ParentOrgName	Name of the organization one level above the employee’s organization.
ParentOrg2ID	Key to the ORGANIZATION table in BPMAINDB (operational database) for the organization two levels above the employee’s organization.
ParentOrg2Name	Name of the organization two levels above the employee’s organization.
Employee Information
EmpID	Key to the EMPLOYEEAM table in BPMAINDB (operational database).
EmpFName	Employee’s first name.
EmpMI	Employee’s middle initial. Optional field.
EmpLName	Employee’s last name.
JobTitle	Employee’s job title. Optional field.
Survey Level Information
SurveyID	Key to the SURVEY table in BPMAINDB (operational database).
SurveyMasterID	Unique ID assigned to each survey definition in BPWAREHOUSEDB.
SurveyName	Name of the survey.
NumQuesTotal	Total number of questions in the survey (includes all three questions types: option, scale, and comment).
TransactionID	Key to the TRANSACTIONTYPE table in BPMAINDB (operational database).
TransactionName	Name of the transaction (or service provided to the customer).
Language	Name of the survey language.
Channel	Survey channel (phone or web).
SurveyCallID	Key to the FACTSURVEY table in BPWAREHOUSEDB
InteractionEndDateGMT	Based on Greenwich Mean Time, the date and time of the interaction between the agent and the customer ended.
InteractionEndDateSSTZ	Based on the time zone of the survey server location, the date and time the interaction between the agent and the customer ended.
InteractionEndDateAOTZ	Based on the time zone of the agent’s organization, the date and time the interaction between the agent and the customer ended.
SurveyIssueDateGMT	Based on Greenwich Mean Time, the date and time the customer was invited to take a survey.
SurveyIssueDateSSTZ	Based on the time zone of the survey server location, the date and time the customer was invited to take a survey.
SurveyIssueDateAOTZ	Based on the time zone of the agent’s organization, the date and time the customer was invited to take a survey.
ResponseStartDateGMT	Based on Greenwich Mean Time, the date and time the customer started a survey.
ResponseStartDateSSTZ	Based on the time zone of the survey server location, the date and time the customer started a survey.
ResponseStartDateAOTZ	Based on the time zone of the agent’s organization, the date and time the customer started a survey.
ResponseDuration	Elapsed time between when the customer started and finished the survey. When the channel is phone, time is in milliseconds. When the channel is web, time is in seconds.
HasMessage	Indicates whether or not a closing comment exists.
WebMsg	For a web survey, text of the survey close comment when it exists.
QMSiteID	When Customer Feedback is integrated with Quality Monitoring, site ID of the Quality Monitoring system.
QMSessionID	When Customer Feedback is integrated with Quality Monitoring, session ID of the Quality Monitoring system.
SurveyCustAttr	User-defined field--typically Case Number or Customer ID.
SurveyUserField1	User-defined field.
SurveyUserField2	User-defined field.
SurveyUserField3	User-defined field.
SurveyUserField4	User-defined field.
SurveyUserField5	User-defined field.
IsAlertProcessed	Indicates whether or not the survey was processed for a possible alert action.
NumQuesMin	Minimum number of questions in the survey.
NumQuesMax	Maximum number of questions in the survey.
NumQuesAnsd	Total number of questions answered in the survey.
Question Level Information: The following information is provided for each question in the survey.
QuestID	Key to the QUESTION table in BPMAINDB (operational database).
QuestMasterID	Unique ID assigned to each QUESTION definition in BPWAREHOUSEDB.
QuestionName	Name of the question.
BusinessObj	Scale question: Name of business objective the question is assigned to. Option question: Blank. Comment question: Blank.
QuestionType	Type of question: scale, option, or comment.
QuestionScale	Scale question: Response scheme. Example: 0=Very Dissatisfied, 1=Very Satisfied Option question: Response scheme. Example: Selection of 3 options Comment question: Blank
QuesLowPossible	Scale question: Lowest possible scale number. Option question: Lowest possible option number. Comment question: Blank
QuesHighPossible	Scale question: Highest possible scale number. Option question: Highest possible option number. Comment question: Blank.
QuesLowLabel	Scale question: Response label for lowest possible scale number. Option question: Response label lowest possible option number. Comment question: Blank.
QuesHighLabel	Scale question: Response label for highest possible scale number. Option question: Response label highest possible option number. Comment question: Blank.
QuestAnswerID	Key to the FACTSURVEYANSWER table in BPWAREHOUSEDB.
QuestAnswerKeyEntry	Scale question: Phone Survey: Key pressed (IVR) or number spoken (VXML IVR) by customer. Web Survey: Number entered. Option question (Multiple choice question for web surveys): Phone Survey: Key pressed (IVR) or number spoken (VXML IVR) by customer. Web Survey: Number entered. Comment question: System generated value. 1 ( Has Message), 2 (No Message), -1 (Timeout)
QuesAnsScore	Scale question: Scale number chosen as the answer by the customer. Option question: Blank. Comment question: Blank.
QuesAnsLabel	Scale question: Label of the answer. Option question: Label of the answer. Comment question: For comment questions, indicates whether the question has a message, does not have a message, or the timeout period was reached before an answer was provided.
WebMessage	For a web survey, text of the comment question when it exists. (In the web survey application, the Customer Feedback comment question maps to the essay question.)

Report sample