Is there a standard report that will provide answer data for the "Was this answer helpful?" question?
Environment
Oracle B2C Service
Answer Feedback, Analytics for Answer Feedback
Resolution
In Oracle B2C Service, the standard report "Answers Viewed by Answer" (report ID 4) displays the end user data gathered by the "Was this answer helpful?" question. This report uses the ans_stats table, provides answer feedback information, and shows the total number of answers accessed from the end-user pages over a specified time period. The report can be found in Reports Explorer by navigating to:
\Public Reports\Service\Site Reports\Answers Viewed
You can use this report to determine which answers have been selected, as well as which are most useful. You can also track how the score of an answer changes over time. Running the report and drilling down on a specific day displays a list of answers. Because answer feedback can be configured to be either a simple Yes/No or a ranking star system you will have ratings from 0% to 100%. When Yes/No is used, the 'Rank #1 Count' column represents a No and the 'Rank #5 Count' column represents a Yes.
Notes
If this report is not detailed enough for your reporting needs, you can use the ans_stats table to create a custom report for answer feedback. For example, filter on incident source equals 'Feedback on Answers'.
The Data Dictionary will be helpful in creating/modifying custom reports:
Answer ID 2611: Accessing the data dictionary .
If you need further, more in-depth assistance, skilled consultants can assist you with your custom reporting questions, or can build custom reports for you. Please see Answer ID 10745: Oracle Consulting Services & Implementation Partners for more information.