Schema · Entity relationship diagram
Triple Whale tables and relationships
Triple Whale pixel attribution for every order: all attribution models with the source, campaign, ad set and ad of each touchpoint, the full customer journey (page views, add-to-carts), plus your daily Summary page metrics (spend, ROAS, revenue and more across every connected channel).
triple_whaleorder_attribution_touchpointshas one row per order × attribution model × touchpoint;order_journey_eventsone row per pixel event.- A re-pulled order replaces all of its attribution and journey rows.
dateis the shop-local calendar date; timestamps are UTC.
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
4 tables · click a table for its columnsorders_with_journeys9 columnsshow in diagram
ordersWithJourneys: one row per order. journey_events = number of pixel events.
Primary key: order_id
| Column | Type | Key | Description |
|---|---|---|---|
| order_idPrimary key. | varchar(64) | PK | Primary key. |
| order_name | varchar(128) | ||
| date | date | ||
| created_at | timestamp | ||
| customer_id | varchar(64) | ||
| total_price | decimal(18,2) | ||
| currency | varchar(8) | ||
| journey_events | integer | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
order_attribution_touchpoints11 columnsshow in diagram
order.attribution: one row per attribution model (firstClick, linear, ...) x touchpoint (position 0 = first touchpoint the API lists for that model).
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| order_idReferences orders_with_journeys.order_id. | varchar(64) | FK | References orders_with_journeys.order_id. |
| date | date | ||
| attribution_model | varchar(64) | ||
| position | integer | ||
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| source | varchar(256) | ||
| campaign_id | varchar(256) | ||
| adset_id | varchar(256) | ||
| ad_id | varchar(256) | ||
| click_date | timestamp | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
order_journey_events9 columnsshow in diagram
order.journey: one row per pixel event, chronological (position 0 = first event).
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| order_idReferences orders_with_journeys.order_id. | varchar(64) | FK | References orders_with_journeys.order_id. |
| date | date | ||
| position | integer | ||
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| time | timestamp | ||
| event | varchar(128) | ||
| path | varchar(4096) | ||
| product_id | varchar(64) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
summary_page_metrics12 columnsshow in diagram
metrics: one row per day x summary-page metric (id = Triple Whale's metric id, e.g. 'sales'). services = the metric's contributing services, comma-separated.
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| date | date | ||
| id | varchar(256) | ||
| metric_id | varchar(256) | ||
| title | varchar(256) | ||
| tip | varchar(4096) | ||
| type | varchar(32) | ||
| values_current | decimal(24,6) | ||
| values_previous | decimal(24,6) | ||
| delta | decimal(24,6) | ||
| services | varchar(1024) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |