session_primary

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

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