Smadex
Explore the interactive ERD
Table & Field Reference
line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
campaign_id | Unknown | FK |
bidding_status | Unknown | |
list_type | Unknown | |
name | Unknown | |
status | Unknown |
line_limit
| Column | Type | Keys |
|---|---|---|
line_id | Unknown | PKFK |
budget_daily | Unknown | |
budget_hourly | Unknown | |
budget_total | Unknown | |
clicks_daily | Unknown | |
clicks_hourly | Unknown | |
clicks_total | Unknown | |
conversions_daily | Unknown | |
conversions_hourly | Unknown | |
conversions_total | Unknown | |
impressions_daily | Unknown | |
impressions_hourly | Unknown | |
impressions_total | Unknown |
line_test
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ab_test_id | Unknown | PKFK |
line_id | Unknown | |
option_volume | Unknown | |
test_id | Unknown |
ab_test
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
description | Unknown | |
name | Unknown | |
status | Unknown |
lines_bulk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
name | Unknown | |
optimization_goal | Unknown |
line_core
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
account_id | Unknown | FK |
adops_manager_id | Unknown | |
adops_manager_name | Unknown | |
agency_id | Unknown | |
agency_name | Unknown | |
app_bundle | Unknown | |
audit_status | Unknown | |
category | Unknown | |
domain | Unknown | |
effective_landing_url | Unknown | |
label_1 | Unknown | |
label_2 | Unknown | |
label_3 | Unknown | |
name | Unknown | |
schedule_end_date | Unknown | |
schedule_start_date | Unknown | |
status | Unknown | |
tracking_group | Unknown |
audience
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
audience_type | Unknown | |
country | Unknown | |
country_name | Unknown | |
created_at | Unknown | |
dmp | Unknown | |
dmp_id | Unknown | |
last_updated | Unknown | |
name | Unknown | |
number_of_users | Unknown | |
os | Unknown | |
price | Unknown | |
score | Unknown | |
status | Unknown | |
type_code | Unknown | |
type_description | Unknown | |
type_name | Unknown | |
updated_at | Unknown |
line_geo_targeting
| Column | Type | Keys |
|---|---|---|
line_id | Unknown | PKFK |
cities_allow_list | Json | |
cities_deny_list | Json | |
countries | Json | |
enhanced_geo_accuracy | Unknown | |
precision | Unknown | |
radius | Unknown |
line_algorithm
| Column | Type | Keys |
|---|---|---|
line_id | Unknown | PKFK |
bidding_algorithm_event_group | Unknown | |
bidding_algorithm_objective | Unknown | |
bidding_algorithm_objective_price | Unknown | |
filter_algorithm | Json |
line_daypart
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_id | Unknown | PKFK |
day | Unknown | |
hour_end | Unknown | |
hour_start | Unknown | |
min_end | Unknown | |
min_start | Unknown |
list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
account_name | Unknown | |
created_at | Unknown | |
is_exclusive | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown |
permission
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
users_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
email | Unknown | |
entity_id | Unknown | |
headless | Unknown | |
mfa_enabled | Unknown | |
name | Unknown | |
type | Unknown |
creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
folder_id | Unknown | FK |
attribute | Json | |
audit_status | String | |
click_tracking | Unknown | |
click_url | Unknown | |
cta | Unknown | |
cta_text | Unknown | |
description | Unknown | |
designed_by_smadex | Unknown | |
duration | Unknown | |
endcard_cta_text | Unknown | |
endcard_has_cta | Unknown | |
endcard_is_last_frame | Unknown | |
endcard_is_tricky | Unknown | |
endcard_type | Unknown | |
format | Unknown | |
has_cta | Unknown | |
icon | Unknown | |
icon_height | Unknown | |
icon_weight | Unknown | |
icon_width | Unknown | |
image | Unknown | |
image_height | Unknown | |
image_name | String | |
image_width | Unknown | |
impression_pixel | Json | |
is_ssl | Unknown | |
label | Json | |
lookalike_identifier | Unknown | |
name | Unknown | |
original_creative_id | Unknown | |
rating | Unknown | |
rewarded | Unknown | |
short_description | Unknown | |
size | Unknown | |
sponsored | Unknown | |
ssl_compliant | Unknown | |
status | Unknown | |
style | Unknown | |
tags | Unknown | |
theme | Unknown | |
title | Unknown | |
type | Unknown |
line_publisher_scan
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_id | Unknown | PKFK |
attribution | Unknown | |
budget | Unknown | |
click | Unknown | |
enabled | Unknown | |
event | Unknown | |
impression | Unknown | |
min_event | Unknown | |
should_reset | Unknown |
folder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
all_creatives_paused | Unknown | |
bidding_status | Unknown | |
expires_at | Unknown | |
name | Unknown | |
number_of_creatives | Unknown | |
starts_at | Unknown | |
status | Unknown | |
week_day_friday | Unknown | |
week_day_monday | Unknown | |
week_day_saturday | Unknown | |
week_day_sunday | Unknown | |
week_day_thursday | Unknown | |
week_day_tuesday | Unknown | |
week_day_wednesday | Unknown |
fixed_event
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
user_event | Unknown |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
advertiser_domain | Unknown | |
alternate_domain | Unknown | |
app_bundle | Unknown | |
area_id | Unknown | |
budget_daily_cap | Unknown | |
budget_delivered | Unknown | |
budget_hourly_cap | Unknown | |
budget_total_cap | Unknown | |
campaign_manager_id | Unknown | |
category | Unknown | |
created_at | Unknown | |
expires_at | Unknown | |
goal | Unknown | |
goal_description | Unknown | |
goal_event_name | Unknown | |
label_1 | Unknown | |
label_2 | Unknown | |
landing_url | Unknown | |
limit_conversation_action | Unknown | |
limit_daily_max_conversation | Unknown | |
limit_daily_spent_conversation | Unknown | |
name | Unknown | |
numeric_goal | Unknown | |
starts_at | Unknown | |
status | Unknown | |
training_enabled | Unknown | |
type | Unknown | |
updated_at | Unknown |
exchange
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
admin_email | Unknown | |
auction_type | Unknown | |
bid_below_pf | Unknown | |
bidloss_active | Unknown | |
capability | Unknown | |
consent_policy | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
display_name | Unknown | |
financial_entity_id | Unknown | |
group_name | Unknown | |
is_active | Unknown | |
logo | Unknown | |
price_floor | Unknown | |
s_2_s | Unknown | |
skoverlay_supported | Unknown | |
updated_at | Unknown | |
visible | Unknown | |
win_url_beacon | Unknown |
category
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
description | Unknown | |
id | Unknown | |
lang | Unknown | |
name | Unknown |
account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agency_id | Unknown | |
agency_name | Unknown | |
campaign_count | Unknown | |
created_at | Unknown | |
currency_tag | Unknown | |
enforce | Unknown | |
name | Unknown | |
organization | Unknown | |
revenue | Unknown | |
top_up | Unknown | |
unlimited | Unknown |
line_targeting_device_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
line_id | Unknown | PKFK |
os_name | Unknown | |
type | Unknown |
line_device_targeting
| Column | Type | Keys |
|---|---|---|
line_id | Unknown | PKFK |
ad_positions | Json | |
browsers | Json | |
carrier_allow_list | Json | |
carrier_deny_list | Json | |
connection_type | Unknown | |
device_model_allow_list | Json | |
device_model_deny_list | Json | |
frequency_capping_campaign_mode | Unknown | |
frequency_capping_deterministic_mode | Json | |
frequency_capping_hits | Unknown | |
frequency_capping_mode | Unknown | |
frequency_capping_period | Unknown | |
frequency_capping_probabilistic_mode | Json | |
interstitial | Unknown | |
languages | Json | |
line_request_filter_asset_type | Unknown | |
line_request_filter_device_id_restriction | Unknown | |
os_version_ranges | Json | |
placement_ids | Json | |
rewarded | Unknown | |
skad_network | Unknown | |
skad_versions | Json | |
skad_vta_mandatory | Unknown | |
skippability_non_skippable | Unknown | |
skippability_skippable | Unknown | |
skippability_unknown | Unknown | |
traffic_type | Unknown |
report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
account_id | Unknown | FK |
campaign_id | Unknown | FK |
creative_id | Unknown | FK |
line_id | Unknown | FK |
account_name | Unknown | |
ad_campaign_id | Unknown | |
ad_campaign_name | Unknown | |
advertiser_bundle | Unknown | |
advertiser_domain | Unknown | |
agency_id | Unknown | |
agency_name | Unknown | |
buys | Unknown | |
buys_rate | Unknown | |
clicks | Unknown | |
completed_views | Unknown | |
completed_views_rate | Unknown | |
country | Unknown | |
cp_buys | Unknown | |
cp_completed_views | Unknown | |
cp_first_quartile_views | Unknown | |
cp_funnel_step_1 | Unknown | |
cp_funnel_step_2 | Unknown | |
cp_funnel_step_3 | Unknown | |
cp_installs | Unknown | |
cp_landings | Unknown | |
cp_mid_point_views | Unknown | |
cp_other_conversions | Unknown | |
cp_registrations | Unknown | |
cp_skips | Unknown | |
cp_subscriptions | Unknown | |
cp_third_quartile_views | Unknown | |
cp_views | Unknown | |
cpc | Unknown | |
cpm | Unknown | |
creative_name | Unknown | |
creative_url | Unknown | |
ctr | Unknown | |
currency | Unknown | |
date_time | Unknown | |
device_os | Unknown | |
exchange_name | Unknown | |
first_quartile_views | Unknown | |
first_quartile_views_rate | Unknown | |
funnel_step_1 | Unknown | |
funnel_step_1_rate | Unknown | |
funnel_step_2 | Unknown | |
funnel_step_2_rate | Unknown | |
funnel_step_3 | Unknown | |
funnel_step_3_rate | Unknown | |
impressions | Unknown | |
installs | Unknown | |
installs_rate | Unknown | |
inventory_bundle | Unknown | |
inventory_domain | Unknown | |
inventory_id | Unknown | |
inventory_key | Unknown | |
inventory_name | Unknown | |
landings | Unknown | |
landings_rate | Unknown | |
media_spend | Unknown | |
mid_point_views | Unknown | |
mid_point_views_rate | Unknown | |
other_conversions | Unknown | |
other_conversions_rate | Unknown | |
registrations | Unknown | |
registrations_rate | Unknown | |
skips_rate | Unknown | |
subscriptions | Unknown | |
subscriptions_rate | Unknown | |
third_party_spend | Unknown | |
third_quartile_views | Unknown | |
third_quartile_views_rate | Unknown | |
total_spend | Unknown | |
views | Unknown | |
views_rate | Unknown |