Open Data Warehouse (CODW)

This section describes the CORE DataSet.

Make sure to only access the CORE DataSet through the VIEWS dataset. Each core table has its equivalent view returning the same format of data but possibly applying required filters/adjustments over the CORE Data which are immutable.

Tables Overview

Boxalino analytics tables are stored in the [ACCOUNT_NAME]_core dataset.

Group	Tables	Description	Keys

Group	Tables	Description	Keys
Customer	customer	Physical person (unique e-mail)	customer_id
	customer_property	Properties of a physical person	customer_id, property_name
	persona	Logical person (an user (acount), a visitor (cookie))	persona_id
	persona_property	Properties of a Logical person	persona_id, property_name
	persona_property_history	History of property values of of a Logical person	persona_id, property_name
	customer_persona_relation	Connections between customers and other personas	customer_id, persona_id
	visitor_user_relation	Connections between visitor and user personas	visitor_persona_id, user_persona_id
Product / Content	product	Product id and base fields (also used for other contents like blogs)	product_id
	product_property	Product properties	product_id, property_name
Orders	order	A transaction (connect to a persona)	order_id, persona_id
	order_line	A product in a transaction (connect to a product)	order_id, line_num
	order_line_property	Properties of an order lines	order_id, line_num, property_name
Behaviors	session	All sessions	session_id
	request	All requests to a Widget (e.g.: search, recs, …)	request_id, session_id
	request_context	Request parameters (e.g.: currently set search filters)	context_id
	product_response	Each request returned hit (e.g.: product groups) displayed to a user	request_id, variant_id
	facet_response	Each request returned facet (filtering option) displayed to a user	request_id, variant_id, field_name
	extrainfo_response	More parameters describing the request response	request_id, variant_id
	tracking	all the tracking events of Boxalino Tracker	sesion_id