Web tracking tables
Tracking table - "tracking"
Column name | datatype |
|---|---|
Id | bigint |
customer_key | varchar(100) |
contact_id | uniqueidentifier |
source | varchar(100) |
timestamp | datetime |
expires_at | datetime |
transfer_timestamp | datetime |
Tracking events table - "tracking_events"
Column name | datatype |
|---|---|
Id | bigint |
type | nvarchar(450) |
value | float |
properties | nvarchar(max) |
tracking_id | bigint |
transfer_timestamp | datetime |