The ARF_SITE_VISIT_MV
view provides aggregated data about site visits. The calculated values are based on information in the ARF_SITE_VISIT
table. The values in each row are constrained to a particular day and site.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| numeric | Yes | The number of site visits that correspond to the day and site. This value counts rows in the | |
| varchar | 40 | No | A reference to a value in the |
| timestamp | No | A reference to a value in the | |
| smallint | No | A reference to a value in the | |
| numeric | Yes | The number of Web site page views for the day and site. This value sums | |
| numeric | Yes | The total length of HTTP sessions, in seconds, for the day and site. This value sums | |
| numeric | Yes | The total length of the periods between the first and last HTTP requests in Web site visits for the day and site. This value sums | |
| numeric | Yes | The total length of the periods between the first and last HTTP requests in HTTP sessions for the day and site. This value sums | |
| numeric | Yes | The total time that Web site visitors spend visiting a site for the day. This value sums |