Pinterest Ads schema

15 tables · 21 joins

About the connector Start free

15 tables

Loading diagram…

ad

17

id

string

ad_group_id

string

ad_account_id

string

campaign_id

string

pin_id

string

collection_items_destination_url_template

string

creative_type

string

destination_url

string

is_pin_deleted

boolean

name

string

status

string

created_time

date

review_status

string

summary_status

string

type

string

updated_time

date

_weld_synced

date

ad_account

7

id

string

name

string

owner_username

string

country

string

currency

string

permissions

string

_weld_synced

date

ad_account_country_report

55

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

ad_account_report

54

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

ad_group

23

id

string

ad_account_id

string

campaign_id

string

auto_targeting_enabled

boolean

bid_in_micro_currency

int

bid_strategy_type

string

budget_in_micro_currency

int

budget_type

string

end_time

date

lifetime_frequency_cap

int

name

string

ad_group_country_report

50

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

CAMPAIGN_LIFETIME_SPEND_CAP

long

ad_group_report

49

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

CAMPAIGN_LIFETIME_SPEND_CAP

long

ad_report

50

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

board

6

id

string

name

string

description

string

owner

string

owner_username

string

_weld_synced

date

campaign

15

id

string

ad_account_id

string

campaign_budget_optimization_enabled

boolean

daily_spend_cap

long

end_time

date

lifetime_spend_cap

long

name

string

start_time

date

status

string

created_time

date

campaign_country_report

55

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

campaign_report

54

DATE

date

AD_ACCOUNT_ID

string

AD_GROUP_ENTITY_STATUS

string

AD_GROUP_ID

string

AD_ID

string

CAMPAIGN_DAILY_SPEND_CAP

long

CAMPAIGN_ENTITY_STATUS

string

CAMPAIGN_ID

string

keyword

9

id

string

archived

boolean

parent_id

string

parent_type

string

type

string

bid

long

match_type

string

value

string

_weld_synced

date

pin

10

id

string

board_id

string

created_at

string

link

string

title

string

description

string

dominant_color

string

alt_text

string

board_owner

string

_weld_synced

date

product_group

19

id

string

ad_group_id

string

type

string

bid_in_micro_currency

long

included

boolean

definition

string

relative_definition

string

parent_id

string

slideshow_collections_title

string

slideshow_collections_description

string