visitor |
Website Visitor
Catalog: Odoo
Schema: website
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table visitor are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
access_token |
string |
Access Token |
☑ |
|
country_flag |
string |
Country Flag |
☐ |
Url of static flag image |
country_id_label |
string |
|
☐ |
|
country_id |
string |
|
☐ |
|
create_date |
datetime |
First Connection |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
string |
☐ |
|
||
event_registered_ids |
string |
|
☐ |
|
event_registration_count |
int32 |
# Registrations |
☐ |
|
event_registration_ids |
string |
|
☐ |
|
has_push_notifications |
boolean |
Push Notifications Enabled |
☐ |
|
id |
int32 |
ID |
☐ |
|
is_connected |
boolean |
Is connected ? |
☐ |
A visitor is considered as connected if his last page view was within the last 5 minutes. |
lang_id_label |
string |
|
☐ |
Language from the website when visitor has been created |
lang_id |
string |
|
☐ |
Language from the website when visitor has been created |
last_connection_datetime |
datetime |
Last Connection |
☐ |
Last page view date |
last_visited_page_id_label |
string |
|
☐ |
|
last_visited_page_id |
string |
|
☐ |
|
lead_count |
int32 |
# Leads |
☐ |
|
lead_ids |
string |
|
☐ |
|
livechat_operator_id_label |
string |
|
☐ |
|
livechat_operator_id |
string |
|
☐ |
|
livechat_operator_name |
string |
Operator Name |
☐ |
|
mail_channel_ids |
string |
|
☐ |
|
mobile |
string |
Mobile |
☐ |
|
name |
string |
Name |
☐ |
|
page_count |
int32 |
# Visited Pages |
☐ |
Total number of tracked page visited |
page_ids |
string |
|
☐ |
|
partner_id_label |
string |
|
☐ |
Partner of the last logged in user. |
partner_id |
string |
|
☐ |
Partner of the last logged in user. |
partner_image |
byte[] |
Image |
☐ |
|
product_count |
int32 |
Products Views |
☐ |
Total number of product viewed |
product_ids |
string |
|
☐ |
|
push_subscription_ids |
string |
|
☐ |
|
session_count |
int32 |
# Sessions |
☐ |
|
time_since_last_action |
string |
Last action |
☐ |
Time since last page view. E.g.: 2 minutes ago |
timezone |
string |
Timezone |
☐ |
|
visit_count |
int32 |
# Visits |
☐ |
A new visit is considered if last connection was more than 8 hours ago. |
visitor_page_count |
int32 |
Page Views |
☐ |
Total number of visits on tracked pages |
visitor_product_count |
int32 |
Product Views |
☐ |
Total number of views on products |
website_id_label |
string |
|
☐ |
|
website_id |
string |
|
☐ |
|
website_track_ids |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826