events

source 2 PII columns

What customers did on the website.

Definition

Web event log — page views, add-to-cart, checkout funnel. Carries behavioral PII (`page_url` may include query-string identifiers; `session_id` is an online identifier under GDPR Art. 4(1)). Short retention (90 days). Not yet consumed by staging — kept available for future engagement-funnel marts.

8 of 8

Column

Description

Tests · PII

event_id

Primary key — BIGSERIAL on the source.

2 tests

customer_id

FK to `customers.customer_id`. Nullable for anonymous sessions.

customer +17 PII

event_type

Event kind — `page_view`, `add_to_cart`, `checkout_start`, `checkout_complete`.

event_ts

Time the event fired (TIMESTAMPTZ).

page_url

Page where the event was emitted. May contain query-string identifiers — treat as behavioral PII.

PII

product_id

FK to `products.product_id` when the event relates to a product (e.g. `add_to_cart`). Nullable.

session_id

Opaque session identifier — joins events fired within a single browsing session. Online identifier under GDPR Art. 4(1).

PII

created_at

Row insert timestamp in the source DB.