session
- Sylvain Paillard
Online session of a customer. It lasts until a client browser is closed or a sessionid reset by the server. The session can be very long-lived
Field name | Type | Mode | Description |
|---|---|---|---|
session_id | STRING | REQUIRED | PK |
session_start_ts | TIMESTAMP | REQUIRED | session start is sourced from both _bx_completed_ts and tracking events |
session_end_ts | TIMESTAMP | REQUIRED | session end is sourced from both _bx_completed_ts and tracking events |
visitor_persona_id | STRING | REQUIRED |
|
user_persona_id | STRING | NULLABLE |
|
is_returning | STRING | NULLABLE | values Y and N indicating if the customer is a returning customer, may not be precise, based on checking existence of his/her persona_id |
page_view_cnt | INTEGER | NULLABLE |
|
product_view_cnt | INTEGER | NULLABLE |
|
add_to_basket_cnt | INTEGER | NULLABLE |
|
order_list | STRING | REPEATED | list of orders made during the session |
basket_crncy_cd | STRING | NULLABLE | currency of the basket in ISO format |
basket_crncy_amt | NUMERIC | NULLABLE |
|
basket_qty | INTEGER | NULLABLE |
|
basket_product_list | STRING | REPEATED | products added to the basket during the session (regardless of further actions) |
referral_path | STRING | NULLABLE | sourced from 'User-Referer' in requests[0].requestContext.parameters |
channel | STRING | NULLABLE | sourced from 'rf-ch' in variants[0].requestContext.parameters |
campaign | STRING | NULLABLE | sourced from 'rf-cn' in variants[0].requestContext.parameters |
source | STRING | NULLABLE | sourced from 'rf-s' in variants[0].requestContext.parameters |
medium | STRING | NULLABLE | sourced from 'rf-m' in variants[0].requestContext.parameters |
source_medium | STRING | NULLABLE | a combination of source and medium |
keyword | STRING | NULLABLE | sourced from 'rf-q' in variants[0].requestContext.parameters |
adContent | STRING | NULLABLE | sourced from 'rf-t' in variants[0].requestContext.parameters |
country | STRING | NULLABLE | sourced from 'geoIP-country' in variants[0].requestContext.parameters |
country_iso_cd | STRING | NULLABLE | sourced from 'geoIP-countryIsoCode' in variants[0].requestContext.parameters |
subdivision | STRING | NULLABLE | sourced from 'geoIP-subdivision' in variants[0].requestContext.parameters |
subdivision_iso_cd | STRING | NULLABLE | sourced from 'geoIP-subdivisionIsoCode' in variants[0].requestContext.parameters |
postal_code | STRING | NULLABLE | sourced from 'geoIP-postalCode' in variants[0].requestContext.parameters |
city | STRING | NULLABLE | sourced from 'geoIP-city' in variants[0].requestContext.parameters |
latitude | FLOAT | NULLABLE | sourced from 'geoIP-latitude' in variants[0].requestContext.parameters |
longitude | FLOAT | NULLABLE | sourced from 'geoIP-longitude' in variants[0].requestContext.parameters |
browser_name | STRING | NULLABLE | sourced from 'ua-name' in variants[0].requestContext.parameters |
browser_version | STRING | NULLABLE | sourced from 'ua-version' in variants[0].requestContext.parameters |
browser_type | STRING | NULLABLE | sourced from 'ua-type' in variants[0].requestContext.parameters |
operating_system | STRING | NULLABLE | sourced from 'ua-operatingSystem' in variants[0].requestContext.parameters |
device_category | STRING | NULLABLE | sourced from 'ua-deviceCategory' in variants[0].requestContext.parameters |
user_agent | STRING | NULLABLE | sourced from 'User-Agent' in variants[0].requestContext.parameters |
creation_tm | DATETIME | REQUIRED | technical field |
client_id | INTEGER | REQUIRED | technical field |
src_sys_id | INTEGER | REQUIRED | technical field |