Snapchat Ads schema and ERD

25 tables

Loading diagram…

string

ad_account_id

string

organization_id

string

ad_squad_id

string

creative_id

string

name

string

review_status

string

status

string

type

string

delivery_status

string

deleted

boolean

updated_at

date

created_at

date

_weld_synced

date

ad_account

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

name

string

type

string

status

string

currency

string

timezone

string

advertiser

string

lifetime_spend_cap_micro

long

test

boolean

_weld_synced

date

ad_daily_report

ad_account_id

string

organization_id

string

ad_id

string

date

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

attachment_quartile_3

long

attachment_total_view_time_millis

long

ad_demographic_daily_report

ad_account_id

string

organization_id

string

ad_id

string

date

age

string

age_bucket

string

gender

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

ad_device_daily_report

ad_account_id

string

organization_id

string

ad_id

string

date

string

operating_system

string

make

string

model

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

ad_geo_daily_report

ad_account_id

string

organization_id

string

ad_id

string

date

country

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

attachment_quartile_3

long

ad_squad

string

ad_account_id

string

organization_id

string

campaign_id

string

pixel_id

string

updated_at

date

created_at

date

name

string

status

string

type

string

placement

string

platforms

string

billing_event

string

ad_squad_daily_report

ad_account_id

string

organization_id

string

ad_squad_id

string

date

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

attachment_quartile_3

long

attachment_total_view_time_millis

long

ad_squad_demographic_daily_report

ad_account_id

string

organization_id

string

ad_squad_id

string

date

age

string

age_bucket

string

gender

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

ad_squad_device_daily_report

ad_account_id

string

organization_id

string

ad_squad_id

string

date

string

operating_system

string

make

string

model

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

ad_squad_geo_daily_report

ad_account_id

string

organization_id

string

ad_squad_id

string

date

country

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

attachment_quartile_3

long

billing_center

string

organization_id

string

updated_at

date

created_at

date

name

string

email_address

string

address_line_1

string

locality

string

administrative_district_level_1

string

country

string

postal_code

string

_weld_synced

date

campaign

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

name

string

daily_budget_micro

long

lifetime_spend_cap_micro

long

objective

string

delivery_status

string

deleted

boolean

status

string

start_time

date

end_time

date

_weld_synced

date

campaign_daily_report

ad_account_id

string

organization_id

string

campaign_id

string

date

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

attachment_quartile_3

long

attachment_total_view_time_millis

long

campaign_demographic_daily_report

ad_account_id

string

organization_id

string

campaign_id

string

date

age_bucket

string

gender

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

campaign_device_daily_report

ad_account_id

string

organization_id

string

campaign_id

string

date

operating_system

string

make

string

model

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

campaign_geo_daily_report

ad_account_id

string

organization_id

string

campaign_id

string

date

country

string

android_installs

long

attachment_avg_view_time_millis

long

attachment_impressions

long

attachment_quartile_1

long

attachment_quartile_2

long

attachment_quartile_3

long

creative

string

ad_account_id

string

organization_id

string

brand_name

string

call_to_action

string

headline

string

shareable

boolean

name

string

top_snap_media_id

string

top_snap_crop_position

string

type

string

funding_source

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

type

string

card_type

string

name

string

last_4

string

expiration_month

string

expiration_year

string

invoice

ad_account_id

string

organization_id

string

invoice_id

string

netsuite_file_id

string

customer_name

string

customer_netsuite_id

string

document_number

string

line_last_modified

date

last_modified

date

amount_cent

long

currency

string

media

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

name

string

type

string

media_status

string

_weld_synced

date

member

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

email_address

string

display_name

string

member_status

string

_weld_synced

date

organization

string

updated_at

date

created_at

date

name

string

address_line_1

string

locality

string

administrative_district_level_1

string

country

string

postal_code

string

type

string

_weld_synced

date

pixel

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

effective_status

string

name

string

status

string

pixel_javascript

string

_weld_synced

date

segment

string

ad_account_id

string

organization_id

string

updated_at

date

created_at

date

name

string

description

string

status

string

source_type

string

retention_in_days

long

approximate_number_users

long

_weld_synced

date