Schema · Entity relationship diagram
Prescient AI tables and relationships
Prescient AI marketing mix model results: modeled first-order and halo (second-order) revenue and conversions by channel, campaign, day and model, platform-reported spend by campaign and day, and your model and channel lists. Prescient restates recent days as its model learns, so recent days are refreshed on every sync.
prescient- Prescient restates about 30 recent days every day and sometimes rebuilds all history after a retrain; both are picked up automatically.
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 columnsmodeled_metrics12 columns · Model outputshow in diagram
ModeledMetricRow, one row per sales channel x day x campaign x model x metric. _jsdata_id = md5(sales_channel|reported_date|source_channel_name|source_campaign_id| target|metric_name|target_channel_name) sales_channel is stamped by the connector (ECOMMERCE / RETAIL): the row type has no such field. target = model name (-> models.name). target_channel_name is set on SECOND_ORDER_* (halo) rows only and uses a different vocabulary from source_channel_name.
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_idRow id: md5 of the natural key. | varchar(32) | Row id: md5 of the natural key. | |
| sales_channelECOMMERCE or RETAIL, stamped by jsdata (the API row has no such field). | varchar(16) | ECOMMERCE or RETAIL, stamped by jsdata (the API row has no such field). | |
| reported_dateJoins to reported_metrics.reported_date,channel_name,campaign_id (spend for the same campaign and day (ROAS / CAC denominator)). | date | FK | Joins to reported_metrics.reported_date,channel_name,campaign_id (spend for the same campaign and day (ROAS / CAC denominator)). |
| source_channel_nameReferences channel_names.channel_name. Joins to reported_metrics.reported_date,channel_name,campaign_id (spend for the same campaign and day (ROAS / CAC denominator)). | varchar(128) | FK | References channel_names.channel_name. Joins to reported_metrics.reported_date,channel_name,campaign_id (spend for the same campaign and day (ROAS / CAC denominator)). |
| source_campaign_idJoins to reported_metrics.reported_date,channel_name,campaign_id (spend for the same campaign and day (ROAS / CAC denominator)). | varchar(256) | FK | Joins to reported_metrics.reported_date,channel_name,campaign_id (spend for the same campaign and day (ROAS / CAC denominator)). |
| source_campaign_name | varchar(1024) | ||
| targetReferences models.name. | varchar(256) | FK | References models.name. |
| target_channel_nameSet on halo (SECOND_ORDER_*) rows only; a different vocabulary from source_channel_name. | varchar(128) | Set on halo (SECOND_ORDER_*) rows only; a different vocabulary from source_channel_name. | |
| metric_name | varchar(64) | ||
| metric_value | decimal(24,6) | ||
| process_date | timestamp | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
models3 columns · Model outputshow in diagram
Model {name, unit}: the models referenced by modeled_metrics.target
Primary key: name
| Column | Type | Key | Description |
|---|---|---|---|
| namePrimary key. | varchar(256) | PK | Primary key. |
| unit | varchar(64) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
reported_metrics8 columns · Spendshow in diagram
ReportedMetricRow: platform-reported spend per campaign per day (the ROAS / CAC denominator). _jsdata_id = md5(reported_date|channel_name|campaign_id)
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_idRow id: md5 of the natural key. | varchar(32) | Row id: md5 of the natural key. | |
| reported_date | date | ||
| channel_nameReferences channel_names.channel_name. | varchar(128) | FK | References channel_names.channel_name. |
| campaign_id | varchar(256) | ||
| campaign_name | varchar(1024) | ||
| spend | decimal(18,4) | ||
| process_date | timestamp | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
channel_names2 columns · Spendshow in diagram
channelNames: source channels in use on the account
Primary key: channel_name
| Column | Type | Key | Description |
|---|---|---|---|
| channel_namePrimary key. | varchar(128) | PK | Primary key. |
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |