SEARCH
- Last Updated: July 2, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
Columns
The SEARCH view contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type | Notes |
|---|---|---|
| _BROWSER | String(255) | The name of users' browsers, for example, Internet Explorer or Firefox. |
| _CITY | String(255) | Users' city, derived from their IP addresses or Geographical IDs. |
| _CONTINENT | String(255) | Users' continent, derived from users' IP addresses or Geographical IDs. |
| _COUNTRY | String(255) | Users' country, derived from their IP addresses or Geographical IDs. |
| _DATE | Date | The date of the session formatted as YYYYMMDD. |
| _DAYOFWEEK | String(255) | Day of the week, a one-digit number from 0 (Sunday) to 6 (Saturday). |
| _DAYOFWEEKNAME | String(255) | Name (in English) of the day of the week. |
| _LANGUAGE | String(255) | The language, in ISO-639 code format (e.g., en-gb for British English), provided by the HTTP Request for the browser. |
| _METRO | String(255) | The Designated Market Area (DMA) from where traffic arrived. |
| _NETWORKDOMAIN | String(255) | The domain name of users' ISP, derived from the domain name registered to the ISP's IP address. |
| _NETWORKLOCATION | String(255) | The names of the service providers used to reach the property. For example, if most users of the website come via the major cable internet service providers, its value will be these service providers' names. |
| _OPERATINGSYSTEM | String(255) | Users' operating system, for example, Windows, Linux, Macintosh, or iOS. |
| _REGION | String(255) | Users' region, derived from their IP addresses or Geographical IDs. In U.S., a region is a state, New York, for example. |
| _SEARCHCATEGORY | String(255) | The category used for the internal search if site search categories are enabled in the view. For example, the product category may be electronics, furniture, or clothing. |
| _SEARCHDESTINATIONPAGE | String(255) | The page users immediately visited after performing an internal search on the site. This is usually the search results page. |
| _SEARCHKEYWORD | String(255) | Search term used within the property. |
| _SEARCHSTARTPAGE | String(255) | The page where users initiated an internal search. |
| _SEARCHUSED | String(255) | A boolean, either Visits With Site Search or Visits Without Site Search, to distinguish whether internal search was used in a session. |
| ENDDATE | Date | |
| ORGANICSEARCHES | Integer | The number of organic searches happened in a session. This metric is search engine agnostic. |
| SEARCHDEPTH | Integer | The total number of subsequent page views made after a use of the site's internal search feature. |
| SEARCHDURATION | Time | The session duration when the site's internal search feature is used. |
| SEARCHEXITS | Integer | The number of exits on the site that occurred following a search result from the site's internal search feature. |
| SEARCHUNIQUES | Integer | Total number of unique keywords from internal searches within a session. For example, if "shoes" was searched for 3 times in a session, it would be counted only once. |
| SEGMENTID | String(255) | |
| STARTDATE | Date | |
| VIEWID | String(255) |