widget_facet_primary
- Sylvain Paillard
Description
This table contains information about each session and for each facet type, name and value (the refinement / filtering option selected by the user in the web-site) and for each widget.
As the columns of the session_primary table are duplicated along the different products of the same order it is important not to sum them while grouping by session only, which would cause over-counting.
Granularity
one row per:
session
widget
facet type
facet name
facet value
Columns
Field name | Type | Mode | Description |
|---|---|---|---|
facet_name | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the used facet (search filter) name |
facet_name_label | STRING | NULLABLE | label of the facet name |
facet_value | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the used facet (search filter) value |
facet_value_label | STRING | NULLABLE | label of the facet value |
facet_type | STRING | NULLABLE | the type of facet: 'hard', 'soft', 'filter' |
widget | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the widget name: search, navigation, basket, ... |
tpo | STRING | NULLABLE | the tpo of this widget |
journey_step | STRING | NULLABLE | the journey step of this widget (awareness, consideration, evaluation, purchase, re-buy, relationship) |
variant_id | STRING | NULLABLE | the test variant name |
variants | INTEGER | NULLABLE | the total number of test variants currently in this widget |
requests | INTEGER | NULLABLE | total number of requests, UNIQUE PER REQUEST, NO RISK OF OVERCOUNT |
landing_requests | INTEGER | NULLABLE | the number of requests which were landing page requests |
exit_requests | INTEGER | NULLABLE | the number of requests which were exit page requests |
avg_nth_page | FLOAT | NULLABLE | the average nth page view the request takes place at |
landing_session | INTEGER | NULLABLE | 1 if the session has at least one request being a landing page requests 0 otherwise |
exit_session | INTEGER | NULLABLE | 1 if the session has at least one request being an exit page requests 0 otherwise |
facets | RECORD | REPEATED | list of the used facets and their values |
facets. name | STRING | NULLABLE | facets. name |
facets. name_label | STRING | NULLABLE | facets. name_label |
facets. type | STRING | NULLABLE | facets. type |
facets. values | RECORD | REPEATED | facets. values |
facets.values. value | STRING | NULLABLE | facets.values. value |
facets.values. value_label | STRING | NULLABLE | facets.values. value_label |
facets.values. weight | FLOAT | NULLABLE | facets.values. weight |
context_parameters | RECORD | REPEATED | list of the used context aprameters and their values |
context_parameters. name | STRING | NULLABLE | context_parameters. name |
context_parameters. values | STRING | REPEATED | context_parameters. values |
filters | RECORD | REPEATED | list of the used context aprameters and their values |
filters. name | STRING | NULLABLE | filters. name |
filters. name_label | STRING | NULLABLE | filters. name_label |
filters. values | STRING | REPEATED | filters. values |
context_items | RECORD | REPEATED | list of the used context aprameters and their values |
context_items. name | STRING | NULLABLE | context_items. name |
context_items. values | STRING | REPEATED | context_items. values |
redirect_session | INTEGER | NULLABLE | 1 if the session has at least one request being with a redirect 0 otherwise |
redirect_cnt | INTEGER | NULLABLE | number of requests with a redirect |
extra_info_parameters | RECORD | REPEATED | list of the returned extra info parameters |
extra_info_parameters. name | STRING | NULLABLE | extra_info_parameters. name |
extra_info_parameters. values | STRING | REPEATED | extra_info_parameters. values |
avg_page_size | FLOAT | NULLABLE | the number of results displayed |
sort_field_session | INTEGER | NULLABLE | 1 if the session has at least one request being request with sort field 0 otherwise |
sort_field_cnt | INTEGER | NULLABLE | number of requests with changed sort fields |
sort_fields | RECORD | REPEATED | list of the used sort fields and their direction |
sort_fields. name | STRING | NULLABLE | sort_fields. name |
sort_fields. directions | STRING | REPEATED | sort_fields. directions |
session_id | STRING | NULLABLE | PK - unique session id |
session_start_ts | TIMESTAMP | NULLABLE | PK - starting timestamp (date time) of the session |
session_end_ts | TIMESTAMP | NULLABLE | PK - last timestamp (date time) of the session |
visitor_persona_id | STRING | NULLABLE | unique visitor id (cookie-based) |
user_persona_id | STRING | NULLABLE | unique user persona id (only set for logged in sessions) |
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 |
page_view_cnt | INTEGER | NULLABLE | total number of page views in this session |
page_view_1 | INTEGER | NULLABLE | 1 if page_view_cnt = 1 0 otherwise |
page_view_2 | INTEGER | NULLABLE | 1 if page_view_cnt = 2 0 otherwise |
page_view_3 | INTEGER | NULLABLE | 1 if page_view_cnt = 3 0 otherwise |
page_view_4 | INTEGER | NULLABLE | 1 if page_view_cnt = 4 0 otherwise |
page_view_5plus | INTEGER | NULLABLE | 1 if page_view_cnt >= 5 0 otherwise |
product_view_cnt | INTEGER | NULLABLE | total number of product detail page view in this session |
product_view_1 | INTEGER | NULLABLE | 1 if product_view_cnt = 1 0 otherwise |
product_view_2 | INTEGER | NULLABLE | 1 if product_view_cnt = 2 0 otherwise |
product_view_3 | INTEGER | NULLABLE | 1 if product_view_cnt = 3 0 otherwise |
product_view_4 | INTEGER | NULLABLE | 1 if product_view_cnt = 4 0 otherwise |
product_view_5plus | INTEGER | NULLABLE | 1 if product_view_cnt >= 5 0 otherwise |
add_to_basket_cnt | INTEGER | NULLABLE | total number of products added to the basket in this session |
add_to_basket_1 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 1 0 otherwise |
add_to_basket_2 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 2 0 otherwise |
add_to_basket_3 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 3 0 otherwise |
add_to_basket_4 | INTEGER | NULLABLE | 1 if add_to_basket_cnt = 4 0 otherwise |
add_to_basket_5plus | INTEGER | NULLABLE | 1 if add_to_basket_cnt >= 5 0 otherwise |
order_list | STRING | REPEATED | list of order ids in this session |
views_product_list | STRING | REPEATED | list of product views in this session |
basket_crncy_cd | STRING | NULLABLE | currency code of the items added to the basket during the session |
basket_crncy_amt | FLOAT | NULLABLE | currency amount of the items added to the basket during the session |
basket_qty | INTEGER | NULLABLE | quantity of items in the basket |
basket_product_list | STRING | REPEATED | list of product ids added to the basket during the session |
landing_page_url | STRING | NULLABLE | the landing page url |
landing_page_path | STRING | NULLABLE | the landing page url |
landing_page_path_array | STRING | REPEATED | the landing page path AS array |
landing_page_params | RECORD | REPEATED | the landing page path AS map |
landing_page_params. name | STRING | NULLABLE | landing_page_params. name |
landing_page_params. value | STRING | NULLABLE | landing_page_params. value |
referral_url | STRING | NULLABLE | full url string of the referrer url |
referral_path | STRING | NULLABLE | the landing page url |
referral_path_array | STRING | REPEATED | the landing page path AS array |
referral_params | RECORD | REPEATED | the landing page path AS map |
referral_params. name | STRING | NULLABLE | referral_params. name |
referral_params. value | STRING | NULLABLE | referral_params. value |
channel | STRING | NULLABLE | referrer channel: paid search, organic search, e-mail, referral, display, direct, social, other |
campaign | STRING | NULLABLE | the marketing campaign id passed to the initial referrer url of the session |
source | STRING | NULLABLE | the source web-site of the initial referrer url of the session |
medium | STRING | NULLABLE | the medium of the initial referrer url of the session |
source_medium | STRING | NULLABLE | the combination of the source and of the medium with a space in the middle |
keyword | STRING | NULLABLE | the keyword made in the search engine LIKE Google when coming to the web-site (not always availabe) |
adContent | STRING | NULLABLE | the marketing adContent id passed to the initial referrer url of the session |
country | STRING | NULLABLE | the country of the session based ON the ip of the session |
country_iso_cd | STRING | NULLABLE | the country iso code of the session based ON the ip of the session |
subdivision | STRING | NULLABLE | the subdivision (e.g.: state) of the session based ON the ip of the session |
subdivision_iso_cd | STRING | NULLABLE | the subdivision iso code (e.g.: state) of the session based ON the ip of the session |
postal_code | STRING | NULLABLE | the postal code of the session based ON the ip of the session |
city | STRING | NULLABLE | the city of the session based ON the ip of the session |
latitude | FLOAT | NULLABLE | the latitude float number point |
longitude | FLOAT | NULLABLE | the longitude float number point |
browser_name | STRING | NULLABLE | the browser name |
browser_version | STRING | NULLABLE | the browser version number |
operating_system | STRING | NULLABLE | the operating system name |
device_category | STRING | NULLABLE | the type of device: Smartphone, Personal computer, Tablet, ... |
browser_type | STRING | NULLABLE | the type of browser: Robot, Mobile Browser, Browser, Email client, ... |
user_agent | STRING | NULLABLE | the user agent full string (unparsed) |