ERD for Reddit Ads | Weld

18 tables

Loading diagram…

ad

id

string

ad_account_id

string

ad_group_id

string

campaign_id

string

profile_id

string

campaign_objective_type

string

click_url

string

configured_status

string

created_at

date

delivery_status

string

effective_status

string

modified_at

date

name

string

preview_expiry

date

preview_url

string

rejection_reason

string

skadnetwork_metadata_status

string

post_id

string

post_url

string

profile_username

string

shopping_creative_allow_comments

boolean

shopping_creative_call_to_action

string

shopping_creative_destination_url

string

shopping_creative_headline

string

shopping_creative_second_line_cta

string

shopping_creative_dpa_carousel_mode

string

shopping_creative_hero_card_image_url

string

shopping_creative_hero_card_destination_url

string

type

string

_weld_synced

date

ad_account

id

string

business_id

string

time_zone_id

string

admin_approval

string

attribution_type

string

click_attribution_window

string

created_at

date

currency

string

modified_at

date

name

string

pixel_partner_preferences

string

primary_contact_member_id

string

suspension_reason

string

type

string

view_attribution_window

string

excluded_communities

string

excluded_keywords

string

spend_cap_type

string

_weld_synced

date

ad_account_history

cause_changed_at

date

change_entity_id

string

change_field_name

string

cause_email

string

cause_fullname

string

cause_member_id

string

cause_partner_business_name

string

cause_reddit_username

string

change_after_value

string

change_before_value

string

change_entity_name

string

change_entity_type

string

_weld_synced

date

ad_group

id

string

ad_account_id

string

campaign_id

string

bid_type

string

bid_value

int

campaign_objective_type

string

configured_status

string

created_at

date

delivery_status

string

effective_status

string

end_time

date

goal_type

string

goal_value

int

is_campaign_budget_optimization

boolean

modified_at

date

name

string

optimization_goal

string

start_time

date

view_through_conversion_type

string

conversion_pixel_id

string

app_id

string

bid_strategy

string

optimization_strategy_type

string

product_set_id

string

saved_audience_id

string

shopping_type

string

skadnetwork_metadata_status

string

targeting_expand_targeting

string

targeting_gender

string

shopping_targeting_lookback_window_days

int

shopping_targeting_targeting_type

string

_weld_synced

date

business

id

string

agency_affiliated

boolean

country

string

created_at

date

creator_id

string

industry

string

modified_at

date

name

string

phone

string

primary_contact_id

string

two_fa_enforcement

string

website_url

string

_weld_synced

date

campaign

id

string

ad_account_id

string

funding_instrument_id

string

app_id

string

bid_strategy

string

bid_type

string

bid_value

long

configured_status

string

conversion_pixel_id

string

created_at

date

delivery_status

string

effective_status

string

end_time

date

goal_type

string

goal_value

long

invoice_label

string

is_campaign_budget_optimization

boolean

modified_at

date

name

string

objective

string

optimization_goal

string

skadnetwork_metadata_status

string

special_ad_categories

string

spend_cap

long

start_time

date

view_through_conversion_type

string

_weld_synced

date

carrier

id

string

name

string

country_code

string

_weld_synced

date

community

id

string

categories

string

description

string

icon_url

string

name

string

subscriber_count

long

_weld_synced

date

custom_audience

id

string

ad_account_id

string

name

string

status

string

created_at

date

delivery_status

string

modified_at

date

size_range_upper

long

size_range_lower

long

type

string

engagement_audience_config_tracking_types

string

engagement_audience_config_lookback_window_days

int

engagement_audience_config_campaign_ids

string

lookalike_config_source_audience_id

string

lookalike_config_audience_size

string

pixel_audience_config_targetings

string

pixel_audience_config_lookback_window_days

int

pixel_audience_config_custom_targetings

string

pixel_audience_config_pixel_ids

string

customer_list_config_origin

string

customer_list_config_external_audience_id

string

customer_list_config_origin_client_id

string

cost_partner

string

cost_partner_segment_id

string

cost_reddit_audience_id

string

cost_rate_type

string

cost_price

long

cost_currency

string

cost_currency_conversion_rate_to_usd

long

cost_update_timestamp

long

cost_is_cost_exempted

boolean

_weld_synced

date

device

make

string

model

string

_weld_synced

date

funding_instrument

id

string

name

string

currency

string

credit_limit

long

billable_amount

long

start_time

date

end_time

date

is_servable

boolean

reasons_not_servable

string

invoice_group_status

string

authorize_status

string

_weld_synced

date

geolocation

id

string

country

string

dma

int

name

string

postal_code

string

city

string

region

string

_weld_synced

date

industry

id

string

display

string

_weld_synced

date

interest

id

string

category

string

name

string

_weld_synced

date

pixel

id

string

business_id

string

name

string

created_at

date

created_by

string

modified_at

date

modified_by

string

automatic_matching_config_collect_email

boolean

automatic_matching_config_collect_phone_number

boolean

_weld_synced

date

product_catalog

id

string

business_id

string

name

string

default_currency

string

default_language

string

event_sources

string

data_sources

string

summary_products_count

long

summary_approved_products_count

long

summary_rejected_products_count

long

created_at

date

modified_at

date

_weld_synced

date

profile

id

string

business_id

string

modified_at

date

name

string

reddit_user_id

string

_weld_synced

date

time_zone

id

string

code

string

dst_offset

double

is_dst_active

boolean

name

string

offset

int

_weld_synced

date

Table

Sub table