session_primary
- Sylvain Paillard
Description
This table contains information about each session.
All robots and crawler which are present in the core tables are filtered out.
Granularity
one row per:
session
Columns
Field name | Type | Mode | Description | |
|---|---|---|---|---|
| 1 | session_id | STRING | NULLABLE | PK - unique session id |
| 2 | session_start_ts | TIMESTAMP | NULLABLE | PK - starting timestamp (date time) of the session |
| 3 | session_end_ts | TIMESTAMP | NULLABLE | PK - last timestamp (date time) of the session |
| 4 | visitor_persona_id | STRING | NULLABLE | unique visitor id (cookie-based) |
| 5 | user_persona_id | STRING | NULLABLE | unique user persona id (only set for logged in sessions) |
| 6 | is_returning | STRING | NULLABLE | values Y and N indicating if the customer is a returning customer, based ON prior existence of the visitor_persona_id |
| 7 | page_view_cnt | INTEGER | NULLABLE | total number of page views in this session |
| 8 | page_view_1 | INTEGER | NULLABLE | 1 if page_view_cnt = 1 0 otherwise |
| 9 | page_view_2 | INTEGER | NULLABLE | 1 if page_view_cnt = 2 0 otherwise |
| 10 | page_view_3 | INTEGER | NULLABLE | 1 if page_view_cnt = 3 0 otherwise |
| 11 | page_view_4 | INTEGER | NULLABLE | 1 if page_view_cnt = 4 0 otherwise |
| 12 | page_view_5plus | INTEGER | NULLABLE | 1 if page_view_cnt >= 5 0 otherwise |
| 13 | product_view_cnt | INTEGER | NULLABLE | total number of product detail page view in this session |
| 14 | product_view_1 | INTEGER | NULLABLE | 1 if product_view_cnt = 1 0 otherwise |
| 15 | product_view_2 | INTEGER | NULLABLE | 1 if product_view_cnt = 2 0 otherwise |
| 16 | product_view_3 | INTEGER | NULLABLE | 1 if product_view_cnt = 3 0 otherwise |
| 17 | product_view_4 | INTEGER | NULLABLE | 1 if product_view_cnt = 4 0 otherwise |
| 18 | product_view_5plus | INTEGER | NULLABLE | 1 if product_view_cnt >= 5 0 otherwise |
| 19 | add_to_basket_cnt | INTEGER | NULLABLE | total number of products added to the basket in this session |
| 20 | add_to_basket_1 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 1 0 otherwise |
| 21 | add_to_basket_2 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 2 0 otherwise |
| 22 | add_to_basket_3 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 3 0 otherwise |
| 23 | add_to_basket_4 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 4 0 otherwise |
| 24 | add_to_basket_5plus | INTEGER | NULLABLE | 1 if add_to_basket_cnt >= 5 0 otherwise |
| 25 | order_list | STRING | REPEATED | list of order ids in this session |
| 26 | views_product_list | STRING | REPEATED | list of product views in this session |
| 27 | basket_crncy_cd | STRING | NULLABLE | currency code of the items added to the basket during the session |
| 28 | basket_crncy_amt | FLOAT | NULLABLE | currency amount of the items added to the basket during the session |
| 29 | basket_qty | INTEGER | NULLABLE | quantity of items in the basket |
| 30 | basket_product_list | STRING | REPEATED | list of product ids added to the basket during the session |
| 31 | landing_page_url | STRING | NULLABLE | the landing page url |
| 32 | landing_page_path | STRING | NULLABLE | the landing page url |
| 33 | landing_page_path_array | STRING | REPEATED | the landing page path AS array |
| 34 | landing_page_params | RECORD | REPEATED | the landing page path AS map |
| 35 | landing_page_params. name | STRING | NULLABLE | name |
| 36 | landing_page_params. value | STRING | NULLABLE | value |
| 37 | referral_url | STRING | NULLABLE | full url string of the referrer url |
| 38 | referral_path | STRING | NULLABLE | the landing page url |
| 39 | referral_path_array | STRING | REPEATED | the landing page path AS array |
| 40 | referral_params | RECORD | REPEATED | the landing page path AS map |
| 41 | referral_params. name | STRING | NULLABLE | name |
| 42 | referral_params. value | STRING | NULLABLE | value |
| 43 | channel | STRING | NULLABLE | referrer channel: paid search, organic search, e-mail, referral, display, direct, social, other |
| 44 | campaign | STRING | NULLABLE | the marketing campaign id passed to the initial referrer url of the session |
| 45 | source | STRING | NULLABLE | the source web-site of the initial referrer url of the session |
| 46 | medium | STRING | NULLABLE | the medium of the initial referrer url of the session |
| 47 | source_medium | STRING | NULLABLE | the combination of the source and of the medium with a space in the middle |
| 48 | keyword | STRING | NULLABLE | the keyword made in the search engine LIKE Google when coming to the web-site (not always availabe) |
| 49 | adContent | STRING | NULLABLE | the marketing adContent id passed to the initial referrer url of the session |
| 50 | country | STRING | NULLABLE | the country of the session based ON the ip of the session |
| 51 | country_iso_cd | STRING | NULLABLE | the country iso code of the session based ON the ip of the session |
| 52 | subdivision | STRING | NULLABLE | the subdivision (e.g.: state) of the session based ON the ip of the session |
| 53 | subdivision_iso_cd | STRING | NULLABLE | the subdivision iso code (e.g.: state) of the session based ON the ip of the session |
| 54 | postal_code | STRING | NULLABLE | the postal code of the session based ON the ip of the session |
| 55 | city | STRING | NULLABLE | the city of the session based ON the ip of the session |
| 56 | latitude | FLOAT | NULLABLE | the latitude float number point |
| 57 | longitude | FLOAT | NULLABLE | the longitude float number point |
| 58 | browser_name | STRING | NULLABLE | the browser name |
| 59 | browser_version | STRING | NULLABLE | the browser version number |
| 60 | operating_system | STRING | NULLABLE | the operating system name |
| 61 | device_category | STRING | NULLABLE | the type of device: Smartphone, Personal computer, Tablet, ... |
| 62 | browser_type | STRING | NULLABLE | the type of browser: Robot, Mobile Browser, Browser, Email client, ... |
| 63 | user_agent | STRING | NULLABLE | the user agent full string (unparsed) |
| 64 | session_duration | INTEGER | NULLABLE | the number of seconds between the first and last event of the session in seconds |
| 65 | session_orders | INTEGER | NULLABLE | the number of orders in this session |
| 66 | order_id | STRING | NULLABLE | first order id of this session |
| 67 | orders | INTEGER | NULLABLE | the number of orders FROM the sessions found in the order export |
| 68 | order_products | INTEGER | NULLABLE | the number of product in the orders FROM the sessions found in the order export |
| 69 | order_qty | INTEGER | NULLABLE | the total quantity of products in the orders FROM the sessions found in the order export |
| 70 | total_crncy_amt | FLOAT | NULLABLE | the total value of the orders FROM the sessions found in the order export |
| 71 | total_margin_crncy_amt | FLOAT | NULLABLE | the total margin value of the orders FROM the sessions found in the order export |
| 72 | order_products_list_crncy_amt | FLOAT | NULLABLE | the total value of the products before discount in the orders FROM the sessions found in the order export |
| 73 | order_products_discount_crncy_amt | FLOAT | NULLABLE | the total value of the products after discount in the orders FROM the sessions found in the order export |
| 74 | order_products_avg_list_crncy_amt | FLOAT | NULLABLE | the average value of the products before discount in the orders FROM the sessions found in the order export |
| 75 | order_products_avg_discount_crncy_amt | FLOAT | NULLABLE | the average value of the products after discount in the orders FROM the sessions found in the order export |
| 76 | account | STRING | NULLABLE | the account |
| 77 | parameters | RECORD | REPEATED | general structure of parameters and values |
| 78 | parameters. name | STRING | NULLABLE | name |
| 79 | parameters. value | STRING | NULLABLE | value |