Skip Navigation
Expand
Table cp_visitor_stats does not reflect the version of the browser used in the column browser_id
Answer ID 7893   |   Last Review Date 12/19/2018

How do we know the browser version used when checking statistics in cp_visitor_stats table?

Environment:

All Oracle B2C Service Releases

Resolution:

When using the table cp_visitor_stats for your statistics you will not see accurate data regarding the browser version used for the visits on your Customer Portal. As specified in the Data Dictionary, the browser_id column is derived from the user agent string and was not intended to provide the current version of the browser used.

In case you need to design a report in a way that retains the browser and its version from the user_agent_string, you might want to use clickstreams table instead.

For more information about the anatomy of a web session and clickstreams table please check the below answers:
Answer ID 5103: Anatomy of a web session as reported in the clickstreams table.

Answer ID 5142: Description of Action ID's in Clickstreams

You can read more information how user-agent string is parsed in the link: Understanding user-agent strings.