# Visitors: Crisp Visitors - Catalog: `Crisp` - Schema: `Views` - Label: Visitors This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `Visitors` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `char` | | ☐ | Whether the visitor is actively browsing or not. | | `active` | `char` | | ☐ | Whether the visitor is actively browsing or not. | | `avatar` | `varchar2` | | ☐ | Avatar of the visitor. | | `avatar` | `varchar2` | | ☐ | Avatar of the visitor. | | `email` | `varchar2` | | ☐ | Email of the visitor. | | `email` | `varchar2` | | ☐ | Email of the visitor. | | `geolocation_city` | `varchar2` | | ☐ | City name. | | `geolocation_city` | `varchar2` | | ☐ | City name. | | `geolocation_coordinates_latitude` | `decimal` | | ☐ | Latitude coordinate. | | `geolocation_coordinates_latitude` | `decimal` | | ☐ | Latitude coordinate. | | `geolocation_coordinates_longitude` | `decimal` | | ☐ | Longitude coordinate. | | `geolocation_coordinates_longitude` | `decimal` | | ☐ | Longitude coordinate. | | `geolocation_country` | `varchar2` | | ☐ | Country code. | | `geolocation_country` | `varchar2` | | ☐ | Country code. | | `geolocation_region` | `varchar2` | | ☐ | Region code. | | `geolocation_region` | `varchar2` | | ☐ | Region code. | | `inbox_id` | `varchar2` | | ☐ | Inbox identifier of the visitor (if any). | | `inbox_id` | `varchar2` | | ☐ | Inbox identifier of the visitor (if any). | | `initiated` | `char` | | ☐ | Whether the session is initiated or not. | | `initiated` | `char` | | ☐ | Whether the session is initiated or not. | | `last_page_title` | `varchar2` | | ☐ | Title of the last page browsed. | | `last_page_title` | `varchar2` | | ☐ | Title of the last page browsed. | | `last_page_url` | `varchar2` | | ☐ | URL of the last page browsed. | | `last_page_url` | `varchar2` | | ☐ | URL of the last page browsed. | | `nickname` | `varchar2` | | ☐ | Nickname of the visitor. | | `nickname` | `varchar2` | | ☐ | Nickname of the visitor. | | `session_id` | `varchar2` | | ☑ | Session identifier of the visitor. | | `session_id` | `varchar2` | | ☑ | Session identifier of the visitor. | | `timezone` | `int32` | | ☐ | Time zone offset of the visitor in minutes relative to UTC, negated (-120 stands for UTC+02:00). | | `timezone` | `int32` | | ☐ | Time zone offset of the visitor in minutes relative to UTC, negated (-120 stands for UTC+02:00). | | `useragent` | `varchar2` | | ☐ | User agent as advertised by the browser of the visitor. | | `useragent` | `varchar2` | | ☐ | User agent as advertised by the browser of the visitor. |# Visitors: Crisp Visitors - Catalog: `Crisp` - Schema: `Views` - Label: Visitors This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `Visitors` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `char` | | ☐ | Whether the visitor is actively browsing or not. | | `active` | `char` | | ☐ | Whether the visitor is actively browsing or not. | | `avatar` | `varchar2` | | ☐ | Avatar of the visitor. | | `avatar` | `varchar2` | | ☐ | Avatar of the visitor. | | `email` | `varchar2` | | ☐ | Email of the visitor. | | `email` | `varchar2` | | ☐ | Email of the visitor. | | `geolocation_city` | `varchar2` | | ☐ | City name. | | `geolocation_city` | `varchar2` | | ☐ | City name. | | `geolocation_coordinates_latitude` | `decimal` | | ☐ | Latitude coordinate. | | `geolocation_coordinates_latitude` | `decimal` | | ☐ | Latitude coordinate. | | `geolocation_coordinates_longitude` | `decimal` | | ☐ | Longitude coordinate. | | `geolocation_coordinates_longitude` | `decimal` | | ☐ | Longitude coordinate. | | `geolocation_country` | `varchar2` | | ☐ | Country code. | | `geolocation_country` | `varchar2` | | ☐ | Country code. | | `geolocation_region` | `varchar2` | | ☐ | Region code. | | `geolocation_region` | `varchar2` | | ☐ | Region code. | | `inbox_id` | `varchar2` | | ☐ | Inbox identifier of the visitor (if any). | | `inbox_id` | `varchar2` | | ☐ | Inbox identifier of the visitor (if any). | | `initiated` | `char` | | ☐ | Whether the session is initiated or not. | | `initiated` | `char` | | ☐ | Whether the session is initiated or not. | | `last_page_title` | `varchar2` | | ☐ | Title of the last page browsed. | | `last_page_title` | `varchar2` | | ☐ | Title of the last page browsed. | | `last_page_url` | `varchar2` | | ☐ | URL of the last page browsed. | | `last_page_url` | `varchar2` | | ☐ | URL of the last page browsed. | | `nickname` | `varchar2` | | ☐ | Nickname of the visitor. | | `nickname` | `varchar2` | | ☐ | Nickname of the visitor. | | `session_id` | `varchar2` | | ☑ | Session identifier of the visitor. | | `session_id` | `varchar2` | | ☑ | Session identifier of the visitor. | | `timezone` | `int32` | | ☐ | Time zone offset of the visitor in minutes relative to UTC, negated (-120 stands for UTC+02:00). | | `timezone` | `int32` | | ☐ | Time zone offset of the visitor in minutes relative to UTC, negated (-120 stands for UTC+02:00). | | `useragent` | `varchar2` | | ☐ | User agent as advertised by the browser of the visitor. | | `useragent` | `varchar2` | | ☐ | User agent as advertised by the browser of the visitor. |