Reddit Ads schema

34 tables · 15 joins

About the connector Start free

34 tables

Loading diagram…

ad

ad_group

ad

30

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

ad_click_url_query_parameter

4

ad_id

string

name

string

value

string

_weld_synced

date

ad_event_tracker

4

ad_id

string

type

string

url

string

_weld_synced

date

ad_product

3

ad_id

string

product_id

string

_weld_synced

date

ad_account

19

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

ad_account_history

13

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

ad_group

32

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

ad_group_targeting_carrier

3

ad_group_id

string

carrier

string

_weld_synced

date

ad_group_targeting_community

4

ad_group_id

string

community

string

excluded

boolean

_weld_synced

date

ad_group_targeting_custom_audience

4

ad_group_id

string

custom_audience_id

string

excluded

boolean

_weld_synced

date

ad_group_targeting_device

7

ad_group_id

string

max_version

string

min_version

string

os

string

type

string

label_map

string

_weld_synced

date

ad_group_targeting_geolocation

4

ad_group_id

string

geolocation

string

excluded

boolean

_weld_synced

date

ad_group_targeting_interest

3

ad_group_id

string

interest

string

_weld_synced

date

ad_group_targeting_keyword

4

ad_group_id

string

keyword

string

excluded

boolean

_weld_synced

date

ad_group_targeting_location

3

ad_group_id

string

location

string

_weld_synced

date

ad_group_targeting_platform

3

ad_group_id

string

platform

string

_weld_synced

date

ad_group_targeting_suppression_event_type

3

ad_group_id

string

suppression_event_type

string

_weld_synced

date

ad_group_targeting_view_mode

3

ad_group_id

string

view_mode

string

_weld_synced

date

ad_group_schedule

6

ad_group_id

string

end_day

int

end_hour

int

start_day

int

start_hour

int

_weld_synced

date

ad_group_shopping_targeting_conversion_event_type

4

ad_group_id

string

conversion_event_type

string

excluded

boolean

_weld_synced

date

business

13

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

27

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

carrier

4

id

string

name

string

country_code

string

_weld_synced

date

community

7

id

string

categories

string

description

string

icon_url

string

name

string

subscriber_count

long

_weld_synced

date

custom_audience

32

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

device

3

make

string

model

string

_weld_synced

date

funding_instrument

12

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

8

id

string

country

string

dma

int

name

string

postal_code

string

city

string

region

string

_weld_synced

date

industry

3

id

string

display

string

_weld_synced

date

interest

4

id

string

category

string

name

string

_weld_synced

date

pixel

10

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

13

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

6

id

string

business_id

string

modified_at

date

name

string

reddit_user_id

string

_weld_synced

date

time_zone

7

id

string

code

string

dst_offset

double

is_dst_active

boolean

name

string

offset

int

_weld_synced

date