The ARF_SITE_VISIT_MV_VISITOR 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 external user, day, and site.
Column Name | Type | Length | Null Allowed | Description |
|---|---|---|---|---|
| numeric | Yes | The number of site visits that correspond to the day, site and user. 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 | |
| integer | No | A reference to a value in the | |
| numeric | Yes | The number of Web site page views for the user, day, and site. This value sums | |
| numeric | Yes | The total length of HTTP sessions for the user, 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 user, 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 user, day, and site. This value sums | |
| numeric | Yes | The total time that Web site visitors spend visiting a site for the user and day. This value sums |
