StackAdapt
Explore the interactive ERD
Table & Field Reference
stats_delivery_native_ad
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
advertiser_id | Unknown | FK |
campaign_id | Unknown | FK |
conversion_tracker_id | Unknown | FK |
line_item_id | Unknown | FK |
native_ad_id | Unknown | FK |
advertiser | Unknown | |
app_name | Unknown | |
atos | Unknown | |
atos_units | Unknown | |
banned | Unknown | |
campaign_custom_fields | Json | |
channel | Unknown | |
click | Unknown | |
click_url | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_click_time_avg | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
conversion_tracker | Unknown | |
cost | Unknown | |
creatives_img_url | Unknown | |
creatives_size | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
date | Unknown | |
display | Unknown | |
domain | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
end_date | Unknown | |
full_domain | Unknown | |
heading | Unknown | |
imp | Unknown | |
ios_id | Unknown | |
is_android | Unknown | |
is_ios | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
measure_ias | Unknown | |
native_ad | Unknown | |
nativead | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
page_time_units | Unknown | |
profit | Unknown | |
rcpa | Unknown | |
rcpc | Unknown | |
rcpcl | Unknown | |
rcpe | Unknown | |
rcpm | Unknown | |
revenue | Unknown | |
s_conv | Unknown | |
sconv_imp | Unknown | |
seller | Unknown | |
source | Unknown | |
start_date | Unknown | |
stats_50_v_2_s_ias | Unknown | |
sub_advertiser | Unknown | |
sub_advertiser_id | Unknown | |
superbanned | Unknown | |
tagline | Unknown | |
tp_cpc_cost | Unknown | |
tp_cpm_cost | Unknown | |
uniq_conv | Unknown | |
uniq_imp | Unknown | |
unique_imp | Unknown | |
unique_imp_inverse_rate | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_supply_source
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_demographic
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_category
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
creative_imp_tracker_url
| Column | Type | Keys |
|---|---|---|
imp_tracker_url | Unknown | PK |
creative_id | Unknown | PKFK |
creative_vast_tracker
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
creative_id | Unknown | PKFK |
event_type | Unknown | |
url | Unknown |
creative_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creative_id | Unknown | PKFK |
file_name | Unknown | |
height | Unknown | |
url | Unknown | |
width | Unknown |
creative_icon
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creative_id | Unknown | PKFK |
file_name | Unknown | |
height | Unknown | |
url | Unknown | |
width | Unknown |
creative_display_js
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
creative_id | Unknown | PKFK |
height | Unknown | |
img_url | Unknown | |
is_expandable | Unknown | |
js_code | Unknown | |
js_code_macro | Unknown | |
width | Unknown |
creative_input_data_video
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
creative_id | Unknown | PKFK |
bitrate | Unknown | |
duration | Unknown | |
file_type | Unknown | |
height | Unknown | |
s_3_url | Unknown | |
width | Unknown |
creative_input_data_audio
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
creative_id | Unknown | PKFK |
bitrate | Unknown | |
duration | Unknown | |
file_type | Unknown | |
height | Unknown | |
s_3_url | Unknown | |
width | Unknown |
creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_frameworks | Json | |
audit_status | Unknown | |
brandname | Unknown | |
channel | Unknown | |
click_url | Unknown | |
created_at | Unknown | |
cta_text | Unknown | |
input_heading | Unknown | |
input_landing_url | Unknown | |
input_tagline | Unknown | |
input_vast_xml | Unknown | |
name | Unknown | |
state | Unknown | |
status_code | Unknown | |
status_description | Unknown | |
updated_at | Unknown |
insight_campaign_deal
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_creative_tactic
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
supply_source_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | PK |
insight_campaign_group_device
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
custom_segment_option
| Column | Type | Keys |
|---|---|---|
identifier | Unknown | PK |
name | Unknown | PK |
insight_campaign_group_supply_source
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_bid_factor
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_audience_ab
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
advertiser_line_item
| Column | Type | Keys |
|---|---|---|
advertiser_id | Unknown | PKFK |
line_item_id | Unknown | PKFK |
advertiser
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown |
insight_campaign_group_creative_tactic
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_geo
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
stats_delivery_advertiser
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
advertiser_id | Unknown | FK |
campaign_id | Unknown | FK |
conversion_tracker_id | Unknown | FK |
line_item_id | Unknown | FK |
native_ad_id | Unknown | FK |
advertiser | Unknown | |
app_name | Unknown | |
atos | Unknown | |
atos_units | Unknown | |
banned | Unknown | |
campaign_custom_fields | Json | |
channel | Unknown | |
click | Unknown | |
click_url | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_click_time_avg | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
conversion_tracker | Unknown | |
cost | Unknown | |
creatives_img_url | Unknown | |
creatives_size | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
date | Unknown | |
display | Unknown | |
domain | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
end_date | Unknown | |
engage_rate | Unknown | |
full_domain | Unknown | |
heading | Unknown | |
imp | Unknown | |
ios_id | Unknown | |
is_android | Unknown | |
is_ios | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
measure_ias | Unknown | |
native_ad | Unknown | |
nativead | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
page_time_units | Unknown | |
profit | Unknown | |
rcpa | Unknown | |
rcpc | Unknown | |
rcpcl | Unknown | |
rcpe | Unknown | |
rcpm | Unknown | |
revenue | Unknown | |
s_conv | Unknown | |
sconv_click | Unknown | |
sconv_imp | Unknown | |
seller | Unknown | |
source | Unknown | |
start_date | Unknown | |
stats_50_v_2_s_ias | Unknown | |
sub_advertiser | Unknown | |
sub_advertiser_id | Unknown | |
superbanned | Unknown | |
tagline | Unknown | |
tp_cpc_cost | Unknown | |
tp_cpm_cost | Unknown | |
uniq_conv | Unknown | |
uniq_ecpa | Unknown | |
uniq_imp | Unknown | |
unique_imp | Unknown | |
unique_imp_inverse_rate | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_deal
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_geo
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_retargeting_segment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_category
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_bid_factor
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
stats_delivery_campaign
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
advertiser_id | Unknown | FK |
campaign_id | Unknown | FK |
conversion_tracker_id | Unknown | FK |
line_item_id | Unknown | FK |
native_ad_id | Unknown | FK |
advertiser | Unknown | |
app_name | Unknown | |
atos | Unknown | |
atos_units | Unknown | |
banned | Unknown | |
campaign_custom_fields | Json | |
campaign_type | Unknown | |
channel | Unknown | |
click | Unknown | |
click_url | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_click_time_avg | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
conversion_tracker | Unknown | |
cost | Unknown | |
creatives_img_url | Unknown | |
creatives_size | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
date | Unknown | |
display | Unknown | |
domain | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
end_date | Unknown | |
engage_rate | Unknown | |
full_domain | Unknown | |
heading | Unknown | |
imp | Unknown | |
ios_id | Unknown | |
is_android | Unknown | |
is_ios | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
measure_ias | Unknown | |
native_ad | Unknown | |
nativead | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
page_time_units | Unknown | |
profit | Unknown | |
rcpa | Unknown | |
rcpc | Unknown | |
rcpcl | Unknown | |
rcpe | Unknown | |
rcpm | Unknown | |
revenue | Unknown | |
s_conv | Unknown | |
sconv_imp | Unknown | |
seller | Unknown | |
source | Unknown | |
start_date | Unknown | |
stats_50_v_2_s_ias | Unknown | |
sub_advertiser | Unknown | |
sub_advertiser_id | Unknown | |
superbanned | Unknown | |
tagline | Unknown | |
tp_cpc_cost | Unknown | |
tp_cpm_cost | Unknown | |
uniq_conv | Unknown | |
uniq_imp | Unknown | |
unique_imp_inverse_rate | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_audience_ab
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
audience_permitted_advertiser
| Column | Type | Keys |
|---|---|---|
audience_id | Unknown | PKFK |
permitted_advertiser_id | Unknown | PKFK |
audience_file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
audience_id | Unknown | PKFK |
files_path | Unknown | |
name | Unknown | |
size | Unknown | |
url | Unknown |
audience_geo_targets_file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
audience_id | Unknown | PKFK |
files_path | Unknown | |
name | Unknown | |
size | Unknown | |
url | Unknown |
audience
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
advertiser_permission_restricted | Unknown | |
collection_window_explicit_date_ranges | Unknown | |
collection_window_mode | Unknown | |
collection_window_recurring_end_time | Unknown | |
collection_window_recurring_start_time | Unknown | |
collection_window_recurring_weekdays | Unknown | |
collection_window_timezone | Unknown | |
created_at | Unknown | |
expandable | Unknown | |
geo_targets_distance_units | Unknown | |
identifier | Unknown | |
name | Unknown | |
size | Unknown | |
time_window | Unknown |
group_all_campaign
| Column | Type | Keys |
|---|---|---|
campaign_group_id | Unknown | PKFK |
campaign_id | Unknown | PKFK |
campaign_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
advertiser_id | Unknown | FK |
black_list_options | Unknown | |
budget | Unknown | |
daily_cap | Unknown | |
end_date | Unknown | |
name | Unknown | |
pace_evenly | Unknown | |
purchase_order_number | Unknown | |
revenue_type | Unknown | |
revenue_value | Unknown | |
start_date | Unknown | |
state | Unknown | |
status_code | Unknown | |
status_description | Unknown |
campaign_conversion_tracker
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
conversion_tracker_id | Unknown | PKFK |
campaign_creative
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
creative_id | Unknown | PKFK |
campaign_deal_group
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
deal_group_id | Unknown | PKFK |
campaign_custom_segment
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
custom_segment_id | Unknown | PKFK |
campaign_supply_source_option
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
supply_source_option_id | Unknown | PKFK |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
advertiser_id | Unknown | FK |
line_item_id | Unknown | FK |
allow_iframe_engagement | Unknown | |
bid_amount_total | Unknown | |
bid_type | Unknown | |
budget | Unknown | |
canada_province_options | Json | |
category_options | Json | |
city_options | Unknown | |
country_options | Json | |
custom_segments_ids | Json | |
custom_segments_list | Json | |
daily_cap | Unknown | |
day_part_enabled | Unknown | |
day_part_end_hour | Unknown | |
day_part_start_hour | Unknown | |
day_part_timezone | Unknown | |
demo_and_interests_ids | Json | |
demo_and_interests_list | Json | |
device_type_options | Json | |
domain_action | Unknown | |
domain_options | Json | |
end_date | Unknown | |
engagement_tracking_type | Unknown | |
freq_cap_limit | Unknown | |
freq_cap_time | Unknown | |
goal | Unknown | |
is_deal_id_strict | Unknown | |
language_options | Json | |
name | Unknown | |
optimize_type | Unknown | |
optimize_value | Unknown | |
other_state_options | Json | |
pace_evenly | Unknown | |
start_date | Unknown | |
state | Unknown | |
status_code | Unknown | |
status_description | Unknown | |
supply_type_options | Json | |
third_party_segments | Json | |
type | Unknown | |
uk_county_options | Json | |
us_state_options | Json | |
use_dma | Unknown | |
weekday_budgets | Json | |
weekday_enabled | Unknown | |
weekday_percents | Json |
conversion_tracker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conv_type | Unknown | |
count_type | Unknown | |
description | Unknown | |
name | Unknown | |
post_time | Unknown | |
user_id | Unknown |
insight_campaign_device
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_audience
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
retargeting_audience_advertiser
| Column | Type | Keys |
|---|---|---|
advertiser_id | Unknown | PKFK |
retargeting_audience_id | Unknown | PKFK |
retargeting_audience
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action_type | Unknown | |
advertiser_restricted | Unknown | |
description | Unknown | |
name | Unknown | |
post_time | Unknown | |
required_frequency | Unknown |
insight_campaign_group_audience
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
deal_group_supported_channel
| Column | Type | Keys |
|---|---|---|
supported_channel_type | Unknown | PK |
deal_group_id | Unknown | PKFK |
deal_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown |
stats_delivery_conversion_tracker
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
advertiser_id | Unknown | FK |
campaign_id | Unknown | FK |
conversion_tracker_id | Unknown | FK |
line_item_id | Unknown | FK |
native_ad_id | Unknown | FK |
advertiser | Unknown | |
app_name | Unknown | |
atos | Unknown | |
atos_units | Unknown | |
banned | Unknown | |
campaign_custom_fields | Json | |
channel | Unknown | |
click | Unknown | |
click_url | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_click_time_avg | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
conversion_tracker | Unknown | |
cost | Unknown | |
creatives_img_url | Unknown | |
creatives_size | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
date | Unknown | |
display | Unknown | |
domain | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
end_date | Unknown | |
full_domain | Unknown | |
heading | Unknown | |
imp | Unknown | |
ios_id | Unknown | |
is_android | Unknown | |
is_ios | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
native_ad | Unknown | |
nativead | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
page_time_units | Unknown | |
profit | Unknown | |
rcpa | Unknown | |
rcpc | Unknown | |
rcpcl | Unknown | |
rcpe | Unknown | |
rcpm | Unknown | |
revenue | Unknown | |
s_conv | Unknown | |
sconv_click | Unknown | |
sconv_imp | Unknown | |
seller | Unknown | |
source | Unknown | |
start_date | Unknown | |
sub_advertiser | Unknown | |
sub_advertiser_id | Unknown | |
superbanned | Unknown | |
tagline | Unknown | |
tp_cpc_cost | Unknown | |
tp_cpm_cost | Unknown | |
tracker_conv | Unknown | |
uniq_conv | Unknown | |
uniq_imp | Unknown | |
unique_imp_inverse_rate | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_retargeting_segment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
insight_campaign_group_demographic
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_group_id | Unknown | FK |
acomp_0 | Unknown | |
acomp_25 | Unknown | |
acomp_50 | Unknown | |
acomp_75 | Unknown | |
acomp_95 | Unknown | |
atos | Unknown | |
avg_time_on_site_units | Unknown | |
campaign | Unknown | |
campaign_custom_fields | Json | |
campaign_id | Unknown | |
categories | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
cost | Unknown | |
country | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
demographics_segment | Unknown | |
devicetype | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
engage_rate | Unknown | |
imp | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
merged_segments | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
programmatic_deal_group_id | Unknown | |
region | Unknown | |
retargeting_segment | Unknown | |
roas | Unknown | |
s_conv | Unknown | |
sub_advertiser | Unknown | |
supply_source | Unknown | |
tactic_bid_id | Unknown | |
tactic_native_ad_id | Unknown | |
time_on_site | Unknown | |
total_time_units | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |
stats_delivery_campaign_group
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
advertiser_id | Unknown | FK |
campaign_id | Unknown | FK |
conversion_tracker_id | Unknown | FK |
line_item_id | Unknown | FK |
native_ad_id | Unknown | FK |
advertiser | Unknown | |
app_name | Unknown | |
atos | Unknown | |
atos_units | Unknown | |
banned | Unknown | |
campaign_custom_fields | Json | |
channel | Unknown | |
click | Unknown | |
click_url | Unknown | |
conv | Unknown | |
conv_click | Unknown | |
conv_click_time_avg | Unknown | |
conv_cookie | Unknown | |
conv_imp_derived | Unknown | |
conv_imp_time_avg | Unknown | |
conv_ip | Unknown | |
conv_rev | Unknown | |
conversion_tracker | Unknown | |
cost | Unknown | |
creatives_img_url | Unknown | |
creatives_size | Unknown | |
ctr | Unknown | |
cvr | Unknown | |
date | Unknown | |
display | Unknown | |
domain | Unknown | |
ecpa | Unknown | |
ecpc | Unknown | |
ecpcl | Unknown | |
ecpe | Unknown | |
ecpm | Unknown | |
ecpv | Unknown | |
end_date | Unknown | |
engage_rate | Unknown | |
full_domain | Unknown | |
heading | Unknown | |
imp | Unknown | |
ios_id | Unknown | |
is_android | Unknown | |
is_ios | Unknown | |
line_item | Unknown | |
ltr | Unknown | |
measure_ias | Unknown | |
native_ad | Unknown | |
nativead | Unknown | |
page_start | Unknown | |
page_time | Unknown | |
page_time_15_s | Unknown | |
page_time_units | Unknown | |
profit | Unknown | |
rcpa | Unknown | |
rcpc | Unknown | |
rcpcl | Unknown | |
rcpe | Unknown | |
rcpm | Unknown | |
revenue | Unknown | |
s_conv | Unknown | |
sconv_click | Unknown | |
sconv_imp | Unknown | |
seller | Unknown | |
source | Unknown | |
start_date | Unknown | |
stats_50_v_2_s_ias | Unknown | |
sub_advertiser | Unknown | |
sub_advertiser_id | Unknown | |
superbanned | Unknown | |
tagline | Unknown | |
tp_cpc_cost | Unknown | |
tp_cpm_cost | Unknown | |
uniq_conv | Unknown | |
uniq_ecpa | Unknown | |
uniq_imp | Unknown | |
unique_imp | Unknown | |
unique_imp_inverse_rate | Unknown | |
vcomp_0 | Unknown | |
vcomp_25 | Unknown | |
vcomp_50 | Unknown | |
vcomp_75 | Unknown | |
vcomp_95 | Unknown | |
vcomp_rate | Unknown | |
view_percent | Unknown |