Visitor Analytics - onwardpath/demo-repo GitHub Wiki

We are taking a new approach to store visitor analytics data

Table: Visitor

Columns:

entry_id - Primary Key, Auto Increment (Stores a unique id for each entry)
ip - To store the IP Address of the visitor.
cookie - To store the cookie of the visitor. Combination of ip and cookie can be used to detect a unique visitor
attribute - To store the attribute name
value - To store the attribute value

Example: Visitor John visits acmeinc.com home page. The GeoSmart JavaScript code is called from the homepage. The GeoSmart Web Service should log the following entries into the Visitor table:

Apart from HTTP Header Information, the following additional custom information should be stored:

session_id = {timestamp}+{ipaddress} page_url page_enter_time page_exit_time