The ARF_QUERY_MV_VISIT
view provides aggregated data about queries that are submitted to ATG Search. The calculated values are based on information in the ARF_QUERY
table. The values in each row are constrained to a particular day, site, language, query type, and site visit.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| numeric | Yes | The number of search queries that correspond to the day, site, language, query type, and site visit. 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 | |
| smallint | No | A reference to a value in the | |
| integer | No | A reference to a value in the | |
| bigint | No | A reference to a value in the | |
| numeric | Yes | The total length, in milliseconds, of the processing time for search queries for the day, site, language, query type, and site visit. This value sums | |
| numeric | Yes | The total number of search query results returned for the day, site, language, query type, and site visit. This value sums | |
| numeric | Yes | The total relevancy score of search query results for the day, site, language, query type, and site visit. This value sums | |
| numeric | Yes | The lowest length, in milliseconds, of the processing time for search queries for the day, site, language, query type, and site visit. This value is the minimum | |
| numeric | Yes | The longest length, in milliseconds, of the processing time for search queries for the day, site, language, query type, and site visit. This value is the maximum | |
| numeric | Yes | The lowest relevancy score in search query results for the day, site, language, query type, and site visit. This value is the minimum | |
| numeric | Yes | The highest relevancy score in search query results for the day, site, language, query type, and site visit. This value is the maximum |