Skip Navigation
Expand
  • Advanced SearchOpens new dialog
    Enter plus (+) or minus (-) signs in search terms to make a word required or excluded
    Search Tips
    Filter by product
    Filter by category
"Was this answer helpful?" Answer Feedback Data
Answer ID 5193   |   Last Review Date 10/07/2021

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.