The ARF_SITE_VISIT
table stores information about visits to the ATG Commerce sites you have configured. The table includes one row per visit to a site.
Column Name | Type | Length | Null | Description |
---|---|---|---|---|
| bigint | No | Identifier; primary key. | |
| timestamp | Yes | The date and time that the HTTP session started. | |
| varchar | 40 | No | Day the session began. Foreign key to |
| integer | No | Time the session began. Foreign key to | |
| integer | No | Day on which the session ended. Foreign key to | |
| integer | No | Time at which the session ended. Foreign key to | |
| timestamp | Yes | The date and time that the site visit started. | |
| varchar | 40 | No | Day the site visit began. Foreign key to |
| integer | No | Time the site visit began. Foreign key to | |
| varchar | 40 | No | Day on which the site visit ended. Foreign key to |
| integer | 40 | No | Time at which the site visit ended. Foreign key to |
| integer | No | Time at which the user made the last HTTP request in the session. This is different from | |
| integer | No | User ID of visitor. Foreign key to If visitor is anonymous, this is set to Unspecified User. | |
| smallint | No | Stimulus group associated with the visit. Foreign key to | |
| smallint | No | Demographic which represents the demographic profile of this site visit. Foreign key to | |
| smallint | No | The site at which the visit took place. Foreign key to | |
| smallint | No | The first site visited during the HTTP session in which this site visit occurred. Foreign key to | |
| smallint | No | The last site visited during the HTTP session in which this site visit occurred. Foreign key to | |
| smallint | No | The previous site visited during the HTTP session in which this site visit occurred. Foreign key to | |
| tinyint | No | The rank order in which this site visit took place during an HTTP session. | |
| smallint | No | The record in | |
| smallint | No | The record in | |
| varchar | 128 | No | The identifier of the HTTP session in which the visit occurred. The session identifier is assigned by the application server. |
| smallint | No | Number of pages the visitor viewed during the visit. | |
| smallint | No | Duration of the HTTP session in seconds. See DURATION_SECONDS. | |
| integer | No | The number of seconds that pass between the first and last HTTP requests in the HTTP session. See TOTAL_ELAPSED_DURATION_SECONDS. | |
| integer | No | The number of seconds that pass between the first and last HTTP requests in the site visit. See SITE_VISIT_DURATION_SECONDS. | |
| integer | No | The total number of seconds that a user spends visiting one site during an HTTP session. See RESOURCE_DURATION_SECONDS. |