tracking

Owned by Sylvain Paillard
Nov 19, 2020
1 min read

Tracking events generated through scripts during a web-browsing session on client's website. This event table DOES NOT have a primary key!

Field name

Type

Mode

Description

Field name

Type

Mode

Description

event_type

STRING

REQUIRED

e.g. login, search, purchase, pageView, productView, addToBasket...

event_tm

TIMESTAMP

REQUIRED

Timestamp of the event. Used to partition the data in the table by date

session_id

STRING

REQUIRED

needed when joining back to the session table

parameters

RECORD

REPEATED

is a list of key-value pairs that represent different tracked parameters describing customer interactions

parameters. key

STRING

NULLABLE

 

parameters. value

STRING

NULLABLE

 

creation_tm

DATETIME

REQUIRED

technical field

client_id

INTEGER

REQUIRED

technical field

src_sys_id

INTEGER

REQUIRED

technical field