Adform
Explore the interactive ERD
Table & Field Reference
buyer_stats_metadata_metric_spec_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
buyer_stats_metadata_metric_id | Unknown | PKFK |
buyer_stats_metadata_metric_spec_index | Unknown | PKFK |
defaults | Unknown | |
description | Unknown | |
key | Unknown | |
title | Unknown |
buyer_stats_metadata_metric_spec
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
buyer_stats_metadata_metric_id | Unknown | PKFK |
description | Unknown | |
key | Unknown | |
title | Unknown |
buyer_stats_metadata_metric
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attributes | Json | |
category | Unknown | |
description | Unknown | |
display_format | Unknown | |
title | Unknown |
manager
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
full_name | Unknown | |
user_group_ids | Json |
time_zone
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
time_zone | Unknown |
tracking_domain
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
description | Unknown |
seller_stats_operation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
last_action_at | Unknown | |
location | Unknown | |
state | Unknown |
campaigns
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
manager_id | Unknown | FK |
advertiser_id | Unknown | |
billing_code | Unknown | |
budget | Unknown | |
co_manager_id | Unknown | |
currency | Unknown | |
end_date | Unknown | |
name | Unknown | |
purchase_order_number | Unknown | |
start_date | Instant | |
status | Unknown | |
sub_type | Unknown | |
time_zone | Unknown | |
type | Unknown |
seller_stats_metadata_dimension
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category | Unknown | |
description | Unknown | |
display_format | Unknown | |
title | Unknown |
buyer_stats_metadata_dimension
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category | Unknown | |
description | Unknown | |
display_format | Unknown | |
title | Unknown |
buyer_stats_operation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Instant | |
last_action_at | Instant | |
location | Unknown | |
status | Unknown |
seller_stats_metadata_metric_spec_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
seller_stats_metadata_metric_spec_index | Unknown | PKFK |
seller_stats_metadata_spec_id | Unknown | PKFK |
defaults | Unknown | |
description | Unknown | |
key | Unknown | |
title | Unknown |
seller_stats_metadata_metric_spec
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
seller_stats_metadata_metric_id | Unknown | PKFK |
description | Unknown | |
key | Unknown | |
title | Unknown |
seller_stats_metadata_metric
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attributes | Json | |
category | Unknown | |
description | Unknown | |
display_format | Unknown | |
title | Unknown |
publisher
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
order_budget_flight
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_id | Unknown | PKFK |
budget | Unknown | |
end_date | Unknown | |
name | Unknown | |
pacing_type | Unknown | |
period_type | Unknown | |
start_date | Unknown |
order_impression_capping
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_id | Unknown | PKFK |
impressions | Unknown | |
period_duration | Unknown | |
period_type | Unknown | |
type | Unknown | |
viewability_duration | Unknown | |
viewability_type | Unknown |
order_kpi
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_id | Unknown | PKFK |
ctr_rate | Unknown | |
ecpa_effective_cost | Unknown | |
ecpc_effective_cost | Unknown | |
ecpm_reach_effective_cost | Unknown | |
ecpm_viewable_effective_cost | Unknown | |
effective_cost | Unknown | |
roas_rate | Unknown | |
tracking_point_filter_id | Unknown | |
video_completion_rate | Unknown | |
viewable_rate | Unknown |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
active | Unknown | |
end_date | Unknown | |
goal_type | Unknown | |
start_date | Unknown |
placement_creative_setting
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
id | Unknown | |
name | Unknown |
placement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
publisher_id | Unknown | FK |
name | Unknown | |
status | Unknown | |
type | Unknown |